Hey there! Ill try and show how I work! So I work with film festivals, placing films into their programmes worldwide, the way I track this is with one master sheet with thousands of festivals listed, their dates past and present, and which films have played at each. I also however need to share updates with the filmmakers about where and when their films have played, I do this by creating another view, hiding all the information about the other films, and only showing the filmmakers info on their film. The issue is, on the main master sheet, multiple dates are listed in the ‘Festival Dates’ field, which is a multiple select field, I like to keep this as I can easily go back and look at previous festival dates. On the individual film view however (which I share with the film team) both dates appear when in fact, I only want to show one of the options because different films play at the same festival in different years. While being able to share this other view, while being to hide certain fields is a real game changer for me as I dont have to update hundreds of individual film sheets, however this is the last thing that I would like to figure out! I have attached a screen shot showing two things, the top is the view from my main master sheet, as you can see in the ‘Festival Dates’ field you can see two dates for the Glasgow Film Festival, one for 2022 and one for 2023, the botton is from another view I have created which I share with the team of a specific film, where their film played in 2022, so in this case, I would like to hide the 2023 option, I hope this makes sense and if there is a way to make this work!
