How can I concatenate a field including unique ID?

  • Profile Image
    David_Potter_dpotter
    Asked on January 14, 2022 at 12:31 PM

    I've created a form for our design team for users to submit requests. Upon submission, we're pushing the completed file over to Box and would like the folder name to be: unique_ID (sequential number)-Department Code-Project Title. If I can't pull that unique ID value, is there a way to replicate the sequential numbering using other fields/widgets?

  • Profile Image
    Parker
    Answered on January 14, 2022 at 03:31 PM

    Hello,

    I don't see any unique id fields on your form to be able to insert into the folder name. If you have one on the form you should see it in the form field like so.

    1642192285_61e1dd9d05cfe_

  • Profile Image
    David_Potter_dpotter
    Answered on January 19, 2022 at 09:45 AM

    Hi Parker,

    That would work great, but what I'm wanting to accomplish is a folder name that is comprised of the following:

    UniqueID_DeptCode-Project Title. I currently can pull together the last two fields, but am unable to capture the UniqueID. I'm unsure if there is an alternative on how to make this work?

  • Profile Image
    Amos_W
    Answered on January 19, 2022 at 10:59 AM

    Hey there,

    You can add a unique ID widget and then make a form calculation widger field that will take all three fields, It would look something like that


    1642607826_61e834d2bede3_

    (if I'm not mistaken by the field names)

    I've cloned your form, you can clone that and see what I did

    https://form.jotform.com/220184095463960

    Please let us know if you need any further assistance,

    Thank you

  • Profile Image
    David_Potter_dpotter
    Answered on January 19, 2022 at 11:37 AM

    Hi Amos,

    I've done as you instructed, and it doesn't pull in the uniqueID widget value. Is that because the uniqueID widget doesn't commit a value until submission?

  • Profile Image
    Parker
    Answered on January 19, 2022 at 01:02 PM

    Hello,

    That's correct. The value for the unique ID doesn't get generated until the submission so it won't pull in like this before the submission and thus won't be part of it. You can add form values to the prefix of the Unique ID and then you should be able to use that value for your folder name. Unfortunately it will be before the Unique ID though.

    1642615033_61e850f945f4c_

  • Profile Image
    David_Potter_dpotter
    Answered on January 19, 2022 at 01:54 PM

    Hi Parker,

    That's a good alternative. Is there another way to simulate the sequential numbering of the uniqueID widget with another control/widget to acheive the format I'm looking for?

  • Profile Image
    Parker
    Answered on January 19, 2022 at 03:04 PM

    Hello,

    I'm not able to think of any alternatives for this as there aren't any other widgets that come to mind that do sequential numbering.

  • Profile Image
    David_Potter_dpotter
    Answered on January 19, 2022 at 03:52 PM

    Thanks Parker, appreciate all the help you and your team have provided!