HI GUYS
Iโm a beginner in appsheets
I want to ask as a beginner โฆ
I made dependent dropdowns using valid if with the state and city columns and its works. but I can only choose one option in the country column, how can I choose 2 or more choices in the country column. is it possible guys? โฆ
thanks in advance
Solved! Go to Solution.
Yes. @GreenFlux already answered that question. You will then need to change the Valid If expressions I gave as follows:
CABLE UP:
SELECT(
GARDU[CABLE UP],
IN([_THISROW].[GROUP], [GROUP])
)
NH FUSE:
SELECT(
GARDU[NH FUSE],
IN([_THISROW].[GROUP], [GROUP])
)
Change the column type of Country
to EnumList.
itโs doesnโt workโฆ
If you donโt provide the values directly (as shown here), then you must enable Allow other values
.
Try changing it back to EnumList and turn on Allow other values
.
thanks for the answer broโฆ but it doesnโt work because maybe you havenโt understood my question yetโฆ cause I just took the example of the parable in the question above
this is a valid if display in my application
if I select โAโ in the COLOUM GROUP it will appear in the CABLE UP data coloum from group A cable up (based on the validation data in my spreadsheet image), then if I select one of the CABLE UP coloum options then the NH FUSE coloum will appear ( picture 3)โฆ
my question is
first: how can I make more than 1 choice in the GROUP column, and the data in the CABLE UP column follows the choices in GARDU.
second: (image 4)
how to order in the NH FUSE column the data that appears matches the spreadsheet based on the GROUP selection
hope you can understand my question, and can provide a solution about itโฆ
thanksโฆ
So you asked a question that has nothing to do with what you really want? Why did you choose to be difficult?
yeahh sorry; D I canโt explain my question well so I try with a question that is easier for me to explain and hope to get a little picture of the answer, but it doesnโt work.
Iโm guessing you want the user to select a group, then for CABLE UP, CABLE DOWN, and NH FUSE to only show values associated with the chosen group?
Yes exactlyโฆ what can i do for it ?
Set the Valid If for the CABLE UP column to the following:
SELECT(
GARDU[CABLE UP],
([_THISROW].[GROUP] = [GROUP])
)
For NH FUSE, should all values for the chosen group be shown, or only those are match both the group and the CABLE UP value?
yes for NH FUSE all values must be shown
Then for the Valid If expression for NH FUSE, try this:
SELECT(
GARDU[NH FUSE],
([_THISROW].[GROUP] = [GROUP])
)
Thanks itโs worksโฆ one more question is it possible in the group column I chose more than one choice ?
Yes. @GreenFlux already answered that question. You will then need to change the Valid If expressions I gave as follows:
CABLE UP:
SELECT(
GARDU[CABLE UP],
IN([_THISROW].[GROUP], [GROUP])
)
NH FUSE:
SELECT(
GARDU[NH FUSE],
IN([_THISROW].[GROUP], [GROUP])
)
Thank you so much guys @Steve @GreenFlux itโs works
Is there a way to addโฆif the entries in a restricted dropdown are shown can you have an +?
I donโt understand your question.
I can get the drop down to work, but can if the users wants to add an entry instead of picking one is that possible? The table I am referencing does have adds allowed
Try using Suggested Values instead of Valid If.
What is โGARDUโ?
What does โfollow the choicesโ mean? There are several ways to interpret that.
What does โorder in the NH FUSE column the data that appears matches the spreadsheetโ mean? Again, I can imagine several interpretations.
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |