Create a Dynamic JSON Schema form using a table

App Building
,
#1

So I was trying to build a web admin panel for our mobile app which uses PostGreSQL database.
Now what happened was that for each table I had to manually create tables and forms for CRUD operations.
So I thought I would create a re-usable module that simply takes the table name as an input and then plug-in the module.
However while trying to do that, I ran into an issue. There doesn't seem to be any way of dynamically generating/changing the form based on table data.

I was trying to use a table and then trying to create a JSON Schema form from there, but wasn't able to find a way.

Is there a way to get the JSON schema of a form from the properties of a table somehow? columns property doesn't seem to work directly. Or is there any other way to achieve what I want to do (A Re-usable CRUD module that simply takes the table name and created CRUD for it)

Thanks,
Parth

#2

Hey @Parth_Sharma!

Unfortunately, there's a bug at the moment preventing JSON Schema forms from rendering dynamic schema. Do you have a sense of how many different tables the form would need to interact with? And how different are those tables?

Also, could you describe a bit more about why it's particularly useful to your use case that you be able to dynamically generate a CRUD form? It might help in coming up with workarounds!

#3

The use-case is what I mentioned in the original post. I'll elaborate on it.

So I have a LOT of tabs in app for doing CRUD operations on different tables, the contents of which are more or less identical, i.e. they look the same, use the same components and similar queries.
So currently for each new table/feature, I have to duplicate this tab/re-create the same interface each time I have to add CRUD functionality for a new table. I was trying to reduce this work by creating a re-usable module which would work out of the box just by passing the table name in the module inputs :slight_smile:

But due to this issue I wasn't able to do it. So wanted to know what would be the best way to accomplish this.

#4

Do let me know if you need more info on the use-case

#5

Hmm... You can generate a form from your table so as long as it only needs to be made once that might cut down on the time it takes but it sounds like you might already be doing that :thinking: Do you think something like this might help?