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
@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?
@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
@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])
@LeventK
Thanks.
Do the column data types for City and Hairdresser Business Name remain โTextโ ?
(as on screenshot 3 and screenshot 4)
@Kami_Barut
Correct. They can remain as Text
@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.
@Kami_Barut
May I ask are you trying to read the drowdown values from the same table that you are creating records??
@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 ?
@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
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 ?
Hi,
I must be doing something wrong.
Screenshot 6: https://ibb.co/56Cqs94
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
@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?
@Kami_Barut
1.) Itโs not mandatory to use a slice
2.) Iโve mentioned the Show property in the Column structure
@Kami_Barut
Provided you can share your app with levent@able3ventures.com email with co-author status I can check it for you
@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
Youโre welcome
Hi,
I believe you should have received the invitation by now.
I can be contacted anytime at : kamibarut@yahoo.com
Rgds,
KBW
@Kami_Barut
In your Rate table, the key column is the [Hairdresser Business Name] where you are trying to create a dependancy, and the table is set to accept ALL_CHANGES as well. It will not work this way. You shall add an i.e. [ID] column and assign an Initial Value of UNIQUEID() and set it as the key column. Then it will work.
Besides your Register table is using the _RowNumber as the Key column which is not appropriate at all. Provided 2 users try to create/update/delete any record at the same time, the latest record will prevail in the database. You shall change this and add an appropriate key column to this table as well like I have described above. The editor already prompts you as such:
@LeventK
Hi,
UNIQUE(LIST(value1, value2))
What am I supposed to put in LIST ? Should I add myself in my spreadsheet RATE in the column PRIMARY KEY numbers from 1 to 66 and then list them for value1, value2, etc โฆ ?
Are you sure you did not mean function UNIQUEID() ?
KBW
@Kami_Barut
It should be UNIQUEID(), itโs my bad, sorryโฆEdited my response as wellโฆ
@ LeventK,
screenshot A: https://ibb.co/D9Yk4tn
screenshot B: https://ibb.co/mNpm078
screenshot c:
I think we are doing something fundamentally wrong.
KBW
@Kami_Barut
Can you please share the gSheet as well? Thnx
@LeventK
You should have access to the entire spreadsheet now.
Thanks.
@Kami_Barut
Problem solved. The issue was for all the tables, your primary key column was empty. Therefore the expression cannot return a result from the table.
@LeventK
Youโre right, it seems to be working.
(Iโll do a few tests here and there just to be sure.)
I am extremely grateful for your help.
Thank you.
KBW
Youโre welcome
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |