This forum is no longer open and is for reading/searching only.
Please use our new MachForm Community Forum instead.
MachForm Community Forums » MachForm 2
Can I start first entry_no at a number higher than 1?
Started 15 years ago by philwareham | 4 posts |
-
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,
PhilPosted 15 years ago # -
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 # -
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?
ThanksPosted 15 years ago # -
no worries, I've fixed it
Posted 15 years ago #
Reply
You must log in to post.