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?


  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 15 years ago #
  4. philm
    Member

    no worries, I've fixed it

    Posted 15 years ago #

RSS feed for this topic

Reply