Allowing users to add custom columns to their tables

  • alexsiale_17363-1330019583683203103

    Alex

    21 days ago

    Hey everyone

    After first customer feedback session for my property development CRM built in toddle a few requests have been made and we can see all users needing these too.

    First one off the bat to tackle is giving users the ability to customise their table layouts inside the portal by adding and deleting columns.

    For example:
    - they might want to add a column for their internal team notes on a property table or they might want to add a column for door access key codes etc etc

    How do I allow this functionality whilst limiting the updates to the table structure to their account only?

    Does this make sense?

    Think like Airtable or most table based tools where you can add new columns etc.

    I’m using Supabase as database with Supabase auth.
  • lucasg-1330034833476292648

    Lucas G

    21 days ago

    You’ll need to create a table component that allows for column customization
  • Then you can save their config in a settings table for example
  • lucasg-1330035337740947496

    Lucas G

    21 days ago

    I have a table component that can be set via JSON. Would work for this use case with a couple tweaks
  • alexsiale_17363-1330044778540302388

    Alex

    21 days ago

    Okay I’m gonna have to see this to understand it, I think I see where you’re guiding me

    I’ll have a play
  • stuster-1330093883530674227

    StuartM

    21 days ago

    Sounds like a good use of a jsonb column in Supabase, that way you can hold a custom set of fields and custom configurations while still read, write / querying parts of it.
  • alexsiale_17363-1330231896168468592

    Alex

    21 days ago

    So if create a new table called “custom tables” and then save the columns for each user in their?

    Then have a table component with repeat columns in toddle that are generated for each user?

    Then the data would be populated based on their respective rows in the “properties” table?

    Trying to visualise this in my head
  • lucasg-1330245342532472923

    Lucas G

    21 days ago

    Yeah basically. The table component needs to be able to render their config
  • alexsiale_17363-1330258120156381367

    Alex

    21 days ago

    Okay okay

    Got some playing to do

Stop scrolling. Start building.

toddle is a visual web app builder that rivals custom code — but accessible to your entire team!

Try toddle — it's free!

© Copyright 2024 toddle. All rights reserved.