Invoke a business rule for an array?
Summary
Invoke a business rule for an array?Content
Hi,
PBCS
in the same way that you can invoke a business rule from a form and have a business rule that launches on save which uses the values in the form, is it possible to do the same from an ad-hoc grid in Smart View, but responding to an array of values?
i.e.
Business Rule
Fix ({CostCentreArray},{EntityArray})
Excel;
CostCentreArray = A5:A(last populated value in spreadsheet)
Entity= B5:B(last populated value in spreadsheet)
The only way I can think of is to invoke this in a loop via Visual Basic in excel, calling the script for each row, but is massively sub-optimal, so I wonder if there was anyway better?
0