Multiplying a linked record

Herbshirt · ‎Jan 23, 2020

Hi there,

See screenshot attached. Components have a cost, multiple Components make up a Panel, multiple panels make up a Humpy. BUT - a Humpy may have, for example, 6 x P6/24’s and/or 3 x P9/24.

How can I multiple each of the panels by a number in order to calculate the PanelsCost?

Thankyou.

Justin_Barrett · ‎Jan 31, 2020

Off the top of my head (seconds after I read the post), I can’t think of a way to build such a system natively within Airtable. It would require multiple iterations of:

Pick a panel
Set the quantity for that panel

…all in a form that wouldn’t care if you wanted to add one panel or several dozen. Airtable forms aren’t designed for that kind of flexibility. This would require integration with a third-party form tool like Jotform, Typeform, etc.