Development & APIs

Hi, I have a base with a field called Accounting Date which is a date field. This field is created via Zapier along with some other info about the invoice. At some point after this field is created, it will change to be 24 hours earlier than what it came in as originally from Zapier. In the revision history, it says this field was “edited via api” and I cannot figure out what is causing this field to change to 24 hours in the past. I have checked thoroughly zapier to see if it’s updating the record and it is not. I cannot figure out how this is happening and hence how to stop it from happening. My question is, is there some way to get more detail on the api history vs what is in the screenshot to solve this mystery? I would not be coming here with this question if I haven’t exhausted every other conceivable way I can think of to figure this out… Thank you.

Hello again, community! I have a script that is throwing an error and would like some help from the community. I’m using two “for… of” loops. The first finds IDs of records in another table that match a condition. The IDs get pushed into the “familiesToAdd” array which works great. As you can see in the screenshot, the second loop throws an error. In the past I have used the same structure to update multiple linked record fields using the spread operator and it has worked just fine. The values that are being provided are certainly strings. Can anyone see anything that looks off? I would be happy to send in more screenshots. Best, Matt

Hi, I need some help! I created a table and I have a button field that has as an action Run Script (I must use this action). I have created a scenario in Integromat and all I want to do is that when I click the button on a record the scenario is launched. I have an Attachment field that contains images in the table, I have a module on Integromat that have to receive the URL of the image. I know that I have to use Webhook, I have created the scenario and I have the Webhook URL. But I don not know what the script must be!! Thanks in advance!

Hello, I am trying to integrate Google Analytics through a global tag through react-helmet but no page views show up on Analytics. The following code should trigger an automatic pageView on Google Analytics when the app initially loads, but it doesn’t. <Helmet> <script async src={`https://www.googletagmanager.com/gtag/js?id=${GA_MEASUREMENT_ID}`} /> <script dangerouslySetInnerHTML={{ __html: ` window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', '${GA_MEASUREMENT_ID}'); `, }} /> </Helmet> I can see it loads properly, but no events are being registered on Analytics. Is this allowed through an app? Would appreciate some direction, thanks!

Setting the active table with cursor.setActiveTable is kicking me out of fullscreen mode despite the docs saying otherwise Has anyone else experienced this? Thanks!

We have multiple APIs connected to our Airtable base. I am trying to debug an issue where an API is changing the status of a record, but I cannot isolate which API is causing the issue. Is there any way to get more granular info besides “you edited via API”?

I just ran this script, it made all my prices to 0. Not good. Please help. I am trying to convert prices from EUR to USD. I found this script on airtable. // Change this to the name of a table in your base let table = base.getTable('Seeds'); // Fetch conversion rate from API - you could change this to any API you want let apiResponse = await fetch('https://api.exchangerate.host/latest?base=USD'); let data = await apiResponse.json(); let conversionRate = data.rates.EUR; console.log(`Conversion rate: ${conversionRate}`); // Update all the records let result = await table.selectRecordsAsync(); for (let record of result.records) { await table.updateRecordAsync(record, { // Change these names to fields in your base 'Price EUR': record.getCellValue('Price USD') * conversionRate, }); }

How to parse Blob, guys? Why this feature is introduced and no documentation and real examples of how to use it. I need to parse local iOS localization file with extension .strings and get keys and values into a table. Any suggestions welcome.

Hello, So, I need to convert attachment file URL to base64 string, as btoa() function does not work in automation script, I am running a scripting app that converts URL to Base64 string and the output of the scripting app will be entered into a new column I created as “base64 string” and using this value in the automation script. My question is how do I run scripting app every time a record is created? Or even better is there any way to convert attachment URL to base64 in the automation script?

