Workaround for triggering generate document workflow when any of the 380 fields I have change
I need a generate document workflow to run anytime one of them changes. I don't want to put in all 380 fields, I don't even know if it will let me add that many. It seem as if the "if any field changes" option is not available on the generate documents workflow, you have to select at least one field.
Best Answer
-
@mccoy_FSI You can create a single backend helper column that joins all of the other columns together and can be used as the trigger for the automation. If anything in the row changes, that backend column will change.
Hope this helps!
Answers
-
You can use the Any Field setting in the When rows change trigger:
-
It forces you to select at least one field when the workflow is to generate a document.
-
@mccoy_FSI You can create a single backend helper column that joins all of the other columns together and can be used as the trigger for the automation. If anything in the row changes, that backend column will change.
Hope this helps!
-
@Kelly P. Yes, that will work. I didn't think of that, thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives