Forum Discussion

NickMangine's avatar
NickMangine
Qrew Member
6 years ago

Cannot set field value when filtering for an Automation

Hey all. I'm trying to create an automation to delete certain records each day. I've done this before but the interface does not look the same for the current table. Here is the way I expect it to...
Formulas and functions
Quickbase Automations
AustinK's avatar
AustinK
Qrew Commander
6 years ago
Is "Should Delete" a field in both tables or is it a lookup to one of those tables? That might make a difference. Automations are weird sometimes.

What do you see as options for the second automation? Are you able to pick anything other than the greyed out unchecked?
  • NickMangine's avatar
    NickMangine
    Qrew Member
    6 years ago

    Both fields are formulas in their respective tables. I just happened to name them the same.

    I cannot change the value in the second automation.

    I thought it was possible the automation was only giving me existing options (i.e. all the records were unchecked for this field) but I purposefully created a record with where "Should Delete" is checked. Still see the same (no) options :(



    ------------------------------
    Nick Mangine
    ------------------------------
    • NickMangine's avatar
      NickMangine
      Qrew Member
      6 years ago
      Turns out this is a known bug. I opened a support case and was told as much.

      ------------------------------
      Nick Mangine
      ------------------------------
      • JessicaFeauto's avatar
        JessicaFeauto
        Qrew Member
        6 years ago
        Nick,

        Did they give you any idea when it is going to be fixed?  I'm running into the same issue

        ------------------------------
        Jessica Feauto
        ------------------------------