Blog Post

The Qrew Blog
1 MIN READ

January 2023 Quickbase Gantt Plugin - automatic table setup

MattStephens's avatar
MattStephens
Qrew Cadet
2 years ago
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 tables and fields to existing apps?

I have plenty of apps that I'll be adding this Gantt capability into. Most of them will have a couple of existing tables that will be used in the Gantt, but most will need to be created. I could create them manually, or I might go and write my own code to automatically setup an app with all the required tables.... don't want to do this if it's out there already. 

The idea is that the code would create all the tables... then I'd just cull the new tables that I don't need because I already have similar tables.

Cheers,
Matt

------------------------------
Matt Stephens
------------------------------
Published 2 years ago
Version 1.0
  • CharlieMurawski's avatar
    CharlieMurawski
    Qrew Cadet
    2 years ago
    Great feedback Matt! Couple of questions that would be helpful for me to understand this better:

    • 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
    ------------------------------
    • MattStephens's avatar
      MattStephens
      Qrew Cadet
      2 years ago
      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
      ------------------------------
  • AdamKrzyzanek's avatar
    AdamKrzyzanek
    Qrew Captain
    2 years ago
    I am also interested in this new functionality. When I read documentation I am a bit afraid, that so may things are needed to make it work. I thought that this will work on currently existing [Predecessor] & [Duration] columns. But I can give it a try :)

    ------------------------------
    Adam Krzyzanek
    ------------------------------