YES! And I started watching the video @Jeff_Hager recommended (thanks!) but as you can see here from the screenshot, the information I want to filter specifically in this example does not even appear as an option in the details… with the exception of the title.
Again, an array of multiple values cannot be placed into a container that can only accept a single value. For that reason, you need to convert the array into a single value by using a joined list column. At the very basic level, that will create a comma delimited list as a single string of text that you can then display on the details screen, or within the details of your list items. This will allow for a basic text display of the streaming services and allow you to use the built in search functionality.
On a deeper level, you could create a separate table that simply lists all of the streaming services. Then you can create a multiple relation column that links that array to the streaming services table. This would allow you to display an inline list of streaming services on the details screen of each show.
We can go even deeper and build custom filters that utilize that array, and that’s what @Robert_Petitto’s video gets into.
But it seems like your main question is simply for displaying the list of streaming services, so to begin with that, you need to convert it to a single value string and/or create the streaming services table, create the relation, and display an inline list.
Also, it looks like you are currently using the card list layout. I predict that you are going to eventually want to switch that to a Details style layout with an inline list. I say that because you are probably going to want custom filters, and will need a details style layout to achieve that. I also recommend creating a separate single row table (make sure it has at least one row), which you will eventually use as the driver table for your tab. You can then use this table with a bunch of user specific columns to hold the filter values, which can then be loaded into your Shows table using single value columns, and then use IF columns to determine which shows match your filters, and you can filter your list accordingly.
I think I created the correct “joined list” columns and I selected that they be separated by commas. However, as you can tell from the screenshot, when I try to filter them now, every row is an option.
However, in the folowing screenshot that shows how it happens on AirTable, there are specific options you can filter FROM. Within each project, there may be multiple, so I think that’s why there is confusion? So, for any given movie, it could be available on JUST Hulu but then another one can be available on Hulu AND Amazon.
If you want to display the available platforms as text, use the joined list column.
If you want to use the in-app filter, use the array column (I assume Glide syncs your column as an array initially).
I believe I DID use the joined list column, no? It made a new column in my data. I don’t believe the in-app filter worked for me.
