I have a bot set up to generate a PDF file whenever a certain column value is TRUE. It works fine, but every time anything is changed in the row, the bot is triggered again and a duplicate PDF file is created. The column values being changed are not in the PDF template, so it is always the same exact file. I keep ending up with 3-4 of the same PDF being generated. Is there any way to make it so the PDF is only generated once, only when the trigger value is changed to TRUE?
Hi @hcampbell
Welcome to the community !
Yes you can do so, you must add a condition on the event (assuming the bot is triggered with an update event)
Itโs like that:
AND(
[_THISROW_BEFORE].[triggerYesNo]<>[_THISROW_AFTER].[triggerYesNo],
[_THISROW_AFTER].[triggerYesNo]
)
Note that if [triggerYesNo]
is a YesNo type, then
[triggerYesNo]
is equivalent to [triggerYesNo]=true
This worked! Thank you! Would never have figured that out on my own.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |