Change Form ID

[walkingby]

I have a fairly unique situation. I need the ability to change one form ID (ei ft_form_1) in my database to something more "definitive." The site owner wants the ability to update this specific form via Form Tools. (since this is what he's used to using.) The data being stored is being used by another script within the same database. A bit complex to explain...but essentially, the client will use Form Tools to manage the data, and the other script will pull from that table. So... the table in Form Tools needs to match the other scripts queried name. Typically, I'd simply change the query in the other script to match Form Tools (ft_form_1) ...but this isn't an option in this particular situation. Is this a possibility?

Thanks so much! Hope my question was clear enough!

Brian

[Ben]

Hey walkingby,

Drat, didn't realize I missed your post.

Neat problem... so I guess there's no way to modify that other script to accept a different database table name? Probably not, I suppose.

Unfortunately, Form Tools has a similar requirement: the form table names MUST be named like that: [prefix]form_[form ID]. All of the code relies on that, so changing it would require a fairly large overhaul of the script.

One option would be to create a duplicate of the Form Tools form table and grab the data from that. This may not work depending on your requirements, but you could rig up a simple cron job to automatically purge the new database and re-input all the current form tools data, say every day or hour or something. This isn't too tricky to get up and running, actually - the SQL is quite simple.

Other than that I don't have much to suggest... but good luck!

Ben

[walkingby]

Thanks so much for the response Ben. I ended up creatively working this out...and things seem perfect so far!

Hey walkingby,

Drat, didn't realize I missed your post.

Neat problem... so I guess there's no way to modify that other script to accept a different database table name? Probably not, I suppose.

Unfortunately, Form Tools has a similar requirement: the form table names MUST be named like that: [prefix]form_[form ID]. All of the code relies on that, so changing it would require a fairly large overhaul of the script.

One option would be to create a duplicate of the Form Tools form table and grab the data from that. This may not work depending on your requirements, but you could rig up a simple cron job to automatically purge the new database and re-input all the current form tools data, say every day or hour or something. This isn't too tricky to get up and running, actually - the SQL is quite simple.

Other than that I don't have much to suggest... but good luck!

Ben