Hi all, Iโve tried creating a dropdown using a valid_if for 3 different columns:
Medium (Book, movie, etc)
Genre (Horror, comedy, etc)
Status (Completed, in progress, etc).
https://imgur.com/msVb2ny
Iโve defined the unique values for these using a unique() formula in a second sheet called valid_if_ref. Basically Iโm following this guyโs instructions:
https://youtu.be/WA6Ku8ta2MU
He said itโs ok to have the references for all my dropdowns in the same sheet, so thatโs what Iโve done.
Then, Iโve gone into table columns and defined them as text fields with constraints as follows:
= Valid_If_Ref[MediumList]
= Valid_If_Ref[StatusList]
= Valid_If_Ref[GenreList]
It comes back green with no errors.
The problem is that the genre dropdown changes to a selectable card with only one value when I select a medium:
No medium selected, genre is a properly selectable dropdown:
https://imgur.com/Svobh3j
Medium changed to Book, genre changes from dropdown to only one selectable box, Action:
https://imgur.com/TCbKIsH
Medium changed to Movie, genre changes from dropdown to only one selectable box, SciFi/Fantasy:
https://imgur.com/wD7DqA6
It appears I may have enabled dependent dropdowns, because genre appears to depend on medium. If I try to edit earlier records, I will not see a Genre dropdown, presumably because a Medium has already been selected
Another issue is that the Status dropdown is completely missing no matter what. Iโve made it a required field, but it still doesnโt prompt me to fill in the Status in order to submit the record. I have double checked to make sure show is enabled for all the boxed (Status is 3rd from the top):
https://imgur.com/bd8urTo
Any help is appreciated!
Solved! Go to Solution.
Sorry, just realized the thread I linked arenโt exactly relevant. They are about still using dependent dropdown, but just disabling Appsheetโs internal dependent dropdown functionality. You donโt want any dependency.
I recommend you still read the linked thread for a greater understanding, but your problem can probably be solved just by replacing
Table[column]
with
SELECT( Table[column , TRUE )
Sorry, just realized the thread I linked arenโt exactly relevant. They are about still using dependent dropdown, but just disabling Appsheetโs internal dependent dropdown functionality. You donโt want any dependency.
I recommend you still read the linked thread for a greater understanding, but your problem can probably be solved just by replacing
Table[column]
with
SELECT( Table[column , TRUE )
That worked perfectly, thanks! Out of curiosity, do you know why Table[column] didnโt give the right answer? Itโs what the youtube video I followed specified. More interestingly, do you know why it gave three different behaviours (Medium came through fine, Genre became enum of 1, Status disappeared altogether)?
Iโd assume simply because Appsheetโs automatic dependent dropdown functionality was activated. But I canโt really follow exactly what youโre saying, and Iโm too lazy to open your linked screenshots (you should paste them directly into the post, not link to imgur).
Afraid I could only do 2 screenshots, as I am a new user, but thanks anyways!
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |