FILTER(Template, [Template_ID] = tks) selects ALL rows, why?

AppSheet AppSheet Q&A
1

I tried to change only the rows with tks, but my action changed every Package_ID to “1”.
How?

FILTER(Template, true) selects ALL rows.

FILTER(Template, [Template_ID] = tks) also selects ALL rows. How?

random9_2-1698335725331.png
random9_2-1698335725331.png832×696 31.2 KB

Select all rows that fit property

random9_4-1698335870876.png
random9_4-1698335870876.png861×575 47 KB

Change the Package_ID of those packages

random9_5-1698336663014.png
random9_5-1698336663014.png827×356 26.2 KB

2

What is the data type for Template_ID? If it is a Ref column, are the values shown in your table the Row Keys?

I don’t think it should make a difference but I always wrap text literals in quotes :

FILTER(Template, [Template_ID] = "tks")

Other than that, the values in your actions don’t match your results so it is a bit confusing if these were the actual actions you used or some other actions that might actually have an issue. Can you clarify?

1 Like
3

FILTER(Template, [Template_ID] = “tks”)

Or

Select(Template, [Template_ID] = “tks”)

4

Select does not work. I did put the tks in quotes though.

5

Good call for the type of Template_ID: It was a number in a different table, now I changed it to Text.

Quotes for literals don’t make a difference. Thank you :slightly_smiling_face:

6

SELECT will work…just not as written. Need to insert the Row Key column before the comma.

SELECT(Template[Row Key], [Template_ID] = "tks")

This is equivalent to the FILTER()

3 Likes
7

Again, thank you very much!