Incorporating selected Numeric Up Down value into header

Question

Hello

I have built a macro to allow a percentage of a specific data column to be calculated using the Numeric Up Down Tool

Works fine but what I want to do is reflect the number that is input within the new data column

eg. if 85% is selected then I want the new column to say 'Adjusted Spend in CAFY at 85%'

How can I make the header dynamic?

TIA!

danilang · Answer

Hi @RLUoN

In order to get the downstream tools to use the new header, you'd have to use an action tool to update every single instance of the field in all the downstream tools.  Somewhat impractical😂

An easier solution is to build your workflow using a default field name and only rename it immediately before output.

Here the second formula tool is a placeholder for all the downstream tools.  The Output column name Text Input contains the active field name used throughout the workflow and the new field name.  The Numeric Up Down control updates this new field name and the Dynamic Rename changes its name immediately before output

Dan

DynamicHeader.yxwz

RLUoN · Answer

Thanks @FrederikE

Have got it to work..... the only problem is that the workflow after the gets messed up when you change the numeric up down as the field name changes :(

Should have realised that would be any issue!

Any idea how to make downstream calculations that use this column dynamic also?

ed_hayter · Answer

I think this can be done by dragging the numeric up down to the same formula tool to create a second update value - within the update action configuration you can point the update at the field name this time rather than the expression:

Then if your title has the % to update with the new value in the numeric updown you can replace the specific part of the title string at the bottom with the check box: say you had it default at 85% and the drop down was set to 75 I think this is the setup