Apply Formula logic to fields selected by the user

[Deano478]

Hey everyone,

I'm just starting to get into apps and I have a question Essentially everything works okay so far the user can choose an input file and select the field(s) they want to carry forward however I have my formula as you can see in the container on it's own I'm just wondering how can I feed those chosen fields in her to apply the logic in the formula?

Below is how I have my WF set up I'm just not sure how to pass the chosen fields into the formula to do what I need it to do?

Here is the formula logic i'm trying to apply to the chosen fields: 

REGEX_CountMatches([_CurrentField_], '(^[\s]+|[\s]+$)|[^A-Za-z0-9]')

[ChrisTX]

What should the output look like?  One row for each Field selected by the user?  You may need a batch macro.

Can you post your actual app?   Options > Export Workflow, post the YXZP file here.

Chris

[Deano478 · Accepted solution]

I Got it sorted it just took a bit of intuition and a dynamic select tool to get the fields selected into the formula