Form or easy way to edit database proeprties

[scottengraving]

Hi, new to airtable. I have several databases related to various types of inventories. I just want a simple interface to be able to select, for instance, a product. Then have the database properites for that product presented so I can edit them. For instance, adjust quanties. 

From the little bit of googling I have done it doesn't seem possible with airtable's built in tools. 3rd party tool implentations seems like a house of cards. I have tried this in Notion and it quickly becomes too complicated to be reliable. 

Are there any other ideas out there? Thanks 

[DisraeliGears01]

Hmm, if you're looking for an interface, perhaps try Interfaces? 😋

Haha, this is exactly what the interfaces tab is for, you can granularly set what fields are displayed and which are editable in an interface. If a spreadsheet style view is still good, the list interface gives you a bit more UX control than the standard table does, otherwise record review is one I use quite often. If you really want to build your own, starting from blank gives you an interesting balance of freedom with how data is displayed.

[TheTimeSavingCo]

If they're external users you could try Fillout.com (https://www.fillout.com/).  They're a form service that integrates directly with Airtable and lets you edit records

[scottengraving]

I've played around with Interface a bit. I still can't get it to work the way I want. One base I have is raw material inventory. The MaterialName is the key but it is a text field. So a text field it seems like you can't have a drop-down or select menu.

I want a form in which I can select an entry from the MaterialName column, or have it populate when I start typing. Then the form will bring up relevant data for that material that I can then edit. 

I don't want to have to sift through the whole database to find one entry.