Show a view depending on NOW()

[Alexandre_Plenn]

Hello!
Using Google Calendar data (containing “Start” and “End” columns), I want to show a view according to whether [Start] > NOW() && [End]<NOW()

The goal is to show a screen in front of a meeting room, to mark the room as “unavailable/available” according to google Calendar events specifying the room as Location.

My question: is it possible to build this using an AppSheet? I assume I would need an “available” view, and an “unavailable” view, and use the SHOW IF parameter of each, but it says “This formula is not evaluated in the context of a row, so column values are not available.” Some guidance on how to approach this would be really helpful.
Thank you!

[Rafael_ANEIC-PY]

Hello @Alexandre_Plennevaux, i’m not exactly sure how this interaction would work out, but i think using that expression on a slice and then having a view using the slice is your best bet.