Hi,
I have 2 pages - Roll and Student Log. I have a collection that pulls info from the Log table that displays in a table - Student Name and Class.
I want to be able to click on the Student Name and cause that to run a query for subjects that that student takes and display in another table on the Student Details page.
So I have created the a workflow on the Roll page that triggers once a name has been clicked, changes a variable name to the student id and then navigates to the Student Details page.
On the Student Details page, I run a trigger On Page Load that runs the query against the Supabase tables using the SELECT function from the plugin; and this runs successfully.
What I cannot figure out is where the results from the query are stored since when I go to the Student Details page, select a cell and edit the formula, I don’t see anything that resembles the Supabase results.
Thanks for any assistance.
