you could have 3 different superimposed portals and hide 2 of them, leaving one visible, depending on the global.
Or use a tab with invisible headers (will make the whole thing easier for portal editing) and go to a specific tab depending on the global.
I've thought of that, but I am not sure I want overlapping portals. If I did that I'd use slides to switch between.
I think the calculation should work. I just ponder calculation speed. I think it should not be an issue as long as all of the fields exist in the same table.
Get Outlook for iOS<https://aka.ms/o0ukef>
I wonder why Clothing - Shirt - Fatigue are all in the same field in the first place.
1 of 1 people found this helpful
How about something like:
Let ( [
~f1 = Filter1 ;
~f2 = Filter2 ;
~f = List ( ~f1 ; ~f2 ) ;
~item = List ( categoryField ; typeField ; colourField )
Substitute ( "¶" & ~item ; [ ~f ; "" ] ; [ "¶¶" ; "" ] ; [ "¶" ; " - " ] )
They are in separate fields. The calculation field is for a drop down list they can filter, but if they don't they can just start typing shirt an find it, etc.