Questions about app template "Export CSV of filtered rows"

[eric_niedergang]

Hi,

I have a question about this app demo template :
https://www.appsheet.com/templates/This-app-shows-how-to-filter-your-data-using-a-form-and-export-it...

The size selector appears when I choose a color
How does it work? I don't see anything in the app that allows me to do this?

Thnaks

[Suvrutt_Gurjar · Accepted solution]

The logic to first select [Color] and then [Size] based on the [Color] selected in the app you have referred is being done through an approach called 'dependent dropdowns"

Please take a look at the following help article

Dependent drop-downs - AppSheet Help

In the sample app you have referred, please take a look at the valid_if expressions of the [Color] and [Size] columns in the 'Serach-Form" table.

[Color] has valid_if of Items[Color] and [Size] has a valid_if of Items[Size]

[eric_niedergang]

I understand that's a "magic" behavior. 😀

https://support.google.com/appsheet/answer/10106620?hl=en&sjid=7109900515662348809-AP#:~:text=When%2....

When the AppSheet platform finds several columns that have Valid_If constraints from the same lookup table, it assumes that the desired behavior is to have dependent drop-downs. Occasionally, this may not be what you wanted.

[Suvrutt_Gurjar]

---

@eric_niedergang wrote:

understand that's a "magic" behavior. 😀

---

You are correct.

---

@eric_niedergang wrote:

it assumes that the desired behavior is to have dependent drop-downs. Occasionally, this may not be what you wanted.

---

You are correct. In such cases , my practice is to create lookup lists table with an empty column between two lookup list columns. So if there are 5 lookup list columns that do not have dependency, there are 4 empty columns in between.