Mass affiliations - validate responses

[fareenr]

need a script or compare function to pull data from BCROS to validate that the BCROS account number and account name that the client provides in the form matches what is in the BCROS system.

Validate that:

• [ ] each unique admin email address has only 1 account number submitted
• [ ] BCROS or SBC Connect account number submitted matches the account number and account name in the BCROS Prod application

Develop a query from BCROS by account number to pull corresponding account name. Produce a report that shows this data with a compare function on account number and account name with what the clients submit through the webform.

Report must be filterable by error message (eg. Not unique account number - for any users that submit more than 1 account number per admin email address), so that a project member can email the client with the specific records and errors that need to be corrected and re-submitted.

end goal of this task: identify if any clients have provided incorrect account numbers in order to send form back to client with email to provide accurate account number information

[fareenr]

@sameer0422 Please add your estimate

[fareenr]

26-Sep - after Sameer communicated that the Limit to 1 response needed to be disabled on the google appscript webform, then we need to add the validation that only 1 unique account number can be affiliated to 1 admin email address (in case a user submits 2 different account numbers for 1 admin email address, the incorp number accounts linked to that admin email address can only be migrated to 1 BCROS/ SBC-Connect account).