Hi I am a bit stuck with this one, and not well versed in scripting / coding. Though I think it should be fairly simple to do? I have two tables : A - A range of dates spanning a month or so. Dates are always consecutive, so 12th May, 13th May, 14th May etc B - A list of people with a field for start date, and a field for end date (this is manipulated using a Timeline view and works well), I’m trying to write a script that updates a linked record from Table B to Table A for each start date, end date and every date in between. This is used to work out when someone needs a hotel room booking. For example Table A - 1st May to 30th May - 30 records Table B Joe Bloggs - Start 10th May, End 14th May Bert Reynolds - Start 14th May, end 20th May I’d have a field in Table A called “Accommodation” which links to Joe Bloggs in Table B on the records for 10th, 11th, 12th and 13th May Also in Table A, the accommodation field would have a link to Bert in Table B for records from 14th May to 20th

I Need Help! I want to know if it’s possilble to send mass emails through sendgrid and get all the performance or reactions to those emails in Airtable. That is i want to be able to track all performance on airtable Please is this possible? And if Yes, Please tell me how to set it up

I Need Help! I want to know if it’s possilbe to send mass emails through sendgrid and get all the performance or reactions to those emails in Airtable. That is i want to be able to track all performance on airtable Please is this possible? And if Yes, Please tell me how to set it up

What’s the recommended way to get the selected cell. I’m using cursor, loadable and can get the cell I want but it feels a little hacky and it seems that there should be a simple solution to it.

