Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Task Template Type to filter what tasks are imported

Hi everyone.

I have a table for Tasks and a table for Task Templates.  On the Task Templates table I created a field for Task Template Type.  I am using this to control which tasks get imported.

On the Tasks table I have a checkbox for "Import Task Template."  When a user checks it (under my old logic) it would trigger an automation for a table import to copy all tasks from task template into the project.

Now, I want to somehow allow the user to select from the field in Task Templates for Task Template Type and use that to control the tasks that are copied over.

I was thinking I need a lookup field somehow next to the checkbox to display the Task Template Type and use that as a record picker.  But I dont think this is right as I dont even know where to begin here....

Any ideas?

Thanks!

------------------------------
Ivan Weiss
------------------------------
Quickbase Automations
Template
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    So one approach is to make a new table with a single record in it as a helper table to have a place to record the focus template Record ID#.  That will be Record ID# = 1 and then you make a relationship wherever you need to know the focus template # (probably the templates master table) with a reference field that calculates to 1.​

    So the Automation will run and record that value on this special record.  Then you adjust the Automation to limit the record being copied to those which match the focus template.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      And if I do this I make the relationship to the project as well so that on the project next to the button to create the tasks there is a dropdown to pick which template to choose from?

      ------------------------------
      Ivan Weiss
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        Yes, exactly.

        So the trigger is pushing a button which triggers the Automation.  The first step in the Automation will be to copy the value of the focus template into that special record.

        Then when the subsequent step of the Automation runs the records to be copied will need to match the Focus template.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------