I am having the 15 records in employee table,
I need to send a email workflow to all 15 employee , when I click the action button Sent email
Suggest any idea to achieve
1 = Create an action that sets EmployeeTable[ColumnX]=โSend Emailโ
2 = Create an action that sets EmployeeTable[ColumnX]=""
3 = Create an action that โexecute a sequence of actionsโ that does 1 then two above
4 = Create an action that โexecute an action on a set of rowsโ where โreferenced actionโ is 3 above.
5 = Make action 4 above to โDisplay prominantlyโ. 1, 2 & 3 set to โdo not displayโ
6 = Create a workflow so that it sends an email when EmployeeTable[ColumnX]=โSend Emailโ
This should set EmployeeTable[ColumnX]=โSend Emailโ then clear it on all 15 rows. Each change will trigger a seperate workflow. Note you need the workflow email to be set to EmployeeTable[Email Address]
hope this helps
Hi,
check out this article https://help.appsheet.com/en/articles/961707-workflow
There is a topic called " Sending Email from an Action Button" that shows an example.
And in your case when you are creating your workflow rule, you can set the โToโ filed with an expression like this โ โEmployeeTable[Email]โ. This will send the email to a list of addresses.
Hope this helps!
User | Count |
---|---|
40 | |
28 | |
22 | |
20 | |
15 |