Hi all,
I have a requirement as:
I have 2 pickerfieldusers as A and B where A can select max 1 user and B can select max 5 user, requirement is when we select user in A then B cannot select that user which is already selected in A and should throw validation error as "A user cannot be selected in B".
I tried putting validation as :
validations: { if( contains( local!taskAdditionalAssignee, ri!record['recordType!{a6f5f29e-a89e-495a-afae-702df167aa19}RECT Record Tasks Sync.fields.{d0fec037-4f71-4d05-a7ef-766635d0ff13}taskAssignedTo'] ), "Assignee cannot be added as additional assignee", null ),
}
but when I open this form then as A and B both contains null value so same validation error throws comparing both A and b having null value which becomes similar
please help me how to achieve this
Discussion posts and replies are publicly visible
Hi appian.user
Can you try this logic it may help you
{ a!pickerFieldUsers( label: "A", labelPosition: "ABOVE", maxSelections: 1, value: ri!inputA, saveInto: ri!inputA, validations: {} ), a!pickerFieldUsers( label: "B", labelPosition: "ABOVE", maxSelections: 4, value: ri!inputB, saveInto: ri!inputB, validations: { if( and( a!isNotNullOrEmpty(ri!inputA), a!isNotNullOrEmpty(ri!inputB), contains(ri!inputB, ri!inputA), ), "Can not select the A user ", {} ) } ) }
thankyou for your responce but still it is not fullfilling the requirement and i have 1 more question -
If I have to choose max 5 user from pickerfielduser then at backened level what should be data type for that particular field as in my case data type is text and I m using recordtype to store data
for reference: this field should hold atleast 5 user after submiting