JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to Concatenate Unique ID with Another Field on Dropbox?Asked by kellyfisher on November 15, 2015 at 02:51 PM
I would like to concatenate my unique id field with another field but when I go to the conditions widget to do this, it won't show the unique id field as an option to use. Is there a workaround?
field 1 = Uniquie id = 1511123 (*123 is serial, 1511 is a prefix)
field 2 = Market ID = AU (example)
field 3 = Project Name
I'd like to create a field that shows: 1511123_ AU_Project Name
The second part of this is that new field will then be integrated into unique folders in Dropbox. That's my end goal.
At a minimum, I'd like to have Field 1 for Dropbox but can't select that either.
You can't really add a postfix, but you can add a prefix. You just need to click the Prefix button on the top tool bar and enter the name of the field you would like to add as a prefix, all in brackets.
Please let us know if this helps.
I think my question wasn't clear. I understand how to do the unique id.
What I want to do is concatenate in dropbox i can have unique names for each folder. Ideally it would be field1_field2_field3.
It won't let me pull the Unique Id widget when I get into the calculation widget.
If that is not possible, can I just use the Unique ID widget when using dropbox integration. It won't let me select that particular one.
You achieve the similar scenario with using "Textbox" field, "Unique ID" widget and "Dropbox" integration itself.
To do that,
You need to set one "Textbox" field with the predefined value e.g. " Market ID = AU". Also, you can hide that field, if don't want to let the users see. Secondly, set a "Unique ID" widget which you have already put.
After that, in the "Dropbox" integration wizard, you can customize the folder path with respect to your needs:
I hope this solution will meet your needs. If you need further assistance, please don't hesitate to contact us.