Skip to main content
Solved

Use Form To View Table Data

A
Forum|alt.badge.img+6

Is there a way that I can have my employees fill out a form that then shows data they are looking for from a base instead that form inputting data into the base? I have created a table that would be very beneficial to my employees but some are reluctant to use it because they are used to an older system. If I could create a form that makes it very easy to find what they need, that would be wonderful. I see there are some paid 3rd party apps like On2Air that would do this. I assume by the presence of these apps, Airtable does not have this functionality but figured I'd ask when my searches on the community yielded no results. 

 

Thank you for all your time 

Best answer by Arthur_Tutt

Hey @Anthony_Manniel , firstly love the seinfeld photo. 

I believe the solution you're looking for is an Interface, not a form. Like you said forms are purely for inputting new data. But if you'd like an employee facing system where they can lookup data, an Interface should do the trick for you. 

Here's a video by GAP Consulting (https://www.youtube.com/watch?v=dBQKKytXbgk)  where he lay's step by step building an interface. Jump to timestamp 13:30 to see the end result. Essentially there's a page you can send employees, and they can search for specific data (in this example, it's searching for the available projects, but could make more complex to suit your needs). 

View original

3 replies

Arthur_Tutt
Forum|alt.badge.img+15
  • Arthur_Tutt
  • Inspiring
  • 118 replies
  • Answer
  • November 2, 2023

Hey @Anthony_Manniel , firstly love the seinfeld photo. 

I believe the solution you're looking for is an Interface, not a form. Like you said forms are purely for inputting new data. But if you'd like an employee facing system where they can lookup data, an Interface should do the trick for you. 

Here's a video by GAP Consulting (https://www.youtube.com/watch?v=dBQKKytXbgk)  where he lay's step by step building an interface. Jump to timestamp 13:30 to see the end result. Essentially there's a page you can send employees, and they can search for specific data (in this example, it's searching for the available projects, but could make more complex to suit your needs). 

A
Forum|alt.badge.img+6
  • Anthony_Manniel
  • Author
  • Known Participant
  • 13 replies
  • November 2, 2023

Thank you Arthur. I just watched a few videos from GAP Consulting and created a nice interface. Unfortunately, Interfaces can't be shared by a simple link. Users need to have an account in order to view them. I added my request to another forum post that had many others requesting the same functionality. My users would use these Airtable bases a lot more if they could simply click a few buttons from the Interface and bring up the data they are looking for. It makes it accessible for users who have varying degrees of computer skills. 

H
Forum|alt.badge.img+13
  • HannesK-ME
  • Participating Frequently
  • 112 replies
  • January 7, 2025

Hey there, it does sound like your use case would benefit from a third party tool. Our miniExtensions form for example, can be used to access existing records with ease. It features lookup/login functionality, which allows your users to find the records they're looking for quickly and efficiently. If your users would want to search for multiple records at the same time, a portal or shared view might be a better fit! 

Reply


Most helpful members this week

Terms & Conditions