Can I start first entry_no at a number higher than 1?

(4 posts)

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 3 years ago #
redityo
MachForm Support
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
Posted 3 years ago #
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 2 years ago #
philm
Member

no worries, I've fixed it

Posted 2 years ago #

Reply

You must log in to post.