I am trying to create a public interface, where I will allow people to search for submitted serial no.
Only if you enter the correct serial number in full (without case sensitivity), a list will be shown for all records that matches the S/N you entered.
Is this possible with interface?
Question
How to create a search field, where only if the search term fully match will show result
+6
+31Hm, I think you’ll need to create a Custom Interface element for this I’m afraid (or at least, I couldn’t figure out a way to get this to work!)
Here’s a Custom Interface element that I managed to get Omni to make:
https://airtable.com/app3BPDnDuggucEWb/shrpsmL2sVN7u71v4
And here’s the prompt:
Create a list element with a search bar.
The search bar should query the 'Name' field in Table 1.
Behavior:
- When the search bar is empty, the list should display no records.
- When the user enters text, the list should show only records from Table 1 where the 'Name' field exactly matches the entered value.
- If no records match, the list should remain empty.
The list should update dynamically as the user types.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.