Forum Discussion

BethanyHudson's avatar
BethanyHudson
Qrew Trainee
6 years ago

Help with Automations

Help! My automation is not working and I'm not sure why. I have it set to "checkmark" a field (Report Received) any time a user adds a record to Quarterly Reports (document upload). Here's a screen shot of the report I'm doing it for.


------------------------------
Bethany Dickey
------------------------------
Quickbase Automations
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    6 years ago
    Hi Bethany,

    For this Automation are the Quarterly Reports bring added to a child table of your Contracts table? If so is it set up that an individual record on the table we are seeing here would have one Quarterly Report below it or is it going to be getting multiple Quarterly Reports over time?

    Do you have a screenshot of the logic of your Automation trigger and steps by chance?

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------
    • BethanyHudson's avatar
      BethanyHudson
      Qrew Trainee
      6 years ago
      Yes, the documents table is a child to the contracts table. Here is the trigger and action screen shots.


      ------------------------------
      Bethany Dickey
      ------------------------------
      • AustinK's avatar
        AustinK
        Qrew Commander
        6 years ago
        A few things I see here. Although going over Evans questions you may need more than this depending on how you want it to work exactly.

        You said the documents table was a child to the contracts table. The automation is showing that you are looking for modifications to a record in Contracts. You want to look for a modification happening in your Documents table as that is where the record is being modified and the file uploaded.

        In the second screenshot you have the automation set to modify anything that has been created after 3/23/2020 so this would potentially modify many records at once. What you usually want to stick with is something like "[Record ID#] is equal to the [Record ID#\ of the trigger" which will modify the record that triggered the automation. That is what is used in most cases to prevent the automation from modifying way more than it should. Just an FYI for you in the future.

        However in this particular case what you likely want to do is have the trigger be in your Documents table. Then have the trigger be a record being added there and when the automation is editing the record in the Contract table it should match the "[Record ID#] is equal to [Related Contract]" I believe that would work for you but test it out first as I have not. I may have it backwords and it may need to be "[Related Contract] is equal to [Record ID#] from the trigger" it is hard without it being in front of me.