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
1 Like
This should help you to figure out how to obtain data from another table with a filter
1 Like
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
2 Likes
https://help.appsheet.com/en/articles/5321291-using-start-expressions-in-templates
This page helped me .
thks to all for your recommendations.
2 Likes