Forum Discussion

NickMangine's avatar
NickMangine
Qrew Member
5 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
JessicaFeauto's avatar
JessicaFeauto
Qrew Member
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
5 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
------------------------------
  • JessicaFeauto's avatar
    JessicaFeauto
    Qrew Member
    5 years ago
    Thanks Nick.  I did something similar with a Formula Checkbox field.  Easy to facilitate but I can just imagine 3 years from now having that field still be hanging around and no one understanding what it was!

    ------------------------------
    Jessica Feauto
    ------------------------------
  • JENNIFERPASCHAL's avatar
    JENNIFERPASCHAL
    Qrew Trainee
    5 years ago
    Hi Nick,

    It is now March and I am experiencing this issue as well. I just discovered this thread trying to find a fix. Did you ever hear back on the bug?

    Thanks,
    Jennifer

    ------------------------------
    JENNIFER PASCHAL
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew Champion
      5 years ago
      I recently had a problem where the system was not recocogniing

      not equal to unchecked

      so I made a new formula text field based off my checkbox field and used that as my filter.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
    • NickMangine's avatar
      NickMangine
      Qrew Member
      5 years ago
      I haven't heard anything, Jennifer. I also recently tried again but still could not use a checkbox to filter my automation.

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