Reset Form ID

[pinkfrankenstein]

I develop locally on my computer and then upload to a server. Is there a way to reset what Form Tools sets as the Form ID ?

I find that I am still tweaking my forms and having to recreate them in Form Tools which makes the form_ID get out of sync with the one on the server.

Can I manually go into the database and set/reset this?

[michatmaster7]

Subscribed to this thread. Excellent question for us perfectionists.

[Hannes]

Hey there,

in function there is no advantage, so you might think twice if it makes sense for you to change the form id.

1. FormID is defined in mysql database "ft_forms" (if prefix is as default "ft_").
   
2. The field "form_id" in this database defines the form id.
   
3. The form database must be renamed/created to "ft_form_[formID]".
   

Cheers,
Hannes

[Ben]

Yeah - this is one of those nagging little things that are hard to resolve.

Funnily enough, I had the same objection to the submission ID - it would end up getting out of whack between my testing environments, so I ended up writing a simple little module to allow resetting/changing the next submission ID counter - including emptying the data & resetting to zero.
http://modules.formtools.org/submission_...wnload.php

For the form ID, you'll need to run a "TRUNCATE ft_form_X" SQL query on your table to completely reset the form ID. However, that will empty all the data out of it too.

All the best -

Ben

[pinkfrankenstein]

As a work around I've created a small PHP form config file that has not only the server name but also the Form_ID. It lives outside of my development directory so that I don't accidentally replace it.

So there is one on my server and one on my local machine with the appropriate information. Works really well for development.

[michatmaster7]

Wow. Sad that I never thought of extensions for FT before. I just perused that whole section. The Submission ID Manager actually answers another question I was going to have, so thank you in advance

[Ben]

haha no worries.

And pinkfrankenstein - thanks for posting your solution!

- Ben

[ron77hays]

As a work around I've created a small PHP form config file that has not only the server name but also the Form_ID. It lives outside of my development directory so that I don't accidentally replace it.

'

Is it also possible to have it inside?