Fuzzy Matching with Variable Input Field

jconstantine3rd — Wed, 08 May 2024 14:39:45 GMT

I have an application that is essentially a flat table. The columns are name, user_id, company, city, state. I want users to be able to input a list of names in the variable input and then fuzzy match those names with the names in my data set. I believe there isnt an actual tool but would love a creative way someone solved this problem

Re: Fuzzy Matching with Variable Input Field

mpc — Thu, 09 May 2024 10:07:57 GMT

Hi,

Fuzzy search sorts the data, so perform a selection with it'll select all the data.
If you want to do it with, as an alternative, joker char *, you can:

Create a variable
Create an input box, set the variable
Ask your user to enter value, separated by comma
Create a action button, with action "Select values matchin search string"
Use an expression like this: =$(=chr(39))$(=Replace('(*$(vFuzzyNameSearch)*)',',','*|*'))$(=chr(39))

Updating Media

Kind regards

topic Fuzzy Matching with Variable Input Field in App Development

Fuzzy Matching with Variable Input Field

Re: Fuzzy Matching with Variable Input Field