Pre populating multiple fields in forms

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:

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.

Answers

  • Andrée Starå
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Justin Mauzy
    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å
    Andrée Starå ✭✭✭✭✭✭
    edited 08/04/22

    @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, [email protected])

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Justin Mauzy
    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
    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:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!