Maybe I'm understanding this wrong but the sum in the link to line item detail is the total sum of the subtotals of that app/table, but how do you limit it to only look up the subtotals for a particular invoice? Shouldn't there be somewhere in the formula that says to only be looking at the subtotals that refer to invoice 1001? You say you want to sum all of the related subtitles but how is that limited to the particular invoice?
Hi Gareth. Thanks as always for the insightful video. I was actually creating an IT Helpdesk Shift Swap base in Airtable (I am still trying to get SmartSuite into my organisation...) and ran into the same situation where automations would not really work without a junction table. I eventually created a junction table and all ended well - some days, the obvious is not apparent! Quick question though re the video which came to mind: how would you structure the Solution you demonstrated, so that future service cost increases do not get reflected in historical invoices? As always, many, many thanks. Cheers Shaun
Great question! In that case, each new service cost would be a new record in your system. Otherwise, if you use existing records, it would incorrectly change historic prices in your database!
Going from Airtable to smartsuite is painful. SmartSuite seems pretty beta. I like the idea but I'm finding all kinds of problems. I have tables with 30,000 records, and getting them to link and lookup reliably without crashing is a real problem. Also, the formula field could be better in its ability to format data right now their is no way to get it to spit our a percentage. Right now It doesn't seem to be able to take data from one solution and use it in a formula on another. The product has so much potential but it is not ready for prime time.
![PURPEECH - นี่ฉันเองคนที่... (It's me) [Official MV]](http://i.ytimg.com/vi/NuhHd0hOOg8/mqdefault.jpg)
Grab our free automation training ⚡⚡ garethpronovost.com/webinar-registration
Follow along in SmartSuite 👉👉 partners.smartsuite.com/8ust3byf6ihl
Timestamp: how to actually create the linked relationship: 9:18
Maybe I'm understanding this wrong but the sum in the link to line item detail is the total sum of the subtotals of that app/table, but how do you limit it to only look up the subtotals for a particular invoice? Shouldn't there be somewhere in the formula that says to only be looking at the subtotals that refer to invoice 1001? You say you want to sum all of the related subtitles but how is that limited to the particular invoice?
Hi Gareth. Thanks as always for the insightful video. I was actually creating an IT Helpdesk Shift Swap base in Airtable (I am still trying to get SmartSuite into my organisation...) and ran into the same situation where automations would not really work without a junction table. I eventually created a junction table and all ended well - some days, the obvious is not apparent! Quick question though re the video which came to mind: how would you structure the Solution you demonstrated, so that future service cost increases do not get reflected in historical invoices? As always, many, many thanks. Cheers Shaun
Great question! In that case, each new service cost would be a new record in your system. Otherwise, if you use existing records, it would incorrectly change historic prices in your database!
@@GarethPronovostWhat do you think of an additional junction table? Like: Invoice > Position > Price > Product.
@@arneb2768 totally recommend this where it's helpful!
Going from Airtable to smartsuite is painful. SmartSuite seems pretty beta. I like the idea but I'm finding all kinds of problems. I have tables with 30,000 records, and getting them to link and lookup reliably without crashing is a real problem. Also, the formula field could be better in its ability to format data right now their is no way to get it to spit our a percentage. Right now It doesn't seem to be able to take data from one solution and use it in a formula on another. The product has so much potential but it is not ready for prime time.