I have a connection that lists out records from a table. Each row in the table has a field named "verified" which is set to 1 or 0. On the front end of my site, this connection is displayed using a CF form so that I can include a submit button. The connection displays a user's records from the table, and can contain 1-4 rows.
I would like to disable to the submit button on the CF form until all records displayed for the user have the "verified" field set to 1 (meaning the user has verified each record in the list). I know the JS code to enable/disable the button. What I don't know is how to base it on the "verified" field. I assume I need to execute a query and look for all 1's (or no 0's), but I am lost how to do this.
Does anyone have an idea on this?
Thanks!!!!
Rick
I would like to disable to the submit button on the CF form until all records displayed for the user have the "verified" field set to 1 (meaning the user has verified each record in the list). I know the JS code to enable/disable the button. What I don't know is how to base it on the "verified" field. I assume I need to execute a query and look for all 1's (or no 0's), but I am lost how to do this.
Does anyone have an idea on this?
Thanks!!!!
Rick