thanks for the response fellas.
@praveen The app is called “IGBoston Context Database” feel free to dive in if you want.
@Aleksi_Alkio I’ll try your suggestion shortly. But i wanted to send screen so you understand what’s going on.
This screen represents the fields that are currently being used with standard Valid_Ifs…
Keep in mind this app is for new college students looking up images or info about a specific area in New England.
These are the two main problems I’m having right now
- Say you are a user using this app to look for pictures from in the South Boston area.
To do that, you would have to put in
“Massachusetts” for “State”,
“city of Boston” for "Areas & Counties,
“South Boston” for “Hoods and Cities”
and then “Fort Point Channel” for the “Location”.
(see first attached picture)
But what if you dont know the exact “Hood or City” category Fort Point Channel is in?
I attached a picture of just such a scenario. A user might put in “Boston” for the “Area or County”
“South Boston” for the “Hood and City”,
and then be unable to find “Fort Point Channel” in the “location”.
So the user would have to determine what the right selection is (from both the “Hoods & Cities” or the “Areas and Counties”) to find Fort Point Channel.
(see second attached picture)
That is why i want all the fields available. A user who selects “Massachusetts” for “States”, but doesnt know what to fill in for the “Hoods and Cities” or “Areas and Counties” field can simply access the “Location” drop down to review all the selections with the
“Massachusetts” States filter to find the appropriate location.
Praveen, In regards to your comments about my second point in my previous post, the other fields may indeed be individually evaluated, but i cant confirm because the fields disappear. Is it possible i can make the dependent drops down fields visible at all times?
- Also, I noticed that Appsheet “remembers” the current selection in a dependent drop-down field when it disappears, which is another problem.
As an example. say i switch the switch the States in this example to “Maine”.
The “Area & Counties” still shows “City of Boston skyline” even though it’s not associated with Maine in my database (because it’s obviously not in Maine). This immediately produces a rather garish red “invalid” error on the field. The same thing happens with the subsequent fields once they become available again, which has user correcting error before they continue using the app.
(see third attached picture)
I find this behavior odd, particularly given you comment about the valid_if produces no results.
Is there any way to automatically clear the dependent drop down fields when they disappear, so they dont reappear with errors?
Thank again for the help, much appreciated