Francesca Di Muzio replied 3 months ago

i have some form i use for large input data for lookup fileds of other forms. I don't want the number ot these entries which we upload, use, delete and reupload a lot of times, to increase the entry-id of the other forms.

I then have one particular form i am interested in having its own entry-id order and count. At the moment, formidable form mix all entries from all form with the same counter and i see huge count numbers which are also used as "progressive" number by other programs/app

Rob LeVine replied 3 months ago

Yes, that is "as designed". All the entries in all the forms are stored in one table, so you can't segment or restart the ids. What you can do, however, is create your ID field in your form and you can set that to whatever you want and maintain it sequentially, etc.

Mohit Manderna replied 3 months ago

Hi! I was facing the same problem and I did the same thing of manually managing the IDs. However, is there any way that @Rob LeVine you can suggest to automate the sequence of these IDs so that there is no need to manually assign ID to every submission?

Rob LeVine replied 3 months ago

I created a new form just for the auto IDs. The number of fields in the form depends on whether you want the sequencing for more than one form. If you only want it for one form, you only need a single field. If you want it for multiple forms, then you'll need two fields (one for the ID and one for the form identifier). Then I created a code snippet to generate the number however you want (as simple as a number or more complicated such as a code + a number). The snippet reads the current auto ID from the auto ID form, sets that number into the user form, and increments it by one in the auto ID form. This snippet can be called either by frm_setup_new_fields_vars or frm_pre_create_entry, depending on when you want the ID generated. If you use frm_setup_new_fields_vars the value will increment even if the user doesn't save the form, so that might not work for most people.

Mohit Manderna replied 3 months ago

Hi @Rob LeVine, it looks very interesting, however, I am not a coder, so it would be maxxx helpful if you can please share a tutorial for this. Would be very grateful.

Rob LeVine replied 3 months ago

Writing a tutorial on this is beyond the scope of this forum. You can hire me or another developer from this list if you want. https://formidable-masterminds.com/developers-directory/