What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is there a way to set up conditions for the Unique ID prefix?Asked by Owais on February 17, 2012 at 12:23 PM
Basically, I have multiple users from multiple countries filling out one form with their submissions. I want to be able to organize the incoming entries with Unique ID's that correspond to a particular country. For example, if the user selects the country France, then I want the Unique ID to be EUFR001, (where EUFR represents Europe:France to me) and if they select England then the Unique ID would be EUUK001 (where EUUK represents Europe: United Kingdom to me). Note that the ID numbers also start at 0 for each individual entry.
The only current solution I can think of is to create a different form for every country (a rather wasteful way to do this), and would greatly appreciate a better solution if possible.
If there isn't a better to way to do this with one form, is there a way for me to automatically combine the reports (like say the html table, or the export to google docs spreadsheet function) so I can get one giant report with all submissions from x number of forms?
Sorry you cannot do this but it can be nice feature. We added it todo list. We will implemented it soon.
We are looking into the same thing, would be great to be able to be able to implement! What realistic timeline do you think when you say implementing soon?
Thank you for supporting this.
Our Developers are extremely busy, and unfortunately, we can not provide any exact ETA on this. We will update this thread if we get any news for you.
A possible (but clunky) workaround for this is you could try adding some conditions to your form to generate a unique ID. I guess it depends how many countries you're talking about but you could try this:
Step 1 - add in the unique ID widget with a simple sequential number system of 4 digits. Keep this text field hidden.
Step 2 - add another (hidden) text field, go to notifications and then set 'calculate' conditions so that if a user selected from a dropdown list 'France' the new field would generate in this field the text 'EUFR', or if they selected 'England' it would generate the text 'EUUK' and so on. Set these codes up for all your countries. Keep this text field hidden so the user doesn't see what is going on the background.
Step 3 - finally, add another text field and go to conditions, and then use the 'calculate' field to merge the previous two text fields into one. So for example use the unique ID prefix from step 1 '+' your text field in step 2 to merge together to create a unique ID with the country code. It is up to you whether you want this visible on your form or not, but you could then have this code listed on your email notifications.
Thank you for sharing that workaround. I'm sure it'll be helpful to everyone. If you need any help, let us know by opening a new thread.