MachForm Community Forums » MachForm 2

1. philwareham
   Member

   Is there an easy way to make the first entry number sent to the form database to start at a numerical value of #1000, instead of just the default #1? Hope that makes sense!
   Cheers,
   Phil

   Posted 15 years ago #
2. 

   redityo

   Hi Phil,

   Since entry_no in machform use auto increment field type, I think easy way to change the number with altering the table on your machform database. You can use this query :

   ALTER TABLE ap_form_x AUTO_INCREMENT = 1000;

   Where x is your form id, for example you have form id = 5, so the query should be like this :

   ALTER TABLE ap_form_5 AUTO_INCREMENT = 1000;

   to do this make sure you've backup your data first

   ---

   MachForm Support

   Posted 15 years ago #

3. philm
   Member

   Hi,
   I'm trying to do a similar thing a I would like the form ID to be a membership number starting from 500. I've tried changing this through phpmyadmin. The field is auto increment but I cannot set a default value. Do I need to change something in the machform files to start the count from 5000?
   Thanks

   Posted 14 years ago #

4. philm
   Member

   no worries, I've fixed it

   Posted 14 years ago #

RSS feed for this topic

Reply

You must log in to post.