Selecting fields from a workflow based on fields selected in an interface tool

[jjoerger]

I have a workflow that populates a Multi-Select Interface tool with field names available in the workflow.   I want the user to select which fields they want to see on their output.  How can I do this?  In my example, if the user selects they want to see Red in the output, the second screen shot is what I'd like to see.  I don't know how to tie the two together and from my mainstream workflow (simplified below) select a few required fields like Customer and Region and then only the fields the user wants to see which is Red.  I've got a list of about 40 fields the user can select from to determine want end up on the output.  ABSOLUTE BONUS if someone can tell me how a user can inform the workflow of the order they want the fields in on the output and I could work that into the workflow (which resides on our gallery).

 

[PhilipMannering · Accepted solution]

Hi @jjoerger 

Does this do what you need?

If not, let me know and I'm sure I can amend

[jjoerger]

This works absolutely fabulous!  Thank you.  Has anyone ever mastered allowing a user to specify the order of columns of an output (excel spreadsheet.)?

[PhilipMannering]

Hi @jjoerger 

Glad it works for you!

Not sure. To be honest I never tried before now. Looks like what you can do is select an order manually in the macro, and then connect it to a tool to say if you want to this order (True) or not (False). But you can't give the user complete freedom in choosing the order (as far as I can tell). 

See example attached,