- OwaisAsked 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?Page URL:
- emrew86Answered on February 17, 2012 at 01:13 PM
Sorry you cannot do this but it can be nice feature. We added it todo list. We will implemented it soon.
- countrywalkersAnswered on March 12, 2012 at 04:51 PM
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?
- JotForm SupportMike_TAnswered on March 12, 2012 at 06:40 PM
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.
- cmsacommsAnswered on May 30, 2016 at 08:15 AM
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.
- JotForm SupportJanAnswered on May 30, 2016 at 09:57 AM
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.