What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    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?

     

    Example:

    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.

    unique id unique concatenate another
  • Profile Image

    Answered by victor on November 15, 2015 at 04:04 PM

    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.

  • Profile Image

    Answered by kellyfisher on November 15, 2015 at 05:38 PM

    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.

  • Profile Image
    JotForm Support

    Answered by mert on November 16, 2015 at 03:51 AM

    Hi there,

    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.

     

    Thanks.