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
      ------------------------------
      • NickMangine's avatar
        NickMangine
        Qrew Member
        6 years ago

        They did not. Just that they would let me know when it was. So if you open a ticket, my guess is they would add you to that list as well.

        I ended up working around the issue. It's pretty simple to just create a text formula field that looks something like this:

        If([checkbox field],"yes","no")

        Then you can test the text field instead.



        ------------------------------
        Nick Mangine
        ------------------------------