Skip to main content

TWO TABLES MTO AND CATALOGUE.  MTO HAS MANY RECORDS - EACH HAS {XQTY} AGAINST A LOOKUP FIELD CALLED LINE_MATERIAL (WHICH IS LOOKING UP THE PRIME_ID ON CATALOGUE).

THERE MAY BE 10 RECORDS ON MTO WITH DIFFERENT XQTY VALUES ALL FOR THE SAME LINE_MATERIAL.

I WANT TO SUM THE XQTY - GROUPING BY LINE_MATERIAL - AND UPDATE THAT TOTAL TO THE MATCHING RECORD (LINE_MATERIAL = ID) ON THE CATALOGU TO DATAFIELD SUM_1.

I HAVE TRIED JAVASCRIPT, AUTOMATION AND OMNI AND CLAUDE - AND SO FAR NOTHNG WORKS. USING JAVASCRIPT IS THE PREFERRED WAY LINKING TO AN ACTION BUTTON BUT THEN YOU HAVE TO ACCOUNT THAT THE VISIBLE VALUES IN AIRTABLE ARE NOT REALLY THERE BUT RECORD_ID IS….TRIED EVEN TO ACCOUNT FOR THAT BUT NOT MADE IT WORK EVERY TIME SO FAR !!!!

THANKS FOR THE HELP GANG…...MIKE IN LONDON

 

Hm could you provide some screenshots of your tables?

You mention using a lookup field, and so it sounds like the records are already linked?  And so we’d use a rollup field with ‘SUM(values)’ to get the totals?  I think I’m missing something though!

 

Thanks Brainy - I KINDA WENT DOWN THIS ROUTE AND IT DID NOT WORK OUT - LET ME TRY AGAIN !!!

 

tHANKS FOR THE REPLY

WELL DANG...WORKED PERFECTLY THIS TIME…..I DO NOT KNOW WHAT I WAS DOING BEFORE BUT THIS WAS AMAZINGLY SIMPLE AND WORKS A TREAT IN REAL TIME TOO….I SPENT DAYS ON THIS BLOOMI’ CALCULATION….THANKS BRAINY

Hey ​@MikeMitch,

Great to know this has been solved now! For any future reader, you might be interested in taking a look at this guide on how to set up Airtable Rollup fields!

Hope this helps :D

Mike, Consultant @ Automatic Nation 

Terms & Conditions