+- 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: Help?? (/showthread.php?tid=869)
Help?? - AtomicAge - Sep 30th, 2010
Hello! New User of FTs, and I'm loving it! I've run into a problem...
I've read a couple other threads, but there didn't seem to be a detailed answer.
I have a form that is only submitting First and Last Names for a sign up sheet. FT displays EXACTLY what I need... the submitted name and date/time stamp. I'd like to be able to select a radio button next to each name, and "archive" it. Basically, change the status of a name. New submissions would have a default "new" status. That way, to view all past submissions, you'd select the new View.
Does this make any sense? I added a new form field named "status", made it radio buttons with "active" and "archive" values. It's not showing up in the database when viewing the submissions. Do I need to add something to my original form?
To explain the reason for this, I'm using one default sign-up form for a seminar. The seminar changes weekly. So, the submission will be handled manually via FTs each week. At the end of the week, the previous submissions will be marked to differentiate them from the new submissions. In the future, I'd like to view all of the submissions and sort them to see who regularly attends the seminars.
Thanks!
- AA
RE: Help?? - Buttons - Oct 1st, 2010
I’m looking for something similar: a possibility of marking in the database when jobs are completed, and then filtering to show only outstanding jobs.
Seems like it should be easy, but I must be missing something. Will check the documentation more thoroughly, but if anyone has a tip I’d be pleased to hear it.
RE: Help?? - Ben - Oct 1st, 2010
Hey guys,
No no - you're both on the right track: it's just not that obvious!
Quote:I added a new form field named "status", made it radio buttons with "active" and "archive" values. It's not showing up in the database when viewing the submissions. Do I need to add something to my original form?
Not the form, no - just the View within Form Tools. Here's the thing: whenever you add new form fields to Form Tools, you need to update your View(s) to show that new field. New fields don't get added to Views automatically, since they may not be wanted and the script wouldn't know what order they should appear.
Once you add that, you can then create a second View with a Standard Filter that filters out submissions based on the value in that new field.
Hope this helps!
- Ben
RE: Help?? - Buttons - Oct 7th, 2010
Thanks for the encouragement, Ben.
I’ve achieved what I needed, but it’s not quite what I had in mind. Created a new text field called “Completed”. If it’s empty, the record appears in a view called Pending; if there is anything in it (e.g. “10 October” or “yes” or “within deadlines”) it doesn’t show up as Pending.
That works fine, and will serve the purpose. What I wanted to do, though, was present the “Completed field” as a radio-button choice in the Edit submission page, to force a yes/no choice.
Hints welcome, but really not urgent.
RE: Help?? - Ben - Oct 8th, 2010
Quote:That works fine, and will serve the purpose. What I wanted to do, though, was present the “Completed field” as a radio-button choice in the Edit submission page, to force a yes/no choice.
Sure, no problem! Here's how to do it:
1. On the Edit Form -> Fields page, set the field type to "Radio Buttons" and click update.
2. Then click the row's OPTIONS link.
3. On the Edit Field Options page, click the "Create new Field Option Group" button.
4. That will take you to a page where you can define the options for your field. Add two rows with "Yes" and "No" for BOTH column ("Field Value" and "Display Text" I think...)
5. Set the orientation to "horizontal" (this will position the radio buttons in a single line)
6. Click Save.
And unless I've forgotten something, that should be it. You've now created a new field option group and associated it with your field. Now, whenever that field appears for editing it will show two radio buttons.
Hope this helps!
- Ben