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

Find more posts tagged with

Forms

functionality

Automations

Accepted answers

Genevieve P.

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

All comments

Genevieve P.

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

CarlosRod

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

Genevieve P.

Wonderful! I'm glad that worked for you. Looks good! 🙂

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.