Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 05, 2024 09:24 AM
Hi,
I'd like to give users a button to create a new table in the backend with default fields and table name. This table could be a duplicate of an existing table. Is is possible to implement this functionality on the front end?
Solved! Go to Solution.
Aug 05, 2024 10:30 AM
While technically possible with an automation script and use of the web API, this is not realistic. In general, interface users should not be creating new tables. The interface user could not even access the new table from the interface because there would be no interface page for the new table. Setting up a database can be very different from setting up a spreadsheet.
Since you say that the new table would be a duplicate of an existing table, I suggest that you look into different ways of filtering records in a single table. I'm guessing that you should look into a system with linked tables: one table with the regular data, and another linked table with a record for each set of records that you would want in a different table.
Aug 05, 2024 10:30 AM
While technically possible with an automation script and use of the web API, this is not realistic. In general, interface users should not be creating new tables. The interface user could not even access the new table from the interface because there would be no interface page for the new table. Setting up a database can be very different from setting up a spreadsheet.
Since you say that the new table would be a duplicate of an existing table, I suggest that you look into different ways of filtering records in a single table. I'm guessing that you should look into a system with linked tables: one table with the regular data, and another linked table with a record for each set of records that you would want in a different table.
Aug 08, 2024 05:23 AM
Thanks. Looks like this is not the intended use case for AT.
The intention here is to create a means of version control and history for data. Where each new table added by a user is a version (3D data structure controlled by the user). As you suggest, might need to look at doing this in a single table and use filtering.