I have a table Contracts which contains a Choice Lst column Bamboo_Project_Task_IDs
In another table, I want to lookup the matching Contract record via Bamboo_Project_Task_IDs by using
=Contracts.lookupOne(Bamboo_Project_Task_IDs=$Project_Task_ID)
Contract’s Bamboo Project Task IDs can contain multiple values. The other table is only ever 1. I essentially want Project_Task_ID in Bamboo_Project_Task_IDs but that doesn’t work.
I have tried CONTAINS() but I can’t get it to work.
Any advice would be great. I’m also open to odd work arounds such adding a new column in Contracts for every Bamboo_Project_Task_ID because it would only be a few, then doing a lookup one across each of those columns and choosing whichever matches.
bamboo_id_one = Contracts.lookupOne(Bamboo_Project_Task_ID1=$Project_Task_ID) bamboo_id_two = Contracts.lookupOne(Bamboo_Project_Task_ID2=$Project_Task_ID) if bamboo_id_one: return bamboo_id_one elif bamboo_id_two: return bamboo_id_two else: return Contracts.lookupOne(Bamboo_Project_Task_ID3=$Project_Task_ID)