We’re gathering item requests via a JotForm. I’m sending the submissions into a Coda table via Zapier. The issue is that the user group submitted via the form may not 100% match what’s in our master table. For example, the official name of a group is ABC Street, but the user may just write in ABC (or ABC St or ABC St.).
Is there a way to do this? I used the information here to test pulling in column info from one table to another based upon a common column (i.e. user name). However, it doesn’t work if the full name of the group isn’t matched.