Could anyone advise on how to do this? I have a “Quote” record which is composed of its linked “Line Item” records. In order to create a new version of a Quote I’m trying to create copy of the Quote, copies of all the Quote’s Line Items and set the new Line Items as the value for the new Quote’s Line Item field. The problem is that I can never get the Line Item field to accept my new Line Items ids. I’m sure this has to do with the order of async and await operations but I can’t figure it out. My latest attempt follows; const lineItems = useRecords(lineItemsTable); async function createLineItemObject(fields) { const newLineItemId = await lineItemsTable.createRecordAsync(fields); return { id: newLineItemId }; } async function createQuote(fields) { const newQuoteId = await quotesTable.createRecordAsync(fields); return newQuoteId; } async function handleNewVersion(clickedQuote) { const matchingLineItems = lineItems.filter((lineItem) => { const qu

Hello everyone, I want to send a post request (client side) to Discord to create a message. In the custom app (airtable block) I’m getting errors: Problem with cors (I resolved it with anywhere-cors service) After that I’m getting a 403 error. In Postman all cool.

Hi, I am writing an automatum that will add £20 to all records in a certain field every week. I need to (or I think I need to!) write a simple script that will add that £20 to the certain field, just wondered if anyone could tell me how to do this please.

Hi everyone. I am trying to convert a img to a url automatically every time we upload or attached an image to a table. This is the code. let table = base.getTable("Table1"); let selectedView = table.getView("Shows"); let selectedField = table.getField("Speakers"); let fieldToEdit = table.getField("Speakers URL"); async function convertAttachmentsToUrls() { if (selectedField.type !== 'multipleAttachments') { console.log("is not an attachment field. Run the script again with an attachment field"); } // Loads the records and field from the selections above let query = await selectedView.selectRecordsAsync({ fields: [selectedField] }); let records = query.records; // Array for records with attachments and their URLs let attachmentURLs = []; // Loops through qualified records and pushes them to the attachmentURLs array for (let i = 0; i < records.length; i++) { let recID = records[i].id; l

HI Everyone I am sharing a problem today. Not sure is there any solution out there. Please response if there any solution for that. I am trying to get the latest available option for a select able field inside a loop of scripting apps script. But the problem is script provide me the initial instant of the table if i make any change runtime of the script then it’s not getting the updated instance even though i try to take a new instance of the table . Below is my code while(true){ var table= null table= base.getTable("Table 1") console.log(table.getField("Status").options.choices) console.log(await table.selectRecordsAsync()) //trying to make wait the loop var a= await input.buttonsAsync("test",["test"]) } And also want to mention that it’s getting the all the new records in new instance of the table or the updated records are also available on it. But the updated fields options are not available in updated instance of the table. May be it’s a bug from airta

Hey Airtable Community, We’re excited to announce the newest version 2.0.0 of our command line tool for custom block development, @airtable/blocks-cli.Thank you to the developers and community forum members that provided feedback and beta tested this version prior to release. What new features can you expect? We heard feedback that it was difficult to share code between block projects, and the inability to customize the way block’s code was bundled limited what developers could build with blocks. To that end, we’ve worked to release the following features. Use code from other directories: This version allows the bundling of “sibling directories” outside the source directory. Those directories can include npm imports based on link or file. Using a custom bundler: This version uses webpack and allows you to swap out our built-in bundler for your own, custom, bundler. You can provide a complete custom bundler implementation, or you can start with the Webpack bundler package and tweak the

I’m updating a wildfire refugee map based on data from airtable. I’m using ArcGIS and it can import CSV from a URL. My goal is to make a job that runs hourly (or when the table is updated) that creates a CSV and uploads it somewhere.

My Custom app syncs data from a 3rd party into a user’s Airtable base. Previously the app made an assumption that the user was at least using a Pro plan since apps were only allowed on Pro and Enterprise plans so I assumed I could sync up to 50,000 records. Now that any plan can have an app, I need to detect the record limit for the base. Is there a way that I can do this? Thank you

Hi, In the process of building an Airtable AUTOMATION that will update all records in a base at once, I discovered automations only goes to 100 records. So I decided to try the scripting block. However, I have little experience with JavaScript and I’m struggling to apply Airtable’s specifics when it comes to writing a script. Could someone help me understand scripting for "how to update a field for all records in a table, when a record enters a view in another table? HERE’S WHAT I NEED A SOLUTION FOR: I have a “Members” table with a field called “Available Trimester.” I also have a “Trimesters” table that has dates that each trimester goes on sale (There will only ever be 1 trimester on sale). What I’d like to achieve is when a Trimester (based on its sale date) enters the view “Trimester on Sale”, Id like to update the “Available Trimester” for all Members with the linked record to the new trimester on sale. Anyone who can help with an example script that can achieve this?

Hi there, I need some help, I’m new on Airtable! I’m trying to solve a college test. I have created tables with forms, when filling out the forms and updating the tables I would like to have a button that randomly assigns me roles. FORM 1 TABLE 1 FORM 2 TABLE 2 I created an automation to give a value Resistance to the Role column. I have to write a script that randomly assigns a role for each record, the role can be Resistance or Spy. The total number of roles depends on the total number of players. The total number of players is found in another table. If the total number of players is 5 then 3 records must have a Resistance role and the other 2 Spy. If the total number of players is 6 then 4 records must have a Resistance role and the other 2 Spy. If the total number of players is 7 then 4 records must have a Resistance role and the other 3 Spy. If the total number of players is 8 then 5 records must have a Resistance role and the other 3 Spy. If the total number of players is 9

Hi there, New to the community, you guys have already been a huge help. So I borrowed a script from this user: Creating Tasks from a Template and then I adapted the code into an automation I am building. What I am trying to do is this: Via Automation When a Record is created use that record as the selectedEvent (instead of choosing a selected even like Victoria has in her script) and then run the script. Victoria’s script asks you to choose the template for the linked tasks, but I figured out how to set it to one set of tasks by using the id of that template in the code. Below is the code I’ve been using in my automation script and I keep getting this error: Error: Field “fldtxrU67I4FayPzK” cannot accept the provided value. I think my problem is I’m not entering the correct object when I create the list of tasks. I think this has to do with my syntax when referring to an object using the record id. Any help would be appreciated. Thank you all!! // Declare variables for views from the p

Hi I am using AppGyver to produce my app, and I am attempting to link my table to my app via rest API. I am at apoint where I am being asked for the Resource URL (AppGyver). Where can I find Resource URL in Airtable? Thanks