Hello all,
I use Wix to design and maintain (mostly maintain) my employer’s website. They’re seeking enhancements to the existing members’ area login process. At a high level, this appears to require backend validation against a CUSTOMER_ID.
Here are the questions:
-
Is it possible to use a Google sheet as a DB for client data (e.g., ID, CUST_ID, NAME, SCHOOL, DATE, etc.)?
-
Regardless of yes or no above, can the existing Wix members’ area login be enhanced to validate against a CUST_ID field?
The ideal business process would look something like this:
-
CUST_ID generated at in-person contract signing
-
CUST_ID submitted along with other data via Google Form
-
CUST_ID and other data persists to Google Sheet (or DB)
-
The customer navigates to the business website (brainpowerwellness dot com)
-
Customer signs up for the Learning Community (i.e., enters email, password, and CUST_ID)
-
Front end calls to DB to validate against CUST_ID before creating a new entity in Wix CRM
-
If CUST_ID cannot be validated, the entity is not created in Wix CRM and access is denied to the learning community
Hopefully, this is enough detail to start a discussion. I greatly appreciate your time and feedback.
– Mark Hearon