Hey, all!I was wondering if there is a way to gain the sum of values based on column data. Here is what I'm looking for:I have four tables--materials, packets, procurement, & purchase orders. I link the materials to the procurement table to populate ...
For some reason, all of records are being updated when I believe my “if” statement should only have the record the form chose to be updated. What am I doing wrong here?
let table = base.getTable(‘Material Log’);
let view = table.getView(‘Joe Inventor...
So I ended up doing something similar. I when you link a table's records it creates a column in the linked table that puts a linked record for each one that is linked. So here's what I did. I already had table 2 linked to table 3. So I made 4 rollup ...
Sorry for the late reply. Here is a spreadsheet example of my thought process. I have packets that track the given item that travels through the shop. Each packet has a job/client. Additionally, I have a material table that include our stock material...
If I'm understanding your set up correctly, you could do this with a script or with a view and an additional table. The simplest, but also easiest to break, would be a view and a new table. I couldn't give too many details on the script without under...
