Apps: Update In-DB Filter from Text Input using IN Clause

[abell_dt]

I have an app where a user might enter in multiple values with commas as the delimiter (ex: a,b,c). I want the a,b,c to update a in-db filter that looks like 

this:

fieldName in ("placeholder") 

I would like to update the placeholder with the 3 values. Without having the user enter the a,b,c with quotes around each in the text input, is there a way to make sure this filter works? I was thinking maybe update value with formula?

[rkapoor]

@abell_dt I tried this on my end with some test data and it should work via the Update Value with Formula method with maybe something like:

'"fieldName"'+" in "+ '(' + '"'+(Replace([#1], ',', '",'))+'"' + ')'

[dennich]

Hi @rkapoor can you provide a working example please?  I am trying to do the same thing with no luck!

[atcodedog05]

Hi @dennich 

It would be something like this.

Hope this helps : )