How does the Softr search bar pass the search input to Airtable?

Ask the community
1

We are trying to create a search-friendly formula in Airtable that:

  1. Checks if the search input matches the first name, last name, or full name (not case-insensitive).
  2. Only shows exact matches (not partial matches).
  3. Works with a Softr search bar that filters records based on this formula.

The formula will return "Show" if there’s a match and "Hide" otherwise.

Heres my current formula, but cant seem to get {SearchInput} to work because its not what softr returns as. In my airtable they are 2 different fields but being searched as one in the search bar. What should this supposed to be? Heres my formula example, Thank you!

Formula:

IF(
LOWER(TRIM({First Name} & " " & {Last Name})) = LOWER(TRIM({SearchInput})),
“Show”,
“Hide”
)

2

@Sauce the search is pretty mich does a contains on a field value… and it’s case insensitive