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?
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
This worked! Thank you! Would never have figured that out on my own.