Level 3 Model Building: Schema Design - Part 2

aniket9917

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.

@jared @Misbah 

KirillKuznetsov

@aniket9917 

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

KirillKuznetsov

@aniket9917 

@muizzsk9890 

Try to simplify name of the subset, for example rename it as "Active" (no brackets) and in formula write: ISNOTBLANK(FINDITEM(Active,Code))

aniket9917

@KirillKuznetsov 

 

I have already tried that way but it is still not working. Is there any other way?

 

Thanks,

Aniket

KirillKuznetsov

@aniket9917 

What error do you get?

muizzsk9890

@KirillKuznetsov @aniket9917 

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,

muizzsk9890

@KirillKuznetsov 

Yes, it worked. Thanks a lot for your assistance.

Regards,

KirillKuznetsov

@muizzsk9890Happy to help

@aniket9917How about you?

aniket9917

@KirillKuznetsov 

 

I tried naming convention that you have mentioned & it worked.

Thank you so much.

eramos

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