Have a Table for Tracks where [Track Name] is the key.
Also have a table Races in which one column is [Track Name] but here the Key is a concatenation of [Track Name] and [Date]
What i am trying to do is to show a inline view of Races for Todays Track.
If you reference [Track Name] of Races to Track an automatically Related Races column generated by appsheet in Tracks Table., with this formula:
REF_ROWS(“Races”, “Track Name”)
I would like to create a reference with SELECT.
SELECT(Races[_KeyRacingDays], (CONCATENATE([Track Name],": ",TODAY()) = [_KeyRacingDays]))
So when i display The Tracks in a Gallery View and click on track image it. Is this possible?