The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...