I use a Form where the user can define the amount how often a PDF should be printed.
After saving the form, a workflow rule is fired and the PDF ist sent to the Printer’s Email Address.
So if the user set’s the [Amount] to 5, the Workflow should send the PDF 5 times to the printer’s EMail Address.
How could I do that?
I tried several possibilities:
Decrement Count via Workflow
In the Workflow I set a second action after sending the Email: An Action that simply does: [Amount]-1
The idea is: After sending the Email, the Workflow will be triggered again, because the row changed.
Result: Email is sent, [Amount]-1 is done, but no other Email is sent.
Decrement Count via Action
I tried @Steve’s idea Add any number of rows from any row within a table. So by saving the form, an Action is doing [Amount]-1 until [Amount]=1.
The idea is: The Workflow would fire each time the [Amount] changes. So if the user would define [Amount] = 5, then it would fire five times.
Result: The Workflow fires only 2 times: One time when the row is saved and on time when [Amount] = 1. It seems as the changes of [Amount] are happening so fast, that AppSheet doesn’t recognize them.
So instead of going down from 5 - 4 - 3 - 2 - 1, it’s going down from 5 - 1. This is what I can see also in the Spreadsheet.
Using To, CC and BCC
This is the only working solution right now. I set them like this:
To: Printer_Email_Address
CC: IFS([Amount]>1,Printer_Email_Address)
BCC: IFS([Amount]>2,Printer_Email_Address)
Result: This is working, but I can sent the same Workflow only max 3 times.
If I use expressions in “To” like
IFS([Amount]>1,Printer_Email_Address)
IFS([Amount]>2,Printer_Email_Address)
IFS([Amount]>3,Printer_Email_Address)
They will be ignored.
Maybe someone has a Tip for me?
LinkedIn
Twitter
