Mr. Wizard I presume,
If my check box needs to be an interger how would you suggest tweaking this to work with the tables.
Or better yet, let me try and explain where I'm going with this. With your wisdom, you might point me in a different direction, or have a better solution. Your example "Question fields" will populate on my form with secondary data (description). If my secondary data 'flag' (in / out status) is unchecked (out), I want to grey out that row i.e. make it unavailable. (at a mimimum I can use conditional format on the checkbox based on the secondary data flag, I'm thinking out loud?)
In addition when the row is selected via the checkbox and added to "summary" I was hoping to make the checkbox an integer. I will use the integer(s) to add into a comma delimited file and upon submit use workflow to set the "flag" (out) in secondary data. (checkbox integer equals my secondary ID of the "description" thus upon submit item is flagged as out for next form)
I could use a rule for the checkbox, based on concatenation, but as of yet I've not sucessfully tackled the behavior to remove the integer from the concat, if the box becomes unchecked later?
I really appreciate your time and expertise.