Updates & Multiple Forms for a Sheet

Hello, I'm working on a somewhat complex workflow and need some help.
I want to send an order form to a customer and when they return the form, track it on an Orders sheet (pretty basic).
Once I know my order has been picked up from the supplier, I'd like to send the recipient an follow up for updating on when they installed their product, location, and ideally have them submit a picture of their install.
1) How do I tie the update information to my order number (key field)?
2) How would I generate this request and send it to the customer using all the data from their order?
3) How would they attach their photo to the form to upload?
Thanks!
Answers
-
Hi @Sandy Laube
I hope you're well and safe!
Have you explored starting the process with a form and then continuing with automated update requests?
Would that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.