How to populate a boolean to child list

New Contributor

How to populate a boolean to child list

Hello,

 

I'm working with 2 list with ("Product Family" and "Products"), and "Product Family" is parent of "Products".

 

In my list "Product Family", I have a Boolean "Forecasted Family" used to know if the family need a forecast. I want to have the same boolean in my "Products" list, based on the value defined in the "Product Family".

 

How can I link both list to have an automatic population of the boolean value from the parent list to the child list ?

 

In advance, thanks for your help,

 

Regards,

Cédric

Message 1 of 3
2 REPLIES 2
Highlighted
Community Boss

Re: How to populate a boolean to child list

 

The formula might end up looking something like:  Product Family.Forecasted Family[Lookup: Parent_Item]

 

Where Parent_Item is a separate list property or module line item formatted to the Product Family list and contains a formula something like:  Parent(Item(Products))

 

Cheers!

Message 2 of 3
Expert

Re: How to populate a boolean to child list

Can I also add the recommendation to add a Product Properties module in case you need to do similar lookups or need to  refer to items or parents elsewhere in the model.


Here's an example:
product properties.png


You can then refer to this in another module in a boolean dimensioned by Products with:
Product Family.Forecasted Family[LOOKUP: Product Properties.Product Family]

Message 3 of 3