Reading in multiple inputs to update custom formula

[jwmiller15]

Hey, 

I am trying to update a filter tool based on user input and am trying to figure out the best way to go about it. My filter formula is as below:

I would like for the user to type in any amount of 6 options which would then update this formula so it can filter out what the user did not want. So far all I have is 6 action tools that update the specific string of the numbers in the above formula. I could see how you could do it if you also had 6 individual text boxes used to update each one but I would prefer something more efficient. Any help would be much appreciated. 

Thanks!

[fmvizcaino]

Hi @jwmiller15 ,

Attached in a macro that does the job with a list box interface tool.

If this solves your issue please mark the answer as correct, if not let me know!

Hope this helps,

Fernando Vizcaino

[jwmiller15]

Hey @fmvizcaino,

I appreciate the help. I do not know if that helps too much what I have is a big table of data with one of the columns being "Month" this gets fed into the filter tool where I would like for the user to specify which data is brought through based off that column. I am running this as an app. 

Using the macro that you provided, I would need it to read in my table correct?

Thank you again for looking into this.

[fmvizcaino]

Hi @jwmiller15 ,

I developed as a macro, but for your analytical app you only need to get the part where I created the filter interface as image below.

The list box will have a list of every month available in your database

The update value will do the job of creating the parameter of your filter. In my example '[Field1] in ("1")', the ("1") is replaced by the selection of the user in the list box.

You can save my example as an analytical app to see it working as well.

Thanks,

Fernando V.

[jwmiller15]

Sorry for the confusion. The field I'm filtering by isn't strictly just months, it's more like May Bread or Mar Milk so I was wanting to do a filter to pull the ones that contain the month or months they want. 

I tried this above and it seems to not pull anything through. I have it replacing the "x" value and was wondering if multiple selections would work.

Thanks

[fmvizcaino · Accepted solution]

Hi @jwmiller15 ,

One thing that you can do is to get your months from your data first by using a Find/Replace tool as below. The idea is to append the months in order to filter everything that you want.

Hope this helps you.

[jwmiller15]

Thanks!