Skip to main content

Hello, I am in a pickle and would like to know how to achieve the following


Context: I am creating a table with contract details as both an internal database and also as a database that external contractors can use to check specific contract details based on the serial number of a hardware in the contract.


Problem faced: I cannot figure out how to allow external contractors to search based on serial number without also allowing them full view of the entire database. I have tried using Interface for it but the vertical format it displays the results in, isn’t ideal as I require the results to be shown in a “table format” (horizontal)


How can I achieve this?


Thank you

Yes, this is possible with Airtable’s interfaces feature! :)

You can filter your interface to ONLY show the users the records that you want them to see, so they will only be searching within their own set of records.

You would configure this by attaching their email address or their user account to the records that you want them to see. This can be done with lookup fields, user fields, or email fields.

Then, you would filter your interface to show the records that are assigned to the currently logged-in user.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Reply


Terms & Conditions