A Few Questions

[procreative]

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?

[Ben]

Hi Nigel,

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!

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.

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).

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