I'm super excited about the new Quickbase Gantt Plugin which has just been released. However, I'm curious if there is an automation / code out there that will automatically add all the required tab...
Published 2 years ago
Version 1.0
Blog Post
Great feedback Matt! Couple of questions that would be helpful for me to understand this better:
------------------------------
Charlie Murawski
------------------------------
- How would your script know what is missing in each app (unless all your apps are the same)? For example does your app not have any of the tables so you'd like to just bring in all of the Gantt model as 1 model -- or do you have some of the schema in your app and need to somehow identify and add the deltas?
- We are planning some functionality to add missing fields via the dropdowns, perhaps an easy button for an entire table (+any underlying relationships) would go a long way?
------------------------------
Charlie Murawski
------------------------------
Hi Charlie,
In most cases, I would likely already have a Projects table and possibly a Tasks table and Resources table but none of the other tables. For a basic script, I was thinking the script would know nothing, and just create the full gantt model in the existing app. Then I, as the app administrator, would jump in and recreate new relationships to any previously existing tables (like Projects), add any new required fields to those existing tables, and then delete the new tables that I don't need.
Alternatively, the Gantt Plugin settings page could be fully featured to create tables and fields if they don't already exist. So, where you Select a Projects table, there's an option to create the table if it doesn't exist. Similarly, for tables that do already exist, where you map the plugin fields to the table fields, there would be an option to create the field if it didn't exist already.
cheers,
Matt
------------------------------
Matt Stephens
------------------------------
In most cases, I would likely already have a Projects table and possibly a Tasks table and Resources table but none of the other tables. For a basic script, I was thinking the script would know nothing, and just create the full gantt model in the existing app. Then I, as the app administrator, would jump in and recreate new relationships to any previously existing tables (like Projects), add any new required fields to those existing tables, and then delete the new tables that I don't need.
Alternatively, the Gantt Plugin settings page could be fully featured to create tables and fields if they don't already exist. So, where you Select a Projects table, there's an option to create the table if it doesn't exist. Similarly, for tables that do already exist, where you map the plugin fields to the table fields, there would be an option to create the field if it didn't exist already.
cheers,
Matt
------------------------------
Matt Stephens
------------------------------