How can I concatenate a field including unique ID?

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?

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.

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?

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

(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

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?

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.

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?

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.

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