Lookup using multiple conditions - checkbox and list involved

Ask for Help
1

I am looking to create a lookup that works on two separate conditions within the lookup table. I have it working for the 1 but I can’t figure out how to get the syntax right for adding that 2nd lookup. I need to add in a filter that removes the item from the lookup if the checkbox is checked.

I have
LEN(Seed_Packet_Entry_Widget.lookupRecords(Varieties=$id).Seed_Packet_Name)

and need to make sure this field is unchecked. Also in Seed_Packet_Entry_Widget table. $Packet_Dead_empty_gone_whatever_

I am sure it is easy but I am struggling.

2

Hi @Lilly_Jane ,

To confirm, the $Packet_Dead_empty_gone_whatever_ column is a toggle type column, correct?

If you only want to include items in the lookup where this checkbox is not checked, then we can use the condition Packet_Dead_empty_gone_whatever_column==False. False means not checked and True would be for checked values. You can add this into your existing lookup like so;

LEN(Seed_Packet_Entry_Widget.lookupRecords(Varieties=$id, Packet_Dead_empty_gone_whatever_column==False).Seed_Packet_Name)

Let me know if you have any follow up questions!

Thanks,
Natalie