Form Field Order

Eddie Monster · #1 23rd August 2006, 15:51

I have a customized session with a form type 2. 10 occurences show up on the session at a time and there are three fields per occurence which are display and two fields per occurence which are maintainable by the user. The two maintainable fields belong to the main table associated with the session.

I have just added two additional form fields which hold variables the user will populate when they start the session (these fields are needed when the user clicks 'continue' and the records are processed by the session script). The problem I'm having is that the form field order goes in the following order:

Variable field one {TAB}
Variable field two {TAB}
Occurance 1 field one {TAB}
Occurance 1 field two {TAB}
Variable field one {TAB}
Variable field two {TAB}
Occurance 2 field one {TAB}
Occurance 2 field two {TAB}

The desired behavior would be the following:

Variable field one {TAB}
Variable field two {TAB}
Occurance 1 field one {TAB}
Occurance 1 field two {TAB}
Occurance 2 field one {TAB}
Occurance 2 field two {TAB}

I have tried several different configurations of the field order when maintaining the form and have been unsuccessful. I have also searched the forums and haven't found anything useful either. The only thing I did find which I may be able to use is the to.field() function, but the sessions flow is quirky (users would not approve).

Does anyone else have any suggestions? Due to the nature of the data I cannot make the two variable fields part of my main table and use a form type 3.

Thank you for any help.

lbencic · #2 23rd August 2006, 17:18

I've done similar. Try making it 'Single Occurance' and Field Type = Input Only. Also check 'mandatory' and will need to fill it before they leave, if you want. Then, use the command 'input' to get to it on start up. I used this code

Code:

form.1:
init.form:
        input("my.single.occ.variable")
        execute(modify.set)                       |* takes them to modify the first occ

mark_h · #3 23rd August 2006, 18:14

Crap - this looks a whole lot easier than the one time I did this. What I did was in the after.input I set a variable to true. Then as long as I was in add.set mode and this variable was true I set attr.input to false. It took me a while to figure which section to use - then the user decided they want the field for each record.

Eddie Monster · #4 23rd August 2006, 20:58

lbencic,

Based on your input here is what I had to do. This customized session is based on the need for multi-line so I did the following:

Kept the form at type 2 (multi-occ + main)
Changed the form types for those two 'variable' fields to "Input Only"
In the session script under form.1-init.form section:
- execute(find.data) (so all my occurences and their 'extra' data from other tables displayed first thing)
- input("single.occ.one")
- input("single.occ.two")

Everything works fine now! Thank you very much!