Autopopulate Fields from existing columns into a Form
Hi all,
I am trying to autopopulate two fields into my form from two existing columns with data.
I've been following the community and so far I am able to pull one field using this formula:
="Linktotheform............?NameandSurname=" + SUBSTITUTE(NameandSurname@row, " ", "%20")
Like that it works perfectly and I am able to do what I intend, but when I add another field, it does not take it into account. This is the formula I am using:
="Linktotheform............?NameandSurname=" + SUBSTITUTE(NameandSurname@row, " ", "%20") + "&ID=" + SUBSTITUTE(ID@row, " ", "%20")
As a result I get this:
What am I doing wrong in the formula?
I've tried looking into similar posts but I do not get the desired result.
Appreciate your help.
Thank you,
Kind regards,
Carlos
Best Answer
-
Hi @CarlosRod
I believe this is happening due to the email address having a ".com" which is ending the url string in Smartsheet.
Try re-ordering your fields so that you fill in the ID cell first, and then have the email be the last detail in the thread, like so:
="Linktotheform......?ID=" + SUBSTITUTE(ID@row, " ", "%20") + "&NameandSurname=" + SUBSTITUTE(NameandSurname@row, " ", "%20")
Let me know if this resolved it for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @CarlosRod
I believe this is happening due to the email address having a ".com" which is ending the url string in Smartsheet.
Try re-ordering your fields so that you fill in the ID cell first, and then have the email be the last detail in the thread, like so:
="Linktotheform......?ID=" + SUBSTITUTE(ID@row, " ", "%20") + "&NameandSurname=" + SUBSTITUTE(NameandSurname@row, " ", "%20")
Let me know if this resolved it for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thanks a lot, that solved the issue, by putting at the end the e-mail I've been able to add more fields to my formula:
="XXXXXXXX=" + SUBSTITUTE(NameandSurname@row, " ", "%20") + "&ID=" + SUBSTITUTE(ID@row, " ", "%20") + "&ServiceCenter=" + SUBSTITUTE(ServiceCenter@row, " ", "%20") + "&Manager=" + SUBSTITUTE(Manager@row, " ", "%20") + "&E-mail=" + SUBSTITUTE([E-mail]@row, " ", "%20")
-
Wonderful! I'm glad that worked for you. Looks good! 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!