Hi, I have a 3 step input form created using PageView.
1. On the first page, the user completes the company details
2. Next the user clicks “save and continue.” An action insert new row to the "companies" table in Supabase and takes the user to the second page.
3. The user is on the second page and can add customers to the company.
I don't know how to make Supabase return the ID of the company I created so that I can use it on the second page. I need this ID to create new entries in the relationship table when a user adds a customer to this company.
How to make Supabase return the ID after executing the insert row command?
Thank you for your help!