11 Replies Latest reply: Sep 6, 2012 5:55 AM by jerouy.qv RSS

    How to filter one column based on another when creating a select field?

      Hi Folks,

       

      Say, I have a table like this:

       

      COL1
      Visible
      1yes
      2yes
      3no
      4no
      5yes

       

       

      Normally I can create 2 fields: COL1 and Visible. COL1 shows all values (1,2,3,4,5) and Visible shows 'yes' and 'no'.

      When I select 'yes' in 'Visible' manually, 1 2 5 will be white in COL1 and 3 4 will be greyed out.

       

      But how can I create COL1 field with a condition so that it can by default show only 1 2 5 without having the user manually selecting 'yes'? (In this case I don't need to create the 'Visible' field at all)

       

      Is it possible doing so without creating new tables?

       

      I am aware there is a "conditional" checkbox in every field's Properties - Expressions tab. Is it the right place to look at? How to write the condition?

       

      Thanks,

       

      Jeremy