Not sure the best approach here. I have two main tables for an app that logs check in and check out dates of Maps.
Maps[Map(key), Name, Town, Status]
History[Key, Map, Check In(date), Return(date)]
When a map is checked out the return date is left blank. The “blankness” of that return date drives the Status column in the Maps Table (Google Sheets Side) by an arrayformula that applies “In” “Out” or “Overdue”.
Over to Appsheet, In my UX i have Maps_Detail that has related history in it. It shows all the checkouts and checkins for that map.
What i can’t work out is how to hide the “Add” button in Maps_Detail View if there is a blank return date assiciated with that map already Or if the Status for that map is “Out”.
I’m currently messing around with Behaviour > Actions > [History] > Add (system generated) > Behaviour > Only if this condition is true:
NOT(IN( CONTEXT(“View”), LIST(“Maps_Detail”))),
COUNT( FILTER(“History”, AND( ([Map] = [_THISROW].[Map]), ISBLANK([Return])))) = 0
I don’t think i’m approaching this is the right way, some guidance would be appreciated.