Expand my Community achievements bar.

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] ----