Hi All, I could use a little insight into what's wrong with my formula.It's scripted in my API, using Airtable.js with Next.js.The following works with only the second two fields, which are multi-select, but ignores (or seems to ignore) the text inpu...
FWIW, anyone who's having this issue, my solution, (thanks to @Ben_Young1 for halping to debug it) was this: const records = await table
.select({
filterByFormula: `AND(
FIND("${req.query.module}", {module}),
FIND("$...
Thanks for the test method, @Ben_Young1 Yes, so this turned up a successful search in the Airtable, so the problem is with my code, evidently.I appreciate the leg up, here.
Thanks @Ben_Young1 for posting your test.Here's my search component:import {
table,
getMinifiedRecords,
findRecordByFilter,
filterByFormula,
} from "./utils/Airtable";
import { LessonsContext } from "../../contexts/LessonsContext";
const sea...
Thanks @Ben_Young1 , that's a start, as I wasn't aware that LOWER needed to effect the column Title also, but alas, this is returning an empty array, as it was before.I tried various iterations, but no dice. I tried again, to put OR as the operator, ...
