Checkbox logic problem

I have a form that displays a data table containing 2 columns: Include? and Location.  The first table cell contains a checkbox that indicates whether the user has chosen to include that location in the content of another screen.  There is a GetRecord Action pulling include and location from a datasheet that contains the userid, location, and an include column.  If the include = 1, then the checkbox displays checked.  If the include = 0, then the checkbox displays unchecked.  When I change a checkbox on this screen and click the submit button, the change takes affect and the results are what I expect.

However, what I'm trying to do is add a text widget within the section this table is in called Select All that, when clicked, checks all of the boxes on the display screen, but doesn't update the datasheet.  Likewise, a text widget called Un-Select All that, when clicked, unchecks all of the boxes.  I don't want the changes to take affect in the datasheet until the user clicks the Submit button. 

I've tried using alternate views of the table section but when I run the simulation and click Select All, the screen refreshes and the alternate view displays, but in the datasheet, the value of the include column has changed to a blank.  As soon as I click either one of these text widgets, the screen refreshes, but the checkboxes are blank.  The datasheet changes the include to a blank even though the Submit button was never pressed.  Once it blanks out this include field, I cannot change the field value even if I check the checkbox on screen and submit.  How can I get the text widgets to update the screen, but not commit the change to the datasheet until the user clicks a button?

Comments

[dk]

You might be able to funnel everything through a temp column in your datasheet (i.e. flagging). This way, you can load the temp column with the existing data when you arrive at the page and modify it however you wish. Then, when you submit, use a decision point to copy the temp data as necessary to the real data column.

[Scott]

Eileen,

Are you using iRise 6.x? I ask because we have noticed strange behaviors particularly around using form objects (checkboxes, radio buttons, etc) with datarow tables. I’m going to post an iDoc with an example and you’ll see what I mean.

Thanks,
s-

[ecromie]

Scott - I'm using version 5.3.1.

[Marty]

My guess is that you will need to include the entire form -- not just the table section -- in your alternate views. Essentially having two separate forms.

Otherwise, you're running the risk of having two sets of identical checkboxes within a single form, which might explain why one set is being blanked out.

Still just a guess though...

[Vinay]

I have done similar requirement 2 days back in iRise 6.0.2. I have used the facility of "Set Page Action -->Edit User Input" widget. On click of select all in Table, I am setting the value of checkbox to 1 using above widget and on click of De-Select All, value is set to 0.
May be this will help you.