I'm just really checking that what I'm trying to do is impossible. Because I think I've tried every option 😤
So what I want is:
You'd have thought this was easy...
What I've found is that the above only works if I make either of these changes:
Every other post on this forum says to just do it as TEXT with a VALID_IF to create the list. Which works. But you seemingly can't have a valid_if create both an list and check for something. Likewise the "Allow other values option" for an ENUM. It seems unticking this does nothing, checkout below:
Am I missing something....?
Solved! Go to Solution.
I've managed to sort it as follows. So in this example we are pulling 10 items from another table, without being able to use references. The user is then allowed to choose 5 from those 10 but they are not allowed to choose any item twice. Here's what I used in the VALID_IF
SORT(UNIQUE(
LIST(
ANY(Select(CareerSifting[Career1],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career2],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career3],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career4],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career5],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer1],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer2],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer3],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer4],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer5],[CareerSiftingUser]=UserEmail()))
)
))
-
LIST([Career2],[Career3],[Career4],[Career5])
Notes for any appsheet beginers 😀
Hope this helps someone else.
Use Enum column with the base of Ref and set the source table (for the dropdown) as Read_Only. Then set both options "Allow other values" and "Auto-complete other values" as OFF. Read the data from the table then with the "Suggested values" and it should work.
Not sure I could use an ENMU/Ref column as dropdown pulls data from numerous columns on another table. So just seeing the label column wont work.
But created a ReadOnly slice, changed EMUM from TEXT to Ref and linked to ReadOnly slice. And IT WORKS!!!! Though I do now have a yellow triangle on every option. How can I get rid of that?
You have the ref broken as you have earlier saved another value than the key.
Not sure exactly what you mean, but these two table are not parent/daughter. So aren't really linked in any way. The only way I get data from them they all have a column where USEREMAIL() is the inital value
You don't need to have parent/child relationship at all and when using Enum bease of Ref, it doesn't create any relationship either. The base type of Ref only means it will show the label value with your dropdown. And of course dereferencing works as well.
Btw.. when using Enum base type of Ref, the label will be shown in the same way than when using a Ref column.
Not sure this is gonna work... Now I can't save and even if I could would it be saving the Key column of the referrenced table?
With the Enum base of Ref, yes it saves the key value.
I've managed to sort it as follows. So in this example we are pulling 10 items from another table, without being able to use references. The user is then allowed to choose 5 from those 10 but they are not allowed to choose any item twice. Here's what I used in the VALID_IF
SORT(UNIQUE(
LIST(
ANY(Select(CareerSifting[Career1],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career2],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career3],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career4],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[Career5],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer1],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer2],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer3],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer4],[CareerSiftingUser]=UserEmail())),
ANY(Select(CareerSifting[NewCareer5],[CareerSiftingUser]=UserEmail()))
)
))
-
LIST([Career2],[Career3],[Career4],[Career5])
Notes for any appsheet beginers 😀
Hope this helps someone else.
thankyou
thankyou topic
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |