AnsweredAssumed Answered

Looking for "contains" operator rather than = when filtering a portal with a drop-down menu

Question asked by BenHunter on Apr 18, 2013
Latest reply on Apr 19, 2013 by BenHunter

Title

Looking for "contains" operator rather than = when filtering a portal with a drop-down menu

Post

     Hi,

     I'm setting up a database to help organise songs played at church. I have a scheduling layout with a portal to songs for the user to refer to. The portal can be filtered according to the key the song is in and according to a "tags" value list (e.g. hymn, standard, new song). The tags field in the songs table is set using a checkbox setup and the filtering of the portal is done with a dropdown menu. The calculation for the portal filter looks like this:

     (Schedule::Tags_Global = "All Tags" or
     Schedule::Tags_Global = Songs::Tags) and
     (Schedule::Key_GLobal = "All Keys" or
     Schedule::Key_GLobal = Songs::Key)

     It works well with a 'Refresh Global value' script triggered by both gobal fields.

     I run into a problem, however, when a song has more than one tag - it doesn't show up in the filtered results. e.g. if a song is tagged as a 'hymn' and a 'new song', that song won't show if I filter the portal with 'hymn' or 'new song'. What I would like is an operator to replace "=" - something like 'contains' in the second line of the calculation. Can anyone suggest a solution? I am learning FM as I go.

     Thanks in advance!

Outcomes