Prepopulate form with information
We are wanting to send an email to our customers asking them to confirm whether the company/contact details we have for them are correct. This means we would need to upload the details we have into a sheet and then send them a link to check their details specifically. We don't want them to have to populate a blank form when we already have most of their details.
Can smartsheet achieve this or does someone know of a platform that does?
Answers
-
Yes, Smartsheet would be perfect for that use-case.
You’d use Update Requests, and your customers can update their information with ease.
More info:
Would that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or 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.
-
Thanks Andree!
Would the email have to be triggered directly through smartsheet? Ie we couldnt send them a nice looking email from our company domain when we ask them to update their details?
-
Happy to help!
It depends on how automatic you'd want it to be. There are a couple of options.
You could send a nice looking email and have a link to a form where they either add their information or we pre-populate it through personal links.
How many customers do you want to send it to?
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.
-
Thanks Andre,
I was hoping we could insert a link into a nice looking email that we send them. When they click on the link they would see their prepopulated information and just update anything that looked incorrect.
Approx 4000 customers.
Appreciate your help.
-
Hello Andree, just wondering if you had a recommendation in relation to my last comment?
-
We would need to create a form and then use the Query string feature to make each URL unique and pre-filled.
We would,
- add the data that you want to have already included in the form
- build the URL with formulas
- use the data to create the email list
Make sense?
Would that 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.
-
Thanks Andree, certainly sounds promising.
Would it still work if we had 20-30 fields that needed to be prepopulated?
-
You're more than welcome!
I haven't tested that many fields, but I think it will work as long as we don't hit any limitations. For Smartsheet, it's 4000 characters in a cell, but if we hit that limit, we could build the URL somewhere else.
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
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives