Can forms more than one field of a related table?

[Patrick_Duncan]

Hi all,

I’m exploring using Airtable to look after inventory requests at work. Is it possible to create a form where people request one or more items, as well as the quantity of each of those items?

I could do it if each request was a separate submission of the form but that could get confusing for users. They need to be able to see what they’ve already requested.

Possible? Not possible?

Cheers,

Patrick

[Dean_Toland]

The only thing I can think of to accommodate this is to have the column named for the inventory item, and then the field entry be the quantity (formatted as number) that they’re wanting. Instead of having a dropdown item of the inventory items that you’d have to repeat over and over for multiple requests, you’d have a column dedicated to each item. Below are some examples, what do you think of this?

[Patrick_Duncan]

Thanks for your reply. I think that that is a pretty decent answer! If I was working with about 5-10 items then I’d definitely do this. However with about 100 different things to track this form will get pretty unwieldy.

I’m loving Airtable for other things but I think perhaps this sort of request is a bit out of its zone at the moment.

[Catarina_Pereir]

Hello,

Came across this thread 2 years later. Any updates on this?
I’d really like a form where people can select multiple items (that’s already happening) and quantities per item.

Possible?

Thanks!

[Patrick_Duncan]

Hi Catarina,

To answer your question: no, I haven’t.

I don’t think it’s impossible to do something like mentioned above that might work but I think the issue becomes how do you create a form that will let you input this information in a friendly way. I’ve looked a little into using Zapier to connect AirTable to online form services but haven’t come up with anything decent. It’s something that I will look into again though.

Patrick.

[Patrick_Duncan]

I’m still looking for a way to do this in case anyone has figured this out.

[Patrick_Duncan]

Product Order & Invoice Template Show and tell

Hi Everybody, I’m new to this community and Airtable. So far, I’m loving the product. Just figuring out how to do things in Airtable. I’m not a computer programmer, but I’ve managed to hack together some fairly complex databases using VBA in MS Access over the years. Trying to get our company’s processes automated and cloud based after getting multiple software companies to unsuccessfully bid to make us custom software (unacceptable in both cost and development time). First challenge, I wanted …

This might be an answer…