I would like to use the member area to display user data (in graph form ideally) specific to each account. I need to this data to load from a Google Sheet or similar database.
For example. My members will complete real world tasks and report them to me. I will update a database and they will login to their member area to to see their overall progress.
I will have hundreds of users to I need the data to pull from a single database source.
Any thoughts on this kind of functionality?
Thanks!
You just need a reference point between your website and the spread sheet, for example the users email address or website user ID.
Lets say we go with their website user ID. The ID they are assigned when they register on your website should also be present on your spreadsheet.
Import your spreadsheet into a wix collection/database.
Then when the user logs into your website you can just run some code to query the wix database and return the relevant information specific to that user.
Not sure why you are intending updating a Google Sheet instead of just updating the wix database directly.