+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: A Few Questions (/showthread.php?tid=1404)
A Few Questions - procreative - Jun 24th, 2011
1. Is there a simple way to change the ID No of a form. Have been playing around with the system and have somehow ended up with 3 forms numbered 5, 9, 10! I tried doing this in MySQL but there are so many references to them in different tables it opened a can of worms.
2. Is there a way to auto calculate an age based on a DOB?
3. Have you considered creating a code field to enter code or a script into a form?
4. Have you considered adding an extra field type of a dropdown that with an Add button that allows you to submit a dropdown choice to a table displayed below it?
RE: A Few Questions - Ben - Jun 26th, 2011
Hi Nigel,
Quote:1. Is there a simple way to change the ID No of a form. Have been playing around with the system and have somehow ended up with 3 forms numbered 5, 9, 10! I tried doing this in MySQL but there are so many references to them in different tables it opened a can of worms.
I'm afraid not. You can change the submission ID numbering using the Submission ID Manager module, but not the form IDs. May I ask, why is this needed? I've never had this request before!
Quote:2. Is there a way to auto calculate an age based on a DOB?
You could do this with the Submission Pre-Parser module. That lets you run arbitrary code when submissions are added and updated. What you would need to do is create a new field for "Age", then add a Pre-Parser rule to automatically populate that based on the DOB field value. This would take a programmer to figure it out, though: that module was written for developers to do custom stuff like this.
Quote:3. Have you considered creating a code field to enter code or a script into a form?
How do you mean exactly? Code that would actually be executed, or just stored in the database? If the latter then yes, they can just use a textarea field in your form, and then display the code using the "Code / Markup" field type (2.1.0 only).
Quote:4. Have you considered adding an extra field type of a dropdown that with an Add button that allows you to submit a dropdown choice to a table displayed below it?
Interesting... so, like a new field type (called, say "List Table" or something) which would add them to a list, each with a little "x" next to it to remove it. I like it! This is actually totally do-able with 2.1.0 - it would just need a bit of legwork, and access to the (not yet released) Custom Fields module. Yeah, that's a really nice idea. I may do that!
- Ben