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
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives