How do i update two supabase queries using a button action?

Database & APIs

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 :)

What have you tried so far?

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.

Did you check FlutterFlow's Documentation for this topic?
No
1
6 replies