How to Concatenate Unique ID with Another Field on Dropbox?

  • kellyfisher
    Asked on November 15, 2015 at 2: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.

  • victor
    Replied on November 15, 2015 at 4: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.

    How to Concatenate Unique ID with Another Field on Dropbox? Image 1 Screenshot 20

    Please let us know if this helps.

  • kellyfisher
    Replied on November 15, 2015 at 5: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.

  • mert JotForm UI Developer
    Replied on November 16, 2015 at 3: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.

    How to Concatenate Unique ID with Another Field on Dropbox? Image 1 Screenshot 30

     

    After that, in the "Dropbox" integration wizard, you can customize the folder path with respect to your needs:

    How to Concatenate Unique ID with Another Field on Dropbox? Image 2 Screenshot 41

     

    I hope this solution will meet your needs. If you need further assistance, please don't hesitate to contact us.

     

    Thanks.