0

Using the Filter option

Is it possible to filter a field based on criteria in another field.

eg: 
Field 1 Serial Required is 'Yes/No'

Field 2 Serial Number is 'nnnnnnn'

In Field 2 Filter:  Field 1 = Yes

6 replies

null
    • szormpas
    • 2 mths ago
    • Reported - view

     Hi,

    In which scenario do you want to filter a field's data - as a column in a table, or not to be displayed at all in the record form?

      • Alan_Cooke
      • 2 mths ago
      • Reported - view

       

      In a report I would like to not use the SERIALIZE? field/column to display on 'Yes' results.  It would be handy if it were possible to use the SERIAL NUMBER field with a filter that in effect says:

      SERIALIZE? = yes

      • John_Halls
      • 2 mths ago
      • Reported - view

       Think of a column that you know you want to display, eg Install Date. Add a formula field to the view (not the table) and put

      if SERIALIZE then 'INSTALL DATE' end

      And then set the filter to 

      !=null

      I use this technique all the time and it works like a charm.

      Regards John

      • Alan_Cooke
      • 2 mths ago
      • Reported - view

       Thanks John.  Thing is this is for a report.  In other words the report only shows 'Yes' but I would prefer if the Serialize? column was not displayed in the report.

    • Ninox partner
    • RoSoft_Steven.1
    • 2 mths ago
    • Reported - view

    You can use a trick by placing the column outside the right of the print template so this column would not be visible in the actual PDF. It’s sometimes hard to drag outside the page but with trial and error it’ll work.

      • Alan_Cooke
      • 2 mths ago
      • Reported - view

       Great idea which I have tried but it does mess with the border styling as I recall.  I wonder if 2025 or 2026 will be the year for print engine improvements :-).

Login to reply

Content aside

  • 2 mths agoLast active
  • 6Replies
  • 73Views
  • 4 Following