Multi Row Formula - Update via Macro

[asifk]

Hi Everyone,

please can you assist me, I wish to select certain fields  in a multi-row formula under "group by" through a macro, 

Reason being i have multiple multi row formulas and wish to use a macro to select these key fields once and apply to all Multi row Formulas with the macro.

Below is a snapshot of my interface for macro

and my actual macro is below

Once i am able to update the fields from the first formula, i will then need to apply this to all. 

This is a real challenge, my current configuration in my action tool is per below:

Thanks and Merry Xmas

[JoeS · Accepted solution]

Hi @asifk 

If you change the way that the list box generates it's answer to being the XML of the tool that will be the easist.

So having:

Start Text - <Field field="
Separator - " /><Field field="
End Text - " />

 

You can then update the XML of the tool in the action:

Sample attached as well.

[asifk]

Hi @Jo 

Thank you for your valuable advice, it is certainly well appreciated.

Kind regards,

Asif

[JoeS]

No problem at all, happy to help!