Automated Message Response to Form Completion
I have a form that has a fair amount of branching in it with multiple columns and I have my automation setup to email for approval when a new line is created. My problem is with all the branching the form that is emailed has a lot of blank sections. Is there a way to only include the columns with data?
I see the automation options to include specific fields, but i dont necessarily know what fields will be populated based on how the questions are answered.
thanks for the help!
Best Answer
-
My suggestion would be to insert a helper column (or series of helper columns) that will basically pull together the non-blanks. Then you can reference these columns using {{placeholders}} in the automated email.
Answers
-
My suggestion would be to insert a helper column (or series of helper columns) that will basically pull together the non-blanks. Then you can reference these columns using {{placeholders}} in the automated email.
-
Thanks Paul! That definitely makes sense. How would I consolidate the various columns into one helper cell? For example I have 14 columns that could have data in them. Only 1 of them will ever actually will have anything populated, but it could be 2 options. So theoretically I could have 1 column with 2 different selections.
-
I got it to work simply using join()! Thanks for the help. I forget about the power of helper columns.
-
Happy to help. 👍️
And sorry about that. I actually meant (but forgot to) post the JOIN formula example.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!