I have a billing App in which Users are enabled to enter a particular customer’s information into a Form and, once entered, to Review and confirm their submission. The Form is launched from a parent sheet.
Unfortunately, once the Form is launched, there is some information that I cannot show Users within the Form (information ‘X’) as it is dependent on some Choices that the User makes within the Form. As such I have given Users a chance to review the information submitted (call this Form 1 Entry) via a ‘Review & Confirm’ page that appears right after the form is submitted. This information includes the now available ‘X’. I would like the user to have the option of De-Activate the Form 1 entry (ideally in the form of a switch) based on their review of the information (including ‘X’). And I would like to record this in the Form sheet.
Where I am having trouble is in making it easy for the User to Deactivate the Form submission and to record this information in the Form sheet. The problem is that if I include an Activate/DeActivate switch in the Review page (post Form submission) that result is recorded in the parent sheet and not in the sheets/row where the Form has been submitted.
I would appreciate any suggestions from anyone who might have some ideas on how to address this.