Forms - Workflow to track submission
Hi,
Is it possible to populate an existing row using forms? The idea is we have two existing columns (Customer and Due date)and the rest are from the form.
If no reply has been made past the due date, a workflow would automatically send an email to the recipient reminding to complete the form. The problem is, form submissions create their own row resulting to these existing values being useless.
Any work around for this? I am thinking of using this format but instead of count I would use a checkbox then would manually check them if submission has been made. Issue with this is I can't have the whole column as symbol as I have values from the forms below and it does not look nice at all.
Any suggestions for this? Thanks
Answers
-
Hi Mo,
I’d recommend having a look at using update requests instead or in combination with a form.
More info:
Would that work?
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
-
The problem with update request is we can only share specific rows. There is a need to have the input by forms.
-
An update request can be sent based on specific row criteria so that only the allowed rows are sent.
-
Can you describe your process in more detail? Why don't you think that Update Requests would work?
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 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!