Hi, i'm new to Flutterflow and am trying to develop an app using Supabase database.
I have two columns 'user_info' and 'class_info'. I was able to update the column 'class_info' in supabase using a button action: for example let's say there is a 'class_title' column which I've updated using the 'update row' from a query in Flutterflow.
But what if when clicking the same button i also wanted to update or add a value to a column in the 'user_info' table?
I tried adding a query on top of the 'class_info' query but i keep getting the notification in the Optimization $ Enhancements tabs that there creates a duplicate backend query and can cause performance issues.
What is the best way to update two tables in supabase at once or through a button action to avoid errors/bugs? Any help is much appreciated.
Thank you :)