Skip to main content

Multiple Quantities in the same Field


This is a tough one to explain so I am going to do my best. If you need more information on what I am trying to do, just ask.


So, I have two tables. One is titled “W/O’s Closed” and the second table is titled “SHS Products.” The meaning of SHS is irrelevant, so I will not go into detail on what it stands for. Anyways, in the “W/O’s Closed” table, there is a field titled “Items Sold:” in which I have linked to the “SHS Products” table. However, what I am trying to do, is when a customer purchases a product in multiple quantities, I can not link the same record from “SHS Products” in the “Items Sold:” field on the “W/O’s Closed” table to indicated the customer purchased two of the same products. I’ll try to attach pictures of what I am wanting to do, so that you can get a better idea. Thanks for any help in advance.

5 replies

  • Author
  • Participating Frequently
  • 9 replies
  • December 15, 2017


  • Inspiring
  • 1386 replies
  • December 16, 2017
Tyler_Nelson wrote:


As best I know, you cannot link multiple times to a single record. (I’m not exactly sure why, as a linked record field is at heart an array of record IDs, and other Airtable arrays can have multiple items with identical values. It would be interesting to know if this was a limitation in the UI or if it is enforced in the core, as the API documentation does not explicitly state each entry in a linked record field must be unique.)


The expectation is one would use a quantity multiplier to indicate how many of the item was purchased. And, yes, in that case you would not typically be able to get by with only two tables; instead, you would use a junction table between your ‘W/Os Closed’ and ‘SHS Products’ tables. On one hand, using such a table increases slightly the amount of keystrokes/clicks to add an item to the order; on the other, it makes such things as quantity discounts and changing prices without invalidating historical data much easier…


  • Inspiring
  • 1386 replies
  • December 17, 2017
Tyler_Nelson wrote:


Along the same lines, I modified the Product Catalog & Orders base from Airtable templates to make use of pricing schedules. (The templated base already made use of a junction table to link orders and products with a quantity modifier.) You can find my announcement in the Show and Tell forum.


  • New Participant
  • 1 reply
  • November 14, 2018
W_Vann_Hall wrote:

As best I know, you cannot link multiple times to a single record. (I’m not exactly sure why, as a linked record field is at heart an array of record IDs, and other Airtable arrays can have multiple items with identical values. It would be interesting to know if this was a limitation in the UI or if it is enforced in the core, as the API documentation does not explicitly state each entry in a linked record field must be unique.)


The expectation is one would use a quantity multiplier to indicate how many of the item was purchased. And, yes, in that case you would not typically be able to get by with only two tables; instead, you would use a junction table between your ‘W/Os Closed’ and ‘SHS Products’ tables. On one hand, using such a table increases slightly the amount of keystrokes/clicks to add an item to the order; on the other, it makes such things as quantity discounts and changing prices without invalidating historical data much easier…


Thank you very much for your continued contributions to this community, they are invaluable.


Do you know if this issue was ever resolved without the use of a junction table?


It appears that it is still impossible to link multiple times to a single record, which is causing me huge grief with the base that I am working on.


  • Inspiring
  • 1386 replies
  • December 24, 2018
Luke_Chesney wrote:

Thank you very much for your continued contributions to this community, they are invaluable.


Do you know if this issue was ever resolved without the use of a junction table?


It appears that it is still impossible to link multiple times to a single record, which is causing me huge grief with the base that I am working on.


I’m thinking this is a feature, not a bug, and not likely to change — for one thing, the UI is set up to exclude already-linked records from the list of potential targets. It appears this and the inability to deduplicate lookups are a couple of design decisions we’ll have to continue to find ways to work around, when possible, and do without, when not.


Reply