Hello,
I am building a data vizualisation application and I try to think of the best structure (FF & Supabase) for having resizable & draggable graphs within my main page. I though of an easy first set up but I have problems with it and I would love your feedback for a better structuration of the solution.
Current set up:
- There is a gridview connected to my Supabase table
- A + button creates a modal with dropdowns that wil create a row in my Supabase table with the information title, value_type, start/end date, split (source, category, etc.), aggregation (day/week/month/year), graph_type
- A trigger & function create lists of data_points in the Supabase table
- Graphs are custom widgets placed in the gridview and automatically created / linked to the Supabase rows
3 Difficulties:
- The gridview + custom widgets + link to a table prevent from having resizable and draggable graphs
- I don't manage to get a list of unique values from 1 specific column for my dropdown "Split" (I need to create a new view just for that, which is not great)
- I don't manage to create the trigger & function to create the list od data_points in the Supabase table
2 Questions:
- DO YOU THINK OF A BETTER WAY TO STRUCTURE THIS?
- IF NOT, can you help me with the difficulties above?
Thanks a looooot in advance
PS: This is a continuation of this thread, now that i evolved a lot on the matter: https://community.flutterflow.io/ask-the-community/post/create-customizable-charts-for-by-users-JMm6tt9ZbkMNTeo