Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Hi there, I’m a French PharmD and I use Airtable to manage all patients’ appointments. It’s very useful for all my team except 1 laborious step : create appointments. I manage all appointments in a dedicated table (every X days I create X records for...
I’m using a button to trigger a Zapier webhook. It’s annoying that every time the button is clicked, a browser window is opened. As I can select to run a script with the push of a button, is there any way to run a script in the background that trigge...
Continuing the discussion from Creating new row entries from a long text: Since this thread was closed and I’m facing a similar problem I was wondering if someone could help out. I have a Long text field in my table, lets call it “Task Submission”, t...
If you’re using a rollup field to summarize linked records with ARRAYJOIN(), the array’s order is determined by the order of the linked records. I created this script to automatically sort linked records in a cell. My use-case is to summarize interac...
Is there any way to get a record by a cell value? I have an API hitting a webhook and passing in an external ID, which is present in the table as a value in the “External ID” cell. I need to get the associated Record. Seems the only solution is to it...
Hi All Am wondering if anyone can help me integrate the PhotoRoom API with Airtable. Notion Notion – The all-in-one workspace for your notes, tasks, wikis, and databases. A new tool that blends your everyday work app...
I have a script that is creating (by sourcing data from airtable tabs) a large text result that I would like to store as a file attachment column in airtable. I cannot see how to take a text variable (e.g. 1000 lines of text) and turn it into an atta...
Hello All, I’m looking to see what my options are to create and download a csv file generated from a base, but with a very specific format. Right now I have a script that loads records from the base, creates a stringified csv document, and then saves...
I would like to create a script that creates a number of records based on a quantity field. Essentially, if there is a record that has a quantity (x) of more than 1, I want to copy and create that record x amount of times within the table, then lower...
Hey there. I’m trying to set up some script to automatically input my Images URL to Attachment. I found some code in this forum but I’m running into errors that I don’t understand. Code I’m running: let table = base.getTable('PhantomBuster'); let qu...
Hi everyone! I’m happy to announce that we’ve released a new scripting API capability today, and this is available in both the Scripting App and the ‘Run a script’ Automation action. You can now select records by recordId, either by setting a new rec...
In the API definition for RecordQueryResult it says A RecordQueryResult represents a set of records. It’s a little bit like a one-off Airtable view: it contains a bunch of records, filtered to a useful subset of the records in the table. but in the...
I have a multiple select field I am attempting to update within an automation, but I can’t seem to add an option to it without overwriting. Pared down, this is essentially what my code looks like right now: Val = record.getCellValue("The Cell") if(co...
Hi everyone, I used a very painfull and well known here workaround until now to update the listing of a (target) linked field depending on the selection of another linked field. But, I have a premium account and access to scripting. I wonder if it’s ...
Anyone knows why this is happening in Chrome and if there is a fix? Currently using Safari for developing.
Explainer Video: Base: Airtable Same Table Backlinks - Airtable Universe Title: Same Table Backlinks License: MIT Author: Openside (Team behind On2Air products and BuiltOnAir c...
Hello, how can I create a PDF document in automation? I want to create a PDF from a database to send as an attachment, is this possible?
and failing, to be honest. Please take note that I have no idea what I’m doing and this script is pieced together from snippets and posts I found on the forum. This is what i have until now. I’ve tried multiple variations but I haven’t been able to w...
Good morning everyone, I can’t seem to figure out the correct syntax for updating a Linked Field within a record. My test base is simple, two tables, a name field in each, and a linked record between the two. Table First Table Second Example of my ...
Hello dear members of the community, I hope you’re doing well. I am requesting your help because Airtable removed the “editable shared view” that I was using before. I therefore need to find a workaround. I would like to use a script, so that when a ...
