Alright i’m about a week into glide and i’m absolutely loving it but im a bit lost in terms of user data and relationships - that i may or may not be able to create.
Here’s my use case: high level overview for context. - can be skip
it’s a 3 sided marketplace! (sort of)
1/3: users (client) submit data via friendly and easy wp form that data is essentially a lead (an open lead). We have 2 other parties remaining 2/3 party(s) will submit information - call it verification on the clients (open lead data), and the last party member 3/3 will be able to see majority of data except contact info. they will make offer/input and this gets displayed back to the user in their dashboard.
What i have done successfully so far.
WP website lead form with 12 columns of data including user email webhook(ed) to gsheets and displaying in my glidepages app. -successful
What im having trouble understanding
- My gsheet data (lead) exist but how can i make it into a thing that belongs to a user. and systematically pass that data through a stage like process. I’ve tried relational, if - then, targeting user email and i seem to be missing something.
In an ideal world this is how i envision it.
user submits form (external) → data in gsheet mirrored in glide → (somehow- automatically a user is created/ invitation sent. (and maybe the gsheet data is passed to a new data set) But that lead data is stored or linked to that users email, so when they sign in - using the same email this " new thing" is carrying the gsheet data and will display to the user once signed in. The process continues through the stages i mentioned earlier.
any guidance or ideas would go a long way.
Thanks.
Go Glide!