Hi, I am wondering if it is possible to do a fuzzy search in Glide, I have a drawing register with the names of each drawing in a project and I also have a uploaded drawing table. Once uploaded, each drawing will be assigned to an item on the the register. In order to speed up the linking process, I would like to search the drawing register list based on the file name of the uploaded PDF. The closest match is then suggested as the one to be linked and the user either verifies it is or picks another one.
Often the file name won’t be an exact match to the register item, hence the fuzzy search.
My thinking is you can add a user-specific column and point the text entry there, then decide to either use a JavaScript approach to match that search term against your file names to return a percentage match, or maybe turn both the file name and the search term into a bunch of keywords using AI, and then try to match the arrays together. Whatever matches the most keywords win.
Sorry, it was just a thought, I have no ready-made snippet. You can try searching Stackoverflow or use ChatGPT to craft a snippet with a prompt like “calculate percentage of match between 2 strings/sentences”.