Oct 17th, 2010, 5:08 AM
Hi Tom,
Thanks for the post! I think I'll write a tutorial for this - it's a pretty common request, actually.
The is_finalized field is really just for internal use within Form Tools. I wouldn't want to open it up to be edited by admins/users because there's it has special meaning within the Form Tools code, e.g. this function:
http://docs.formtools.org/api/?page=ft_a...ubmissions
That parses the database and deletes all those unfinalized submissions. If I let it be edited, people may start unwittingly deleting those submissions.
But you can do what you want another way. Here's a rather high-level description of how to do it:
1. Edit your form and go to the Database tab. There, create a new field called "Is EFT Processed" (or something...!)
2. Go to the Field Option Groups page and create a new field option group with two values: "yes" and "no".
3. On the Edit Form -> Fields tab, change that new Is EFT Processed field to radio buttons, click update, then click Options. On that page, select your new Field Option Group.
4. Edit your View(s) and add that new field.
At this point, when you view your submissions you'll see your new field with two options: "yes" and "no".
5. Edit your View again and add a Standard Filter. This will limit all results that appear in that View to whatever criteria you specify. Add a rule that says: if field="Is EFT Processed" EQUALS "yes|"
That will then only show results that have either "yes" for the Is EFT Processed field or nothing (the default value). In other words, all results that haven't been set to "no".
I do hope this is clear - sorry it's so brief. Let me know if I wasn't clear on anything or if you have any questions!
- Ben
Thanks for the post! I think I'll write a tutorial for this - it's a pretty common request, actually.
The is_finalized field is really just for internal use within Form Tools. I wouldn't want to open it up to be edited by admins/users because there's it has special meaning within the Form Tools code, e.g. this function:
http://docs.formtools.org/api/?page=ft_a...ubmissions
That parses the database and deletes all those unfinalized submissions. If I let it be edited, people may start unwittingly deleting those submissions.
But you can do what you want another way. Here's a rather high-level description of how to do it:
1. Edit your form and go to the Database tab. There, create a new field called "Is EFT Processed" (or something...!)
2. Go to the Field Option Groups page and create a new field option group with two values: "yes" and "no".
3. On the Edit Form -> Fields tab, change that new Is EFT Processed field to radio buttons, click update, then click Options. On that page, select your new Field Option Group.
4. Edit your View(s) and add that new field.
At this point, when you view your submissions you'll see your new field with two options: "yes" and "no".
5. Edit your View again and add a Standard Filter. This will limit all results that appear in that View to whatever criteria you specify. Add a rule that says: if field="Is EFT Processed" EQUALS "yes|"
That will then only show results that have either "yes" for the Is EFT Processed field or nothing (the default value). In other words, all results that haven't been set to "no".
I do hope this is clear - sorry it's so brief. Let me know if I wasn't clear on anything or if you have any questions!
- Ben