Nested Lists from Supabase in Toddle

  • alexsiale_17363-1314346069437710356

    Alex

    5 months ago

    Hey Toddlers! I need help with something that is probably very straight forward and something in my Webflow / Airtable brain that would call these "Referenced Items/records" or "Nested Items".

    I want to essentially show this grid of case studies and have a display photo and name of the studio/artist that uploaded them. How can I pull in the referenced owner and their info and place inside the list of case studies?

    see the example of my webflow marketplace with the logos inside the collection items from a referenced list.

    Make sense?
    1314346070351941772-Screenshot_2024-12-06_at_10.38.45_AM.png
    1314346070989344898-Screenshot_2024-12-06_at_10.41.25_AM.png
  • elli4931-1314347401179299920

    Vizualinx

    5 months ago

    Did you try with the AI assistent?
    Ask it for a function that would transform it to Json.
  • lucasg-1314347651461939210

    Lucas G

    5 months ago

    If they are different arrays, then you'll need a common id to link them
  • You can map the array before repeating over it or use filters to assign the data
  • alexsiale_17363-1314348027577634927

    Alex

    5 months ago

    Thank you guys, testing now and will report back
    👍🏻1
  • jamessomers-1314355568743546970

    James

    5 months ago

    If this is something like Xano addons this should help https://docs.postgrest.org/en/v12/references/api/resource_embedding.html
  • alexsiale_17363-1314377510128975924

    Alex

    5 months ago

    Toddle is AMAZING and so easy!!!
    1314377509894357104-Screenshot_2024-12-06_at_12.46.35_PM.png
  • alexsiale_17363-1314379324417114142

    Alex

    5 months ago

    Custom cards now with the respective studio that uploaded the renders!
    1314379323280457728-Screenshot_2024-12-06_at_12.53.41_PM.png
    1314379323947618417-Screenshot_2024-12-06_at_12.53.37_PM.png
  • elli4931-1314380722018058280

    Vizualinx

    5 months ago

    How did you end up doing it?
  • alexsiale_17363-1314383231705022505

    Alex

    5 months ago

    This is the formula 🙂
  • elli4931-1314384390796738672

    Vizualinx

    5 months ago

    Oh, now I looked back and saw that I didn't really understand the question. I thought you needed nested lists.
  • alexsiale_17363-1314387402642423891

    Alex

    5 months ago

    I don't know what I need hahah
  • martinf4630-1314598801238917152

    MartinF

    5 months ago

    Awesome! With Supabase you can get it to a single 'view' so only one API call from Toddle and no need for formlulas. Just one nice chunk of JSON. https://supabase.com/docs/guides/database/tables?queryGroups=database-method&database-method=sql#views
    ❤️1