Macro, chose report, nested interface filters

Gina2021

Hi Community!

I need some help with macro magic... This seems like a super fun thing to know, but after spinning my wheels, I'm conceding that it's above my newbie experience level.

Have you seen the super cool "Action" tool example? Running with the wand allows you to chose your report, and reveals the filter choices. I'd love to replicate this with my three report choices. The differences are that my interface connects to filter tools, and there are several interface tools per report (or options to filter on).

Here's what I have so far:

The first filter on each worked before I created sample text box data...not sure what's going on rn.

Thanks so much for any hints!

Gina

PO-outerShell-HELP1.yxwz

POmacro-HELP1.yxmc

Macros

Interface Tools

Accepted answers

All comments

apathetichell

your "replace specific string"' in the action tool isn't checked...😱

apathetichell

2021-05-11 (2).png

Assign a value in the dropdown for the name:value pair. Also (select from dropdown) should be added in interface designer as part of the tool layout - right now it's an option in the name:value set...

apathetichell

Also - your interface tools are inside of the tool containers - Alteryx won't let you use interface tools in disabled tool containers. Macros yes - tool containers no. So you basically have two choices:

1) put all the interface tools in your main workflow and bring them in with the control parameter (the "normal" option).

2) instead of using tool containers - have each choice call a macro.

One more thing - the control parameter is all about treatment of different values differently so i don't know if you need to have your action tool as presently constructed. The control parameter is kind of already a filter.

Gina2021

@apathetichell Thanks so much for your replies! I made your first response change, but have no idea what the second reply means. Would you mind uploading? Thanks!!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167