URL Query Strings & Contacts
Hi
I am using a query string with a form URL to prepopulate a form with row information, which is passed to another sheet.
All works but I am have challenges with passing contact info.
The source form has a column property of "Contact List", and the target form has a similarly formatted column. However, despite various permutations, I cannot get the form populated with the contact.
Any ideas?
Best Answer
-
You would have to find a way to capture their actual email address. Maybe in a text/number column so it doesn't try to convert it to a name in a Contact column.
Answers
-
You are going to need to use a SUBSTITUTE function to replace the @ with the appropriate value.
="main_part_of_url" + SUBSTITUTE([Contact Column]@row, "@", "%40") + "rest_of_url"
-
Here is an article that should help...
-
Thanks @Paul Newcome, the issue is that when I reference the contact details field, it pulls through the name of the person as opposed to the email address. So I have to recreate the email address (which I have now done). It works because in this sheet the contacts are all internal. Also needs to be in lower case to work.
...."&Requested%20by=" + LOWER(SUBSTITUTE(Owner@row, " ", ".")) + "@email.com"
-
I forgot about the LOWER part. Glad you were able to get it working.
-
Thanks @Paul Newcome, the solution only works in this case because the contacts are all from the same company. If the contacts were from multiple domains then I don't have a solution (yet)!
-
You would have to find a way to capture their actual email address. Maybe in a text/number column so it doesn't try to convert it to a name in a Contact column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!