Unable to get dependant dropdowns to properly work

AppSheet AppSheet Q&A
1

Hi,

I have been trying for the last 3 hours (youtube videos, online documentation) to have in a form
the business names in a chosen city appear in a dropdown select box depending on which city the user picked previously also in a dropdown select box.

Screenshot 1: https://ibb.co/4YT7ckp

Screenshot 2 [ My table (“RATE”) with the relevant fields ] : https://ibb.co/f0rWshg

(note: I tried all field types for the two fields : ENUM, LIST, TEXT , etc etc … )

Screenshot 3 (The design of the first dropdown select box): https ://ibb.co/B2xhMqg

(note: here as well, I tried all field types)

Screenshot 4 (The design of the second dependant dropdown select box): https ://ibb.co/kJf3q13

(note: here as well, I tried all field types)

Through all my attempts, the list of cities and business names never show up in the form. Actually, the two fields completely disappear from the form.

Could someone give me a step by step guide ? I am completely lost as of now.

Thank you for your time.

Rgds,

KBW

2

@Kami_Barut
Your screenshot3 and 4 images are completely missing so it’s too hard to understand its content and where you are mistaken. Can you please fix it so that we can check?

3

@LeventK
Thanks for your answer.
Appsheet forum only lets you include two url links within one post.
The workaround I used for Screenshot 3 url link and Screenshot 4 url link was to include
an empty space between the “s” from “https” and the semicolon.
The correct url links are:
Screenshot 3: https://ibb.co/B2xhMqg
Screenshot 4: https://ibb.co/kJf3q13

Thanks for your time.

KBW

4

@Kami_Barut
Use below expression for your [City] column

SELECT(RATE[City],TRUE,TRUE)

Use below expression for your [Hairdresser Business Name] column

SELECT(RATE[Hairdresser Business Name],[City]=[_THISROW].[City])
5

@LeventK
Thanks.
Do the column data types for City and Hairdresser Business Name remain ‘Text’ ?
(as on screenshot 3 and screenshot 4)

6

@Kami_Barut
Correct. They can remain as Text

7

@LeventK
It is not working, you can see on screenshot 5 that the two fields are entirely skipped in the form.
Screenshot 5 : https://ibb.co/6sWrvTJ
I added:
a) SELECT(RATE[City],TRUE,TRUE) in the section DATA VALIDITY → Valid If input field of the City column.
b) SELECT(RATE[Hairdresser Business Name],[City]=[_THISROW].[City]) in the section DATA VALIDITY → Valid If input field of the Hairdresser Business Name column.

8

@Kami_Barut
May I ask are you trying to read the drowdown values from the same table that you are creating records??

9

@LeventK
Actually, yes. It may have been a misunderstanding from my part on how to display form fields and collect form entries.
What is the correct approach ?

10

@Kami_Barut
Instead of Valid_if try using Suggested_Values property instead. But I may advise moving those City and Business names to a separate table and read those dropdown values from that table thru Valid_if

11

Should I create a different table with just those two columns filled with all cities in the City column and hairdresser business names in a Hairdresser Business Name column and refer to that new table in the sections DATA VALIDITY → Valid if input field inside the RATE table ?

12

Hi,

I must be doing something wrong.

  1. I created a new table called LOCATION containing all cities and every business name tied to each specific city.

Screenshot 6: https://ibb.co/56Cqs94

  1. In the table RATE, I added in the City column
SELECT(LOCATION[City],TRUE,TRUE)

In the Hairdresser Business Name column, I added:

SELECT(LOCATION[Hairdresser Business Name],[City]=[_THISROW].[City])

The form is shown but completely skips the City and Hairdresser Business Name columns, i.e: screenshot 5.

Any ideas ?

Thanks.

KBW

13

@Kami_Barut
Are you using a slice? If so, ensure that those columns are included in your slice. Also can you please check the Show_if of those columns in case they had unintentionally been switched off?

14

@LeventK

  1. Is it mandatory to use a slice to show a simple form with select dropdown options ?
  2. For your second remark, I am a bit confused. Do you mean Show_if in the UX for my form view ? (Screenshot 7 here: https://ibb.co/mS54Lzt ) It is empty but the entire form is shown.
    For the Location table, the City and Hairdresser Business Name fields SHOW? checkboxes are checked.
1 Like
15

@Kami_Barut
1.) It’s not mandatory to use a slice
2.) I’ve mentioned the Show property in the Column structure

2X_a_ad478bbf4b157ecec3284b6526371f5fefaf9a09.png
2X_a_ad478bbf4b157ecec3284b6526371f5fefaf9a09.png906×390 15.6 KB

Check them not in your LOCATION table but in your RATE table instead

16

@LeventK,

  1. Then I won’t use a slice for my form.
  2. Every single column name in the RATE table (as well as in the LOCATION table) which needs to appear in the form has the property Show? checked, i.e: ON.
17

@Kami_Barut
Provided you can share your app with levent@able3ventures.com email with co-author status I can check it for you

18

@LeventK,
Sure, give me just a bit of time tonight (I am currently looking at the doc, this is my first app) and I’ll give you co-author status.

I really appreciate your patience and energy.

Thanks.

KBW

19

You’re welcome

20

Hi,
I believe you should have received the invitation by now.
I can be contacted anytime at : kamibarut@yahoo.com
Rgds,
KBW