related colum, ref_rows

[J_jvs]

Hi team,

how can i create a related column by name and  filtered by month?

similar to:

SELECT(ref_rows("data","name"), [_thisrow].[month] = [month]

thks in advance

jordi

[TeeSee1]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-FILTER-LOOKUP-MAXROW-MINROW-REF-ROWS-and-SEL...

This should help you to figure out how to obtain data from another table with a filter

[Craig_QREW]

Okay, first thing that helped me a lot was looking at the REF_ROWS() function in the AppSheet documentation. I have attached it below, it does tell you what other functions it is basically the same as. Also I am not sure that you would need to use REF_ROWS() within a select function. Instead I recommend using one or the other and then doing it twice once for the name and once for the month and wrap it in the and statement. Hopefully this helps some. 

Craig 

QREW Technologies

REF_ROWS() 

[J_jvs]

https://help.appsheet.com/en/articles/5321291-using-start-expressions-in-templates

This page helped me .

thks to all for your recommendations.