Describe the bug:
I have two “CHOICE” components in a form. The values of the second component depend on the selection of the first one, so I use a filter as follows using the “Screen” option:
Expected Behaviour:
Results should be filtered in the second choice component, but they are not. Looks like the application is not taking into account the “Screen value” selected at the first component, which lives in the limbo as it’s not written into the GDocs yet:
How to replicate:
Create two choice components:
Component #1 is populated from a table with these rows, for instance:
COUNTRY_NAME
USA
CANADA
Component #2 is popupulated from a table with rows with these rows, for instance:
COUNTRY_NAME CITY
USA NEW YORK
USA BOSTON
USA MIAMI
CANADA TORONTO
Selected a value from choice #1 (for instance, “CANADA”)
Create a filter for component two where “COUNTRY_NAME” is “Screen → COUNTRY_NAME”
You’ll see that the choice #2 component dissapears, instead of showing “Toronto”
Mmmm… I might be doing something VERY wrong
I have just done my example and now even the choices are not being listed.
Screencast here: Loom | Free Screen & Video Recording Software
A couple of things to note that might help:
I am building a website, not a app.
I am using GoogleSpreadsheets instead of the Glide tables
I understand that every Screen needs to have an associated source and that the “Screen” values that are shown in the filter must be also columns in the associated source, is that right?