Level 3 Model Building: Schema Design - Part 2
Hi Team,
Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced Topics
As I am unable to add subset in to the formula.
Best Answers
-
You have to create this subset with exact name in a Subset tab of Employees list.
After this you will be able to mention it in the formula.
Cheers,
Kirill
1 -
Try to simplify name of the subset, for example rename it as "Active" (no brackets) and in formula write: ISNOTBLANK(FINDITEM(Active,Code))
1
Answers
-
I have already tried that way but it is still not working. Is there any other way?
Thanks,
Aniket
1 -
What error do you get?
0 -
I have also got a similar kind of issue as mentioned in the Snipshot below. It is showing as #E2 Employees active is invalid but since beginning we used E2 Employees#. I have tried both the names for E2 but showing an error. Please help.
Regards,
Regards,
Muizz S.
0 -
-
@muizzsk9890Happy to help
@aniket9917How about you?
3 -
1
-
Hey Guys , I've the same issue I do not have the option to select the #Emplouees:Active? How do you fixed ? I've tried this formula ISBLANK(FINDITEM('E2 Employees#', Code)) , but without return
0
