Can have more than 1 uniquecode to populate the fields?

  • qhuifong
    Asked on March 24, 2021 at 11:06 AM

    Can have more than 1 uniquecode to populate the fields?

    Meaning using 2 selection e.g. a dropdown selection + short text to populate the fields....

  • Gaetan_B
    Replied on March 24, 2021 at 4:22 PM

    Hello,

    Thank you for reaching out.


    I am not sure about your use case, could you please let us know more about it so we can give you proper guidance?


    Hope this helps.

    Do not hesitate to reach out if you need further assistance.

  • qhuifong
    Replied on March 24, 2021 at 10:11 PM
    Hi Morning,
    Basically what I meant is whether can we use email + short text, or 2 short
    text, which is 2 parameters to populate the fields from excel?
    Thanks,
    Angela
    ...
  • KrisLei Jotform Support
    Replied on March 25, 2021 at 5:27 AM

    Hello Angela,

    To my understanding, you would like to combine two fields that will populate from 2 different parameters on your spreadsheet? If it is, I think this is not possible for the widget to combine 2 data from different columns on your spreadsheet and populate a single field.

    What you can do is to add a Form Calculation widget to concatenate the data from two fields:

    1616664250 605c56ba1aa12 Screenshot 0325 Screenshot 10

    Related guides:

    How-to-perform-form-calculation-using-a-widget

    How-to-add-a-widget-to-your-form

    I hope this helps. But let us know if I have misunderstood your query or if it didn't meet your requirements.

  • qhuifong
    Replied on March 27, 2021 at 9:11 AM
    HI KisLei,
    Thanks for your reply, I have heeded your advice and use Form Calculation
    to populate the fields in my form.
    Many thanks!
    Angela
    ...