Can anyone point out where my problem is in this espression?
The goal is to use this as a valid if constraint, where the options are Candidates 1-4 but not candidates that have alredy been used in rows with the same useremail() and interview key.
= IN([_THIS],SELECT(LIST([Interview Key].[Candidate 1],[Interview Key].[Candidate 1],[Interview Key].[Candidate 1],[Interview Key].[Candidate 4]),NOT(IN([_THIS],SELECT(Results[Candidate], AND([_THISROW].[Interview Key] = [Interview Key],[Interviewer Email]=useremail()))))))
The error I get is โselect has invalid inputsโ
Update:
This is my new working expression:
= IN([_THIS], (LIST([Interview Key].[Candidate 1],[Interview Key].[Candidate 2],[Interview Key].[Candidate 3],[Interview Key].[Candidate 4],[Interview Key].[Candidate 5] ,[Interview Key].[Candidate 6] ,[Interview Key].[Candidate 7] ,[Interview Key].[Candidate 8] ,[Interview Key].[Candidate 9] ,[Interview Key].[Candidate 10])- SELECT(Results[Candidate], AND([_THISROW].[Interview Key] = [Interview Key],[Interviewer Email]=useremail()))))
@Rosemary_Black You may want to start from this example app: appsheet.com - Distinct value dropdown - Only allow values that havenโt been chosen in dropdown
Youโll need to update the select expression in that example to something like:
SELECT(Request[Equipment], AND([email] <> useremail(), [interview key] <> [_THISROW].[interview key]) Distinct value dropdown - Only allow values that havenโt been chosen in dropdown appsheet.com
@tony Amazing, that you.
I had no idea that subtraction was valid in an expression like this.
User | Count |
---|---|
39 | |
28 | |
24 | |
23 | |
13 |