I have two Apps, App_1 and App_2
App_1 is set to Public and provides information about App_2.
App_1 is view-only (no edit, add, etc.) - but User can register to trial.
Upon successful Trial registration for, the user can sign in to App_2.
In App_1, Trial Form asks for the following info:
- Company Name
- Contact Name
- Contact Email
Before accepting the registration form, we first confirm that provided Email doesn’t already exist in active Users list.
If provided Email exists, the App will display a message with the same and ask use for different Email.
Note: The user already filled up the form, so we don’t want him/her to re-fill everything again,
just re-edit email and save.
If provided Email doesn’t exist (a new one), then we all good so far and form will be processed forward and two things shall happen automatically:
Add form data as a new row into Tab=Subscribers in GS).
I have an Arrayformula that auto-generate a subscriber_ID.
Add new row in Tab=Users to fill in Subsciber_ID and Email.
And I got this covered (using two steps approach - but working to automate this using Google script)
My dilemma: How can I store a field value before user clicks on submit because if allowed to Submit, then a new line will be added but w/ duplicated email.
I can’t call a form from a form nor could figure out how to store data before submission.
I tried User specific route, but then I got stumbled with
A. This column is visible form GDE but not in GS.
B. How to increment row as two users might be submitting trial reuqest.
My head is spinning Pointers !!