Multi Row Formula - Update via Macro

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

Macros

Accepted answers

JoeS

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.

MultirowGroupBy.zip

All comments

JoeS

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.

MultirowGroupBy.zip

asifk

Hi @Jo

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

Kind regards,

Asif

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335