How to loop through an array in a VBS Business Rule to retrieve matching values?

1:55PM

Hi,

I have a requirement on the Offer page where the Grade Code is ABC. I need to create a VBS Business Rule to automatically derive the Minimum Rate and Maximum Rate based on the selected Grade Rate Name.

We have created 3 DFFs on the page:

Grade Rate Name – Dropdown
Minimum Rate – Automatically populated
Maximum Rate – Automatically populated

The source data is available in an array/table with the following structure:

For example, when the user selects Grade Rate Name = ABC_9, the VBS Business Rule should identify the matching array element and populate:

Minimum Rate = 108
Maximum Rate = 308

My question is:

How to loop through an array in a VBS Business Rule to retrieve matching values?

Howdy, Stranger!