Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Linking fields to a Master table using non-primary fields

Hi there,I have a series of quality assurance data for my Online School which has been populated using different google forms and is therefore stored in different google sheets. I am bringing the data into Airtable to use an interface to visualise it...

Jamie_Rood by 5 - Automation Enthusiast
  • 8 replies
  • 0 kudos

Populate Vendor Linked Field by searching the name

^ Sorry about that subject ... I don't know what I'm doing.So ... I have Table Vendor, and Table Transactions... the Name field in the Transactions table sometimes contains the same text as in the Vendor field (which is called 'Who' [i know ... awful...


Automating a Script to Create Record based on Field Summary

Hi,I currently have several dashboards for client fleets using Interfaces. On these I use the Field Summary to calculate the percentages of a fleet based on whether they are 'active' and within a servicing window. What I would like to do is automate ...

MikeKennedy by 5 - Automation Enthusiast
  • 2 replies
  • 0 kudos

Share individual record URL but not all fields?

Hello, I've got a Base where each record is a person. I'm trying to create an automation that will share that record as a URL with each person (using their email address in one of the Fields), but not ALL the Fields in the record. I know I could manu...

altissiere by 4 - Data Explorer
  • 2 replies
  • 0 kudos

Building Table based Reports that has live data

Hi, non-dev hereI have been an avid user of Airtable and I'm enjoying it but there's some things like proper pivot tables and reports I wish were available.So anyway, I am currently trying to build a report that uses live data from one table to anoth...

Screenshot 2023-04-27 at 5.48.41 PM.png
DennisyuTSS by 5 - Automation Enthusiast
  • 5 replies
  • 0 kudos

Repeating Groups for function generated array

Background: I'm currently building a surfboard reservation system and have been running into roadblocks trying to stick to the free plan because I can't utilize the advanced calendar features. I have two tables currently, 'Surfboards' and 'Reservatio...

RoseAmelia by 5 - Automation Enthusiast
  • 3 replies
  • 0 kudos

Resolved! Automating Data Transformation for import

Hi Fellow Community Members, I get these inventory summary sheets from my vendors that I first have to run a macro on in Excel to transform the summary to individual records to update my inventory in airtable. The sheets are for dresses so each row h...

Screen Shot 2023-04-19 at 11.38.37 PM.png Screen Shot 2023-04-19 at 11.37.10 PM.png
Sobhy_Sonbol by 5 - Automation Enthusiast
  • 3 replies
  • 0 kudos

Automated Notifications

We're exploring Airtable as a project management tool to be used internally and one of a must-have features is sending alerts to Slack or email, so that respective team members get notified when there is a certain change to the project status, activi...

Preventing duplicate student data across multiple bases in Airtable

Hi everyone,I'm using Airtable as a database for my microlearning platform, which delivers courses over messaging channels like WhatsApp. Each base in Airtable corresponds to a different organization, and within each base, there is a "Students" table...

RSk by 6 - Interface Innovator
  • 3 replies
  • 2 kudos

Auto-populating cells across tabs in Base

Hello!I am somewhat new to AirTable and LOVE it! I'm currently working with the Pro subscription.I have a base where the first 2 columns (Primary Field and column immediately after) on a grid view carry through on all 7 tabs of the dataset. Each tab ...

Automatic classification transactions seems a nightmare

I'm a new Airtable user and I'm trying to replicate some functionality I had in my previous spreadsheets integrated with Looker. I have two tables: Categories (with fields ID, Histórico, Categoria, subcategoria, and Centro de Custo) and Transactions ...

rperoni by 4 - Data Explorer
  • 1 replies
  • 1 kudos

I need help with Scripting

Hi Airtable community,My script is taking too much time to complete and going over 30 seconds limit. I would appreciate if you could review it and give me some tips. Here's the code:let emailSendersTable = base.getTable("Emails to clients"); let list...

nshnv by 4 - Data Explorer
  • 1 replies
  • 0 kudos


What's wrong with this script? let tableName = "Table 1";let viewName = "Books (ChatGPT)";let openaiUrl = "";let apiKey = "sk-key";let table = base.getTable(tableName);let view = table.getView(viewName);let record...

zhyk01 by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Saving/Copying the record values after updating them

I have this table to track some gym progress.I have a number of updated values for each record, e.g.:for a 1 set of 10 for 245 for b 2 set of 8 for 356and etc.there is also column for tracking the latest update.I need to be able to somehow store the ...

milhauser by 4 - Data Explorer
  • 1 replies
  • 1 kudos