Russell_Bishop1 - profile

Russell_Bishop1 · Sep 16, 2024

We've saved ourselves countless hours repurposing helper data from other projects; so we've decided to start publishing them.Months and Years data is for projects where we want to report on dates; invoicing, timetracking, sales, orders… it's everywhe...

Russell_Bishop1 · May 31, 2024

I've saved myself countless hours repurposing helper data from other projects; so I've decided to start publishing them.Countries and Timezones in particular are great for adding some helpful context to a list of companies or staff – or just to help ...

Russell_Bishop1 · Apr 30, 2024

Check out the guideWe've just published our first of many technical Airtable guides on Mass. This one is our holy grail for automated field copying and building junctions.No scriptsNo duplicates everImpossible to break (you should try)Crack open the ...

Russell_Bishop1 · Mar 13, 2024

We're looking to build out our network of Airtable professionals to work on projects at Mass.If you're interested please fill in our short application form.Look forward to meeting you,Russ

Russell_Bishop1 · Mar 09, 2021

It would be really helpful for me to be able to ‘Copy Filters as Formula’. Often I switch from using View Filters to an IF(AND()) type formula when filters get more complicated, or I want to re-use the logic across multiple tables with lookups. In t...

Russell_Bishop1 · Jul 09, 2024

Not natively @JacobCH , you can use connecting app like Make to send/receive fax with RingCentral or a similar competitor.

Russell_Bishop1 · Jun 28, 2024

but I can't total up the employees who actually attended the program.@Wendy_Yelsik wrote:I want to store the total number of employees in the programs table to calculate the participation rate. Additionally, I'd like to break down the number of emplo...

Russell_Bishop1 · Jun 28, 2024

Do you create records in the Tasks table for every employee, and only ✅ DDONE the ones who attended?Each program needs to be able to grab the total number you're dividing by (Attend % Total). That either means you should:Create a Task record for ever...

Russell_Bishop1 · Jun 28, 2024

Hi @Wendy_Yelsik ,You need to create a junction table – that's a table that sits in-between two tables to store extra data about them.For example, you need to store whether Employee A attended Program B – which means you need an 'Attendees' table tha...

Russell_Bishop1 · May 09, 2024

@JanV is this a one-time exercise, or do you need to continually repeat this with new data that lands in your initial table?

User Statistics

User Activity

Month and Years data 🗓️ 🌔

Countries and Timezones data 🌎 🕒

Guide to automated junction tables and copying fields

Freelance Airtable developers

Copy Filters as Formula

Re: Faxing in Airtable

Re: Calculating Participation Rates

Re: Calculating Participation Rates

Re: Calculating Participation Rates

Re: Transpose rows to columns (but not pivot)