Forum Discussion

NenadIlic's avatar
NenadIlic
Qrew Assistant Captain
8 years ago

if criteria is met chose from two options

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?
Ask about Quickbase functionality
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    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]