0

Filter on hidden columns

Hi,

How do I get a view which is a subset of the main table which does not show the field to which the filter is applied.

I have a table which lists photographic films which has a text field for name and a multiple choice field for format (135, 120mm, 4x5 etc) I want a view which only shows all 135 film names, not the contents of the format field.

Any help would be appreciated

Regards

Chris

8 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Just to be sure, you are talking about a view like a new table view or form view or chart view.

    Or are you talking about a view element?

      • Chris_Mullett
      • 2 yrs ago
      • Reported - view

      Fred Sorry should have been more specific. I'm hoping to be able to add a combo box to a form based on the view. Currently I get a concatenated string showing all the values in the name and format fields. Just want the name.

    • Fred
    • 2 yrs ago
    • Reported - view

    It will helps us all if you can post the code you are using and any information about the table structure that could help.

    Thanks,

      • Chris_Mullett
      • 2 yrs ago
      • Reported - view

      Fred 

      Table Camera has ID, Camera_Name (text), Roll/Sheet (Choice - see Screenshot 1) ....

      Table FilmStock has Film (Text), MediaType(Multiple Choice - see Screenshot 2).........

      Table Film has Camera (Link to Table Camera see Screenshot 3), Cut Sheet (Link to Table FilmStock see Screenshot 4)

      The Camera link works as a Combobox, the CutSheet link works as PopUp with the filter applied to the Media Type column and only displays the appropriate rows - see Screenshot 5

      I want the CutSheet link to be a combobox, but just changing the show as parameter results in the field displaying a concat see Screenshot 6 instead of the film name as per screenshot 7.

      I hope that all makes sense.

    • John_Halls
    • 2 yrs ago
    • Reported - view

    Chris Mullett To filter on a hidden field create a formula field and chose a field you do want to display. Set a script in the formula field to show this data if the filter condition is true, and as an empty text field if it is false. Show the formula field in your view in place of its original and filter it to show non-empty fields thus: != "". You can also rename the column to match in the view.

    I can show screenshots of this working if you wish.

    Regards John

      • Chris_Mullett
      • 2 yrs ago
      • Reported - view

      John Halls Thanks John. Sneaky! I love it, job done, appreciate the help.

      Regards

      Chris

    • Fred
    • 2 yrs ago
    • Reported - view

    Welcome to the unwritten logic of Ninox. When you switch from pop-up to combo box, Ninox changes how you modify what is shown. If you have the reference set to Pop-up, then to modify it you change the Show As. If you change it to a Combo box then suddenly you modify what you see by clicking on Edit columns... button at the the bottom of the window and then move the field name from the right side to the left side.

      • Chris_Mullett
      • 2 yrs ago
      • Reported - view

      Fred Thanks Fred. This together with the info from John Halls  is very useful. enabled me to achieve my objective. Appreciate the help.

      Regards 

      Chris

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 8Replies
  • 165Views
  • 3 Following