Hi,
I would like to (if possible) to add a custom page on my site where users can complete a form with some extra information about themselves.
I'm looking at basically some milestone dates, such as
Start date (not joining date) (SD)
Date when task X was achieved (XD) (ex: Day when exprienced a 10% weight reduction)
Date when task Y was achieved (YD) (20$ weight reduction)
Date when finished (FD)
I want to allow the user to update this info at any time (but only their info, before we'used a shared google spreadsheet, but it's been vandalised a few times). So I'm thinking of creating a table in the database with something like
UserName| User Email| User location | SD | XD | YD | FD
Registered users should be able to see all records (in a spreadsheet like fashion)
Registered users should only be able to edit their own data (a separate form is ok)
Events can vary among groups of users (ex Bodybuilders would like to track weight increase instead of weight loss)
So what's Q2A have to with that, well, I would like to reuse the users Q2A credentials if possible (so no need to include email & location for example). And using Q2A to only allow registered user (with verified email address) to look at the aggregated results).
I should point out I'm not looking at a "here is the solution anwer" (although that would be great! :D), but some guidance on where should look to learn more and be able to pull something like this.
I have some SQL and php (php is a little rusty I must admit)
PS: I totally made the weight loss/gain example. I found this site does pretty much what I'm intending to do (in a more complex fashion)