-
David_Potter_dpotterAsked 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?
Page URL: https://form.jotform.com/220107749738057 -
Parker JotForm SupportReplied on January 14, 2022 at 3: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.
-
David_Potter_dpotterReplied on January 19, 2022 at 9: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?
-
Amos_WReplied 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
(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
-
David_Potter_dpotterReplied 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?
-
Parker JotForm SupportReplied on January 19, 2022 at 1: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.
-
David_Potter_dpotterReplied on January 19, 2022 at 1: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?
-
Parker JotForm SupportReplied on January 19, 2022 at 3: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.
-
David_Potter_dpotterReplied on January 19, 2022 at 3:52 PM
Thanks Parker, appreciate all the help you and your team have provided!