Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.
SOLVED

Send Reminder using the Form Dates

Avatar

Level 2

Hi all.

I don't know what is the best way to send reminders (emails) checking the Form dates .

For example:

There is a task assign where the user enter 5 dates (date 1, date 2, date 2.... etc)

Then, I need to send emails to "Xpath user" when the system date  is:  "date 1" - 24 hrs (for example).  The same with date 2 , date 3... etc.

How can I to do it?

Need I to write the dates in Database?

Some Ideas?

Thanks a lot.

Maria

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

You could use a gateway with a branch for each email that will be sent. Put a Wait Point before the send email step. Set the days to wait as an XPath expression using get-days-from-dateTime-difference(current-date(), Form Date). Subtract 1 for your minus 24 hours.

View solution in original post

3 Replies

Avatar

Correct answer by
Former Community Member

You could use a gateway with a branch for each email that will be sent. Put a Wait Point before the send email step. Set the days to wait as an XPath expression using get-days-from-dateTime-difference(current-date(), Form Date). Subtract 1 for your minus 24 hours.

Avatar

Level 2

Thanks !

I'll try  that you tell  me.

The process continue if I select (NO WAIT in the branch), right

Thanks

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----