Here’s an example to see how this extension works.
You can also display the records in a gallery.
Both of these live demos above are using this Airtable View
With this extension, you can share a web page that allows people to search your Airtable base. You can decide which fields can be searched and which fields are shown in search results. It generates a unique search page URL for you that you can share with those you’d like to give access to.
💡This extension is ideal for allowing clients to lookup data in Airtable without having to create an Airtable view for each client.
Optional Features
- The extension can be embedded inside your own website (with automatic height adjustment).
- The search page can contain multiple fields.
- You can allow users to edit records via the built-in form.
- You can allow users to download records as CSV.
- Supports direct in-line editing for all field types in the grid view.
- Optionally you can allow users to add new records.
- Supports looking up records by scanning Barcodes/QR codes.
(so you can scan a barcode and see an Airtable record as a result)
Can the results page be accessed without typing in search? I want to give my customer a link that redirect to their record without needing to look it up manually.
Yes, there’s an option to add a formula that generates a unique URL for every record in your table. Allowing users to skip the search page and go directly to their personal view.
I have 3 fields X, Y and Z. Currently it is compulsory for all 3 fields. What I want is even though I have given 3 fields for searching, some times I want to search with only 1 or 2 fields out of 3. How can I do this?
Our extension supports looking up multiple fields separately. It does not require all fields to match. In the settings you can change the ‘search type’.
Can you search with a barcode on the search page?
Yes, you can. There’s an option in the advanced section to ‘Enable Barcode & QR Code Scanner’.
Is there a way to edit the “lookup field” information in the linked table?
It’s not possible to edit lookup fields directly (just like in Airtable), but you can edit linked records by activating this option in the form settings (screenshot attached).
We are finding that the search engine is too precise for normal use by someone who is not familiar with the entries in the Base. Is it possible to make the extension show results that are not as precise? For example, for the record with Name “xyz shop” entering “xyz shop” shows the record perfectly, but entering “xyz” shows “No records found”.
To resolve this issue, you need to change the search type in the extension to settings. You have to set it as ‘partial match’ instead of ‘exact match’ (screenshot attached).
Some records are not showing up in the search results, why?
One possible reason is that they are filtered out because the view settings.
I want all records to be searchable, how?
Just remove the viewID from the extension settings. It’s optional. You do not need to provide it.
I want to hide some records from being searched, how?
Add a viewID with your preferred filter settings. Any record that’s not included in the view, won’t show up in the results.
Can I make the search page password protected?
Yes, in Airtable you can add a formula field for password and use it as a 2nd lookup field. That way any user would have to enter that password correctly or otherwise the search won’t work.