I'm having a little trouble with something that I'm trying to do.
I currently have a database containing a list of vehicles owned by my site's members. I will be managing and updating the data personally, so all records have my user id in the Owner field.
I would like to have a list in the members area of my site which shows a user all of THEIR vehicles, however because I am the owner of all the records I can't simply filter by Logged in User on the Owner column.
My solution to this was to have an email address column in the database and filter by that, however my attempts at fetching the currently logged in user's email all failed - I'm not sure if I understand how to use the APIs. If somebody could please explain the process to get the user's email address and then use that address to filter a dataset, that would be extremely helpful.
Alternatively, is there another way that I could go about filtering these results? I'm open to any ideas.
Thanks very much,