Inline View from Reference Rows that do not include key of parent table. Is it possible?

AppSheet AppSheet Q&A
,
1

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:
Related Racess
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?

2

Hi @yastaaa

You may want to correct this:

SELECT(Races[_KeyRacingDays], 
  CONCATENATE([Track Name],": ",TODAY()) = [_KeyRacingDays])
)

into this:

SELECT(Races[_KeyRacingDays], 
  CONCATENATE([_THISROW].[Track Name],": ",TODAY()) = [_KeyRacingDays])
)

Please note this is equivalent to:

FILTER("Races", 
  CONCATENATE([_THISROW].[Track Name],": ",TODAY()) = [_KeyRacingDays]
)

For further knowledge, I encourage you to have a look there:

[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216) Tips & Tricks ?

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…

also, for reference:

About this:

yastaaa:

So when i display The Tracks in a Gallery View and click on track image it

I’m not sure what you have in mind, I would think about ticking the “Label” option on the expected column in the table Races.
You may want to provide more informations on this point ?

1 Like
3

Sorry. i was taking a cumbersome path . It is better an easier to go to Behavior and create an Action with the LINKTOFILTERVIEW() Expression and add this in the Row onclick Track Gallery.

LINKTOFILTEREDVIEW(
“Races_Inline”,[_KeyRacingDays]=CONCATENATE([_THISROW].[Track],": ",TODAY()))

This will display the Inline View without any references.

1 Like