Can you create a global logic that applies to any field that has the key text?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

So if any field in your table is equal to a certain text/word/string, it'll trigger the logic? Otherwise, I'll have to go into every logic and add in if field = "Key Word" then...


i.e.

If [Any Field] = "1", enter true.

vs

If [Field 1] = "1", enter true,

If [Field 2] = "1", enter true,

etc... 

Photo of Yang

Yang

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
There is no concept in QuickBase of a wild card like [Any field] as far as formulas go. So, yes you need to list all fields in your formula that need to be checked.