Identifing rows based on multiple form sources
We have a form which is sent to customers to register their commercial contact details. The customer doesn't always know which product they are receiving so this is added to a sheet column after population. However, a new row triggers notifications to various internal stakeholders and they receive this notification before the product column has been populated. Whilst the notification workflow could include a step where the notification is not sent until the additional column is populated, it would be great it this column could auto populate based on the form origins.
The ideal solution would be for each sales department to have their own form populating the same sheet but how can we automatically identify which rows are populated by which form?
Thanks
Comments
-
Hi,
You could add a hidden field in the form to include where the form is coming from.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes, this will work perfectly - thanks for the amazing response time.
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives