Skip to main content
Question

if criteria is met chose from two options

  • November 15, 2017
  • 0 replies
  • 22 views
I am trying to create a formula text field where on choices I would have either one result, or a possibility to chose from the two....the example is bellow:
Field name is: MT (example)
If ([FIELD 1] = "", "General",
If ([FIELD 2] = "", "Fluid",

and now the problematic criteria: If ([FIELD 3] = <>"", "Flexible" or "Optimized"
In other words if Field 3 is not blank, I should have a choice to select either Flexible or Optimized.

Is there a way to do that?
    This topic has been closed for replies.

    • ArchiveUser
    • Quickbase Alumni
    • November 15, 2017
    Formulas present a result and are going to be separate from data entry / data selection fields.  It sounds like your problem might be better solved with Form Rules, rather than a formula. 

    I would set it up so that you would have a multiple choice drop-down for Flexible or Optimized and a formula similar to this:

     If ([FIELD 1] = "", "General",
    If ([FIELD 2] = "", "Fluid",
    If ([FIELD 3] <>"", [Drop-down Field],"")))

    Then, I would setup a form rule that worked like this:

    When [Field 3] is not blank, Require [Drop-down Field]
    Terms & ConditionsAccessibility statement