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

  • Profile Image
    viajaamiles
    Asked on April 05, 2019 at 01: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

  • Profile Image
    BDAVID
    Answered on April 05, 2019 at 02: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.png

    May Form:

    1554489672mayform.png

    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.png

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

    1554489948textfields.png

    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.


  • Profile Image
    BDAVID
    Answered on April 05, 2019 at 02: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.png

  • Profile Image
    viajaamiles
    Answered on April 05, 2019 at 06: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?

  • Profile Image
    Jed_C
    Answered on April 05, 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?

  • Profile Image
    viajaamiles
    Answered 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?

  • Profile Image
    BJoanna
    Answered on April 11, 2019 at 02: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.PNG

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

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