Generate a unique ID with different prefix based on a specific date.

  • viajaamiles
    Asked on April 5, 2019 at 1:54 PM

    A question more.

    If I have this list of Unique ID (AA1, AA2, ...) I can charge with the spreadwheet widget:

    AA1 - 31/01/2019
    AA2 - 31/01/2019
    AA3 - 31/01/2019

    AB1 - 28/02/2019
    AB2 - 28/02/2019
    AB3 - 28/02/2019

    AC1 - 31/03/2019
    AC2 - 31/03/2019
    AC3 - 31/03/2019

    When the customer make a new subscription, Can I send a Unique ID (the code) from the first three of the list if today we are in january? From the second if we are in february? ...

    Is important understand the alphanumerics code (AA1) are Unique ID. I need to send always one different.

    If is it not possible this condition. Forgets the dates. Can I simple send a Unique ID from the list?

    Thanks

    Davide

  • David JotForm Support Manager
    Replied on April 5, 2019 at 2:51 PM

    If I understood correctly, you want to generate a Unique Prefix in the code based on the month?

    Jan = AA#(auto increment number)

    Feb = AB#

    .

    .

    .

    Nov = AK#

    Dec = AL#

    That would not be possible, the Unique ID widget can only work with one Prefix.

    A possible workaround would be to create multiple forms(or clone the existing one multiple times) and have a Unique ID setup for each: https://www.jotform.com/help/79-How-to-Add-Custom-Unique-IDs-to-your-Form-Submissions

    Example:

    April Form:

    1554489587aprilform Screenshot 10

    May Form:

    1554489672mayform Screenshot 21

    Then you can create a new form(which will be the form that you will share with your users)  that you can use just to share the link to one of the forms based on the corresponding month.

    a) Add a Date field, which you can set to capture the current date automatically.

    1554490003current Screenshot 32

    b) Add a Text field per form to display the links to each form.

    1554489948textfields Screenshot 43

    Please try my form demo, I have left the date field visible, and without getting the current date automatically, so you can manually choose dates from April and May to test how it works: 

    https://form.jotform.com/90945255741967

    Click on the links to the forms, fill and submit them with your data, so you can see how the code is received via autoresponder notification.

    Hope this helps.


  • David JotForm Support Manager
    Replied on April 5, 2019 at 2:54 PM

    Forgot to include the screenshot of how to set up the conditions to show one of the Text fields based on the date selection: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    1554490452conditions Screenshot 10

  • viajaamiles
    Replied on April 5, 2019 at 6:53 PM

    More easy...

    If I have inside the form a list with 1000 codes, alphanumeric non-sequential. Just this.

    Can I send every time one of this codes, always one different, until the last?

  • Jed_C
    Replied on April 5, 2019 at 11:23 PM

    If I have inside the form a list with 1000 codes, alphanumeric non-sequential. Just this. Can I send every time one of this codes, always one different, until the last?

    To clarify, you want to schedule an email that will send your 1000 codes based on your condition?

    If email reminder is what you are looking for, you'll need to create a separate reminder for each code and schedule it to be sent to the user.

    Check this guide https://www.jotform.com/help/541-How-to-Set-Reminder-Emails-for-Your-Forms and see if that is what you are looking for?

  • viajaamiles
    Replied on April 11, 2019 at 12:48 PM

    I try this.

    Can I send in the PDF attachment a data from a list present inside the form?

    For example:


    In the form is present this list:

    1, NV1

    2, AKR

    3, O7H

    ...

    In the form is present allso a UniqueID

    What I want to do is:

    When the ID is egual to 1, write in a text field NV1.

    When the ID is egual to 2, write in a text field AKR.

    When the ID is egual to 3, write in a text field O7H.

    ...

    Is it possible this?

  • BJoanna
    Replied on April 11, 2019 at 2:24 PM

    If I understood correctly you want to insert a text inside of a field based on the user's answer. That can be achieved with the conditional logic.

    How to Insert Text or Calculation into a Field Using Conditional Logic

    1555006976cond1 Screenshot 10

    Here is a demo form - https://form.jotform.com/91005170516951

    Test it by entering 1, 2, or 3 inside of the ID field.