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.
I have a workflow that I have to run for every organization code listed on an Excel file (will be my input for the macro).
I've completed the workflow for one specific org, so I'm trying to use Macro to update the filter in the beginning of the workflow. It looks like this right now:
My questions is, how do I configure the Macro input properly, so I can use a Excel file as input and run the entire workflow for each of the codes listed (I'm using 3 as a test at the moment).
Perhaps there's better way to set up the beginning of the workflow... Any directions would be greatly appreciated!
Hi @Yijen ,
If you create a batch macro, then you don't need the filter tool as the batching process will essentially be the filter for you. Attached is an example of a batch macro without the Control Parameter -
Without Batch Macro vs Batch Macro
Insider the blue Batch Macro (no filter needed) -
Your Group By column = INPUT_ORG_CODE
Hi @Yijen !
Please check this post:
We recently walked through this exact question.If you need anything else, please feel free to reach out!You're very close!
I modified my workflow based on the post you just shared, but the OrgCode on the filter dint seem to be replaced by the Action Tool.
Here's how I config my Action Tool:
I also tried to put only OrgCode in the box of Replace a specific string, but still, the OrgCode didn't get picked up by the filter.
You'd what to leave the box checked and replace "OrgCode" with the quotes.
But reading what you are doing, it looks like you're trying to get a question as an input?
Is that correct?