Skip to main content

Form or easy way to edit database proeprties

  • November 19, 2024
  • 3 replies
  • 0 views
S
Forum|alt.badge.img+3

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 

3 replies

DisraeliGears01
Forum|alt.badge.img+17

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
Forum|alt.badge.img+28
DisraeliGears01 wrote:

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.


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

Adam, Consultant @ thetimesaving.company
S
Forum|alt.badge.img+3
  • scottengraving
  • Author
  • New Participant
  • 2 replies
  • November 20, 2024
DisraeliGears01 wrote:

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.


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. 

 

Reply


Most helpful members this week

Terms & Conditions