Pre populating multiple fields in forms

Justin Mauzy

I am trying to populate multiple fields in a form using:

="https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?" + "Date=" + Date@row

This work perfectly.

I also want to populate these fields:

• Team
• Issue
• Notes

When I try to add another field using:

="https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?" + "Date=" + Date@row + "Team=" + Team@row

It builds this link:

https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?Date=05/01/22Team=TAMPFC01

And here is what I get:

I am sure that I have the formula wrong but cannot figure it out.

Thanks in advance for the help.

Andrée Starå

Hi @Justin Mauzy

I hope you're well and safe!

Try something like this. (you were missing the ampersand & for more values)

https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?Date=05/01/22&Team=TAMPFC01

Did that work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Justin Mauzy

I am getting an #UNPARSEABLE error now.. If I remove the " and the +, I get the error.

And thank you for the quick response.

Andrée Starå

@Justin Mauzy

Happy to help!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Justin Mauzy

I just got it to work except for 1 thing. Here is the formula:

="https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?Date=" + Date@row + "&Team=" + Team@row + "&Issue=" + SUBSTITUTE(Issue@row, " ", "%20") + "&Notes=" + SUBSTITUTE(Notes@row, " ", "%20")

One of the columns is a a dropdown with multiple choices.

When the link generates, the form will only show the 1st choice.

Any ideas on how to make it populate all of the choices?

Justin Mauzy

To get it to work in the URL, I had to do the following:

I created another column called IssueText. I then used the following formula:

=IF(COUNTM(Issue@row) > 0, "Issues: " + CHAR(10) + SUBSTITUTE(SUBSTITUTE(Issue@row, CHAR(10), CHAR(10), COUNTM(Issue@row) - 1), CHAR(10), CHAR(10)), "")

This takes the selections from the multiple dropdown and then makes it text with returns.

Here was the original formula:

="https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?Date=" + Date@row + "&Team=" + Team@row + "&Issue=" + SUBSTITUTE(Issue@row, " ", "%20") + "&Notes=" + SUBSTITUTE(Notes@row, " ", "%20")

I then had to change the formula (in bold below):

="https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?Date=" + Date@row + "&Team=" + Team@row + "&Issues=" + SUBSTITUTE(SUBSTITUTE(IssueText@row, " ", "%20"), CHAR(10), "%0A") + "&Notes=" + SUBSTITUTE(Notes@row, " ", "%20")

I switch the field in the form from the Issue to IssueText, changed the Label to "Issues" and made it multi line (10 lines). Here is the end result: