Description

I need guidance on how to create a query on a SharePoint list in Composer.

I want to create a formula that does the following:

• Based on a postal code (a field in the form) I want to extract a Sales Rep # from a SharePoint list with the following four columns:
• PLZ range start
• PLZ range end
• ADMName
• Sales Rep #

Something like =if(postalcode => PLZ range start AND postalcode <= PLZ range end; pick value from column Sales Rep #)

=> means equal to or greater than and <= means equal to or smaller than.

I know what the formula should look like but I don’t know how to ‘write’ this in Composer.

Applies To

11x;12x

Solution/Immediate Workaround

Steps you would need to perform is.

1) Rules
2) Set field value
3) in the formula use Inset External Data 

See below example

You will need to write a get form rule in order to achieve the same; please find the same solution attached created in version 12.1; I have created the Postal Code custom list and then created below rule in order to achieve your requirement.






​

​

Click on Insert External Data for the same.