Increment unique field number sequence for each of the registrant

  • Profile Image
    Asked on November 24, 2019 at 01:54 PM

    If i have 'n' unique fields in a form depending on the 'n' number of tickets chosen by the one who is registering can i increment the starting value for the subsequent unique fields

    This is a re-post of a comment on How to Add Custom Unique IDs to your Form Submissions?

  • Profile Image
    Answered on November 24, 2019 at 02:25 PM

    Unfortunately it is not possible to increment the Unique ID number using another field value. The unique ID field only increment the sequence number on post submission.

    Meaning the number only changes after submitting the form. So there is no other way to manipulate the sequence number while loading the form or within the form.

    The workaround you can check is by using the Spreadsheet to Form widget.

    Guide : How to Use the Spreadsheet to Form Widget

    You can upload a data table on the form using the widget wherein the user can type a number (which is the unique key) and then the unique data field will be prefilled in the form.

    I hope this help. Let us know if you need further assistance on this.