should I use a table field?
Posted: Tue Jan 01, 2008 2:45 pm
Hello all,
I need to emulate a score sheet.
The sheet has a column of drop-down buttons next to a 2-column table. Each button is used to enter a team member's name in the first cell in each row of the table. Then the user enters a W or L in the second cell (to indicate win or loss) and a script updates a total at the bottom of the column, using values of 1 for a win and 0 for a loss. Sort of like this...
team list btn | player 1 | W
team list btn | player 2 | L
team list btn | player 3 | W
... and so on ...
I have the drop down button working, entering a player's name into the first cell of each line. Now how do I make the second cell editable without the first cell being also editable, so the Ws and Ls can be entered without messing up the names? Could I trick it with an on enterfield, lock field, put cursor after tab 1, unlock field kind of thing? (I couldn't get that to work.)
Or should I use a different field type? Or simply a series of small, effectively one-celled, fields? Anyone know of examples of similar tasks I can look at?
Important factor: once this works, it will be used as the data entry front-end for an on-line (web site based) mySQL database.
TIA
Rob
I need to emulate a score sheet.
The sheet has a column of drop-down buttons next to a 2-column table. Each button is used to enter a team member's name in the first cell in each row of the table. Then the user enters a W or L in the second cell (to indicate win or loss) and a script updates a total at the bottom of the column, using values of 1 for a win and 0 for a loss. Sort of like this...
team list btn | player 1 | W
team list btn | player 2 | L
team list btn | player 3 | W
... and so on ...
I have the drop down button working, entering a player's name into the first cell of each line. Now how do I make the second cell editable without the first cell being also editable, so the Ws and Ls can be entered without messing up the names? Could I trick it with an on enterfield, lock field, put cursor after tab 1, unlock field kind of thing? (I couldn't get that to work.)
Or should I use a different field type? Or simply a series of small, effectively one-celled, fields? Anyone know of examples of similar tasks I can look at?
Important factor: once this works, it will be used as the data entry front-end for an on-line (web site based) mySQL database.
TIA
Rob