Apr 12th, 2012, 12:52 AM
(Apr 4th, 2012, 7:36 AM)gabunt Wrote: We created a form with a field called category as an option list. After a little use we added an additional option value to the form.
I am having a problem I think is related, but with the opposite effect. Removing options from an option list hides those values when viewing previous form submissions (though they are still there in the database fields).
In my use case I am using form tools to manage simple faculty/staff job applications, and am trying to set it up as follows...
"Jobs" Option List:
- Job 1: Part-time Lecturer (Marketing)
- Job 2: Professor (Management)
- Job 3: Associate Professor (Korean Language Education)
"Applications" Form:
- Field 1: ID
- Field 2: Job Field <- This is a checklist showing the "Jobs" option list
- Field 3: Name
- etc...
The problem is, once a job position is filled and new jobs become available, ie:
- Job 2: Professor (Management)
- Job 3: Associate Professor (Korean Language Education)
- Job 4: Tenured Professor (Economics)
...I update the option list, but this disturbs all previous applications which still have text from "Job1". Although the new Job 4 work fine, the existing entries no longer show the text for the removed job (though it is still present in the database), and there is no way to view or update that data anymore.
I also tried setting the Job field dropbox options to show "Form Field Contents" from another form which is just a list of jobs, but I have the same problem: Either I have an ever-growing list of all jobs in one long drop box, or I delete the old jobs and lose existing data.
Am I going about this the wrong way, or is this a limitation of the option lists?