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.

3 replies

null
    • Fred
    • 2 days 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 days 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
      • yesterday
      • 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.

Login to reply

Content aside

  • yesterdayLast active
  • 3Replies
  • 37Views
  • 3 Following