Is there a way to change the prefix based on a required field answer?

  • Profile Image
    hvi
    Asked on December 29, 2014 at 05:08 PM

    Is there a way to change the prefix based on a required field answer? For example, our Product Category field has nine possible answers and we would like to use a 2-digit prefix based on which Product Category is selected.

    Or would it be easier to assign the 2-digit code to a new field based on the Category selection and append the Unique ID, thus creating a third field?



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

  • Profile Image
    hvi
    Answered on January 20, 2015 at 09:52 AM
    ?Hi. Thanks for the suggestion. I've been playing around with this. We can't use a random number because our IDs need to be Unique when we import them into our database. I assigned the 2 digit code for the prefix as you suggest in the form below and assign it to a 2nd hidden field. Then I have the Unique ID field create a 5 digit unique ID. Then when I import the form data into our database, I conjoin the two numbers. So I don't actually have the 7 digit ID we need on the form itself, but it works out.
    Thanks again for your help.
    Regards,
    Bobby Windmeyer
    Technical Programs Manager
    Home Ventilating Institute
    ?855.HVI.VENT (855.484.8368) Ext. 103
    ________________________________
    ...