Hello!
I have a specific requirement I’d like to address some way, but I am not entirely sure how I could achieve the ideal outcome.
I have a Retool app hooked to a postgresql database. There are multiple tables in the DB, and one of the tables there is a bigger table (let’s call it ”products”). I’d like to design the app in a way that a user of the Retool app would be able to define their own ”custom properties” that should be stored in the ”products” table. One way to achieve this on the database level would be to have one extra JSON column in the ”products” table, and in that column we would store something like:
{ ”custom_property_name”: ”Secondary Color”, ”custom_property_value”: ”black” }
Is there any way I could achieve such flexibility on the frontend, namely a Retool form? First, the Retool user would define the name of the field and the value for the field somehow. Second, when they have defined a custom property, the user would see the custom property on the Retool form like any other text input (or similar) component(s).
Has anyone achieved such flexible custom properties like this?
Thank you.