I am currently using Xano with Draftbit.
My goal is to only display data in one table based on the user being set to the current authenticated user that is signed in.
At the moment it works as I am able to manually set the user I want. Although, I have only been able to query the user based on email and not their userid.
How can I ensure that a user will only retrieve data that is specific to them?
Also, I am joining 3-4 tables together to retrieve this data. Is this a problem as well?