I’m working on creating functionality for an Airtable CRM that mimics functionality found in Hubspot or other CRMs, where you can bcc an email address and it will record the message in the database under your communications with that person.
I’m user...
Currently in Airtable there’s no function provided for a standard deviation like Excel’s STDEV. One user on this community has helpfully written out the function that calculates it, but it’s rather complex.
I’m wondering if the script block couldn’t ...
Hi! First post here. Very beginning JS user but excited to learn!
I’m working on a pretty basic script in a base I’m working on. I’ve been learning JS but I’m not quite at the point where the examples are making sense to me.
I have 2 Tables in my Bas...
Update: the rollup at the top of the field didn’t calculate to enough decimal places, so I have been pasting my scores out to Excel, calculating STDEV there, and then pasting that back in. That’s been enough for me to calculate z-score pretty easily....
Hey @Jeremy_Oglesby and @Michael_Andrew - thanks for the tips.
I just received the first tranche of scores from judges, so I am going to start working on this in Airtable this week. I paused work on it a few weeks back as it wasn’t the most important...
Thanks Aron!
That’s exactly the issue.
For your first proposed solution, I’m not sure how to add content to a cell instead of replacing the cell. Do you have any guidance on where to start?
I guess the second option would work too, but it’s probably ...
Hey Jonathan (and future searchers) - quick update, when I ran this against my database, there was indeed a race condition with the .forEach system, and I was only getting ~160 of the ~450 records I needed. I edited it to use the for (let project of...
