0

Filter

I need to filter the records in the Tracks table in a View based on the selection of the Multiple Choice Dynamic 'Select Album' field.

6 replies

null
    • Fred
    • 2 wk ago
    • Reported - view

    You can use the record() command.

    let selectedAlbum := record(Album,number('Select Albums');

    Of course make sure the table name is the appropriate one.

    Then you can use the variable in your View formula

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

    let s := for i in numbers('Select Albums') do
        record(Albums,i).'Composer Name'
    end;
select Albums where contains(s, 'Composer Name')
      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 wk ago
      • Reported - view

       

      Albums table with a Selection field (dynamic Multiple Choice type) that displays combinations of Artist and Title from the Tracks table.

      Tracks table with the fields: Artist, Title, Track all text field.

      Objective:

      Display in a View within Artist the Track records that match the option(s) selected in the Selection field.

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

       

      What if you place my formula in a view and change the field names and table names to suit your situation? Can you try this and if it's not working, please place a testdatabase here....

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 wk ago
      • Reported - view

       

      I send a very simple DB, only 3 Tables (my main DB have more than 250 CD's)

      Artist, Albums and tracks, 

      On Albums I have a botton (Recover Tracks) these generate the track list on Tracks Table by artist.

      Another info that generate the list tracks is on Formula field on Albums.

      On Albums I have a Tab name tracks here have Selection field (dynamic Multiple Choice type) that displays combinations of Artist and Title from the Tracks table, and need on view display the tracks by selected album + artist.

      My Collection.ninox
      • Ninox partner
      • RoSoft_Steven.1
      • 2 wk ago
      • Reported - view

       

      Something like this?

      let s := for i in numbers('Multiple choice (dynamic)') do
        record(Albums,i).'Artist_>'.'Artist Name'
    end;
select Tracks where contains(s, Artist)

Login to reply

Content aside

  • Status Answered
  • 2 wk agoLast active
  • 6Replies
  • 67Views
  • 3 Following