This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Might be the Friday blues, or I am approaching this all wrong. But, in general, I have a multifield formula tool inside of a macro, I want to set up a List box to select what fields get passed through. I have been at this for some time today now. Hopefully, someone can point me the right direction on setting up this interface!
Below is a simple version just a visual of how I set up the interface to function with the multi-formula tool in the macro (not the actual thing). Am I thinking somewhere in the settings?
If you're looking to simply select which columns you would like to pass through, just use a select tool instead with the same exact config. The trick is to deselect all of your columns in the select tool, otherwise by default they will get passed through even though you only selected specific columns within the analytic app.
- first, please have a look at list.csv output, this gives you the format of how List Box selections look like (comma delimited list in double quotes) - try single and multiple selections to see the difference
- for each field you'll need to get a separate Action tool and target value is the '@selected-value' property for the respective field name
- first, please select 'All Types of' in the Multi-Row Formula tool to expose all field and tick 'Selected or Unknown Fields'option - only when a specific field is un-ticked, its '@selected-value' property becomes visible for Action tool (when ticked this is not visible)
- finally, pretty much all settings/metadata of any tool including Multi-Row Formula are exposed for the Action tool, with this specific tool being quite advanced and very powerful at the same time, i suggest you play with it to understand the way it works, for example you may want to create copies or overwrite the original fields etc.