URL Query Strings & Contacts

Neil Watson

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?

Paul Newcome

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.

Paul Newcome

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"

Paul Newcome

Here is an article that should help...

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

Neil Watson

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"

Paul Newcome

I forgot about the LOWER part. Glad you were able to get it working.

Neil Watson

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)!

Paul Newcome

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.