RELATED IDEAS
Expression Engine - lookup in CVL
Please, fill in the below fields to enable the processing of your idea.
Who would benefit? |
Expression with MANY criteria (alternative to IFS) |
What impact would it make? |
|
Check if value is present in (supporting) CVL, something like: =CVLLOOKUP(value, cvlId) |
|
Why is it needed? |
Flexible and easy management of criteria, easy expression |
In case a user has a expression based on many criteria, at this moment only the IFS expression is an option. Which becomes very difficult to write, and in case of editing is difficult too.
I suggest adding a CVLLOOKUP expression, which basically just checks if a value is present as KEY in a CVL. This can then be returns as True/False.
proposed: =CVLLOOKUP(value, cvlId)
Use cases:
determine Risk country Y/N : Create a (support) CVL with all Risk Countries defined for your organisation (CVLRiskCountries). Based on the chosen value in Country Of Origin (ItemCountryOrigin), the boolean field "ItemRiskCountry" can contain the following expression:
CVLLOOKUP(FIELDVALUE("ItemCountryOrigin"), "CVLRiskCountries")
if the country of Origin is in the list of Risk Countries, it will show True, otherwise Falsedetermine EUDR compliance: Create a (support) CVL with HS Codes (CVLEUDRHSCodes) covered in the Scope of EUDR, based on the HS code of Item (ItemHSCode), determine if EUDR compliance is necessary:
CVLLOOKUP(FIELDVALUE("ItemHSCode"), "CVLEUDRHSCodes")
Any changes in criteria is simply made by editing the said CVL.
