Help

Script for If/Then across multiple Tables

Topic Labels: Formulas
1529 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Brett_Smith1
5 - Automation Enthusiast
5 - Automation Enthusiast

I believe I need a script rather than a combo of filtered views/linked fields/conditional rollups to accomplish my goal:

I have 3 tables: Employees, Seminars, Registrations

I’m trying to populate a field in the Registrations table with a sum of values contained in the Seminars table IF certain conditions are met when compared against other fields in the Registrations table. Below is my best effort at writing this out…obviously not actual JavaScript or Airtable syntax, but hopefully its a start. Tables are bold, fields are italic.

Registrations PDH Earned is sum of Seminars/Webinars (PDH)

IF

Seminars/Webinars Attendees contains Registrations Employee

AND IF

Seminars/Webinars Date is (>= Registrations Previous Renewal Date AND <= Registrations Renewal Date)

1 Reply 1

Welcome to the community, @Brett_Smith1! :grinning_face_with_big_eyes: I’m glad that I searched before replying to your original thread:

You categorized this new thread under “Formulas,” but unfortunately Airtable formulas can’t directly access other tables. In fact, they can’t even access other records. A formula can only directly pull data from other fields in the same record. Each record runs the same formula, but the output for any given record is specific to the data pulled from fields in that record.

However, what you said at the top is correct:

Only scripts run in Airtable’s Scripting block can perform the detailed operations needed to pull off what you want. I’d be happy to help put a script together for you, but because of the time required for development and testing, I’d need to take this on as a client project. If that sounds good, message me directly and we can talk further.