BatchMacro ?

Evaldas1

Hi,

Bit stuck with batch Macro.  Not sure if I picked the right tool to achieve it.

The problem: I want to apply a formula to a text fields. For simplicity lets say UPPERCASE() 

Table1 (List of String Fields) :                  Table2:

Fieldname                                                  Name  Street   Phone   Date 

Name                                                           Jack     Case    5556       04/23/1986 

Street

Can I set up a batch macro that would take Field names from Table1 and Uppercase(Override values to uppercase) for those on the list?

I tried, it seems that Batch Macro can apply different operations within a single field, but cant get to apply same operation to a multiple fields?

I know about Multi-Formula tool, that would solve this. In this case I need to avoid it as a solution. There is a separate macro that I would like to deploy against multiple fields. The "UpperCase" function in this example is for simplification of example. 

Any thoughts? Thank you in advance.

fmvizcaino

Hi @Evaldas1 ,

All of this would be inside your macro, you would do the transformation but to return it back to its regular format. 

If this doesn't work, please tell me a little more about the complexity of your process, then I wll try to build something for you.

Best,

Fernando Vizcaino

2021-04-06 BatchMacro.yxmd