Help

Multiplying a linked record

Topic Labels: Integrations
3690 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Herbshirt
5 - Automation Enthusiast
5 - Automation Enthusiast

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.
Screen Shot 2020-01-24 at 2.18.08 pm

10 Replies 10

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.