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
- Customer Resources
- 65K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 70 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives