Confiform Rules for definition Apply filter on Multi select field

[Joseph]

Good Morning, 

I am trying to apply several confiform rules for definition field on a Multi select field (Funding) that has 4 options listed below, what I want it to do is when a user types in a numeric value in the separate Funding 1 (Numeric) field then the multiselect will filter the selectable options base on the rules I have defined with the ranges listed below. When I apply more then 2 rules any rule after the first two the multiselect shows no value. I am not sure what I am doing wrong.

@Alex Medved _ConfiForms_ 

<250000  value to apply .23

251000-500000 value to apply .54

501000 - 1000000 value to apply .70

>1000000value to apply 1.00

I have also attached what the rules look like in the source editor below

<br/>
</p>
<p>
<ac:structured-macro ac:macro-id="180bdd74-d40a-4057-800b-1751c0865616" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Funding1:&lt;1</ac:parameter>
<ac:parameter ac:name="fieldName">Funding</ac:parameter>
<ac:parameter ac:name="values">*</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="onUserActionOnly">true</ac:parameter>
<ac:parameter ac:name="actionFieldName">Funding1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="a0e33665-1571-4159-a7b6-c3631dcd0ea4" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Funding1:&lt;=250000</ac:parameter>
<ac:parameter ac:name="fieldName">Funding</ac:parameter>
<ac:parameter ac:name="values">Funding:0.23</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="onUserActionOnly">true</ac:parameter>
<ac:parameter ac:name="actionFieldName">Funding1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="6f474487-f919-48c0-ae8e-2c16891b5577" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Funding1:&gt;=251000</ac:parameter>
<ac:parameter ac:name="fieldName">Funding</ac:parameter>
<ac:parameter ac:name="values">Funding:0.54</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="onUserActionOnly">true</ac:parameter>
<ac:parameter ac:name="actionFieldName">Funding1</ac:parameter>
</ac:structured-macro> </p>
<p>
<ac:structured-macro ac:macro-id="559d0ad8-3889-4ac5-bbf4-1adf80269c22" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Funding1:&lt;=500000</ac:parameter>
<ac:parameter ac:name="fieldName">Funding</ac:parameter>
<ac:parameter ac:name="values">Funding:0.54</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="onUserActionOnly">true</ac:parameter>
<ac:parameter ac:name="actionFieldName">Funding1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="47c19632-db39-45a2-b4f0-bef2da3bb626" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Funding1:&gt;=501000</ac:parameter>
<ac:parameter ac:name="fieldName">Funding</ac:parameter>
<ac:parameter ac:name="values">Funding:0.70</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="onUserActionOnly">true</ac:parameter>
<ac:parameter ac:name="actionFieldName">Funding1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="26205988-fbf4-491d-9068-f9df73272248" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Funding1:&lt;=1000000</ac:parameter>
<ac:parameter ac:name="fieldName">Funding</ac:parameter>
<ac:parameter ac:name="values">Funding:0.70</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="onUserActionOnly">true</ac:parameter>
<ac:parameter ac:name="actionFieldName">Funding1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="11ee1c0e-019a-4fce-9ccf-872b022d0264" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">Funding1:&gt;1000000</ac:parameter>
<ac:parameter ac:name="fieldName">Funding</ac:parameter>
<ac:parameter ac:name="values">Funding:0.70</ac:parameter>
<ac:parameter ac:name="action">Apply Filter on a field</ac:parameter>
<ac:parameter ac:name="onUserActionOnly">true</ac:parameter>
<ac:parameter ac:name="actionFieldName">Funding1</ac:parameter>
</ac:structured-macro>
</p>
<p>
<br/>

[Alex Medved _ConfiForms_ · Accepted solution]

Why are not you having the conditions like you have in requirements?

Funding1:>=251000 AND Funding1:<500000

To apply "Funding:0.54", for example... but have separate conditions?

Alex 

[Joseph]

So I tried that initially and it hated me lol and didn't work so I thought, but thinking back I may have had a typo. I will try again real quick and report back. My apologies

[Joseph]

Confirmed it works like a charm, My apologies I screwed up. thank you so much for your help it is greatly appreciated.

[Alex Medved _ConfiForms_]

No problem! Glad to help