Hi,
I'm creating a CRUD application that will allow users to use a variety of different forms, menus and pages to update information to a database.
I've created the login page and it's all linked to Supabase using authorization, that works fine.
I have a sidebar that will be with the user on every page they move to, at the bottom of this sidebar there is a text field. Through a backend query this is being updated to the users 'first_name' and 'last_name' being stored in a 'users table', then through a conditional IF/Then it works compares ID's to produce the correct name.
I'm struggling to get this query to perform once and stay the same when users navigate. Currently once they leave the dashboard, the name will update for a second or two before showing the correct name again.
Is it possible using Supabase to do one 'single-time' query which stays the same until logout?
Thanks