Development & APIs

Dear community, I have very little experience with scripting and that is why I am struggling with customizing the currency converter example. My code: // Change this to the name of a table in your base let table = base.getTable('GT_MasterData'); // Fetch conversion rate from API - you could change this to any API you want let apiResponse = await fetch('https://api.exchangerate.host/latest?base=CZK'); let data = await apiResponse.json(); let conversionRate = data.rates.EUR; output.text(`Kurz: ${conversionRate}`); // Update all the records let result = await table.selectRecordsAsync({fields: ['nakupni_cena_eur_ke_konverzi', 'nakupni_cena_po_konverzi']}); for (let record of result.records) { await table.updateRecordAsync(record, { // Change these names to fields in your base 'nakupni_cena_po_konverzi': record.getCellValue('nakupni_cena_eur_ke_konverzi') / conversionRate, }); } I would like to automate script triggering by time via “Automations”. In order to do

Hi! Is it possible to create new options for single-select or multiple-select fields while creating a record with a script? API allows using the typecast:true parameter. Is it possible to do the same in the scripting application’s createRecordAsync() function? Thank you in advance.

Hi there - I am wanting to link Airtable with my Wordpress membership site and have the username and/or unique person ID automatically passed into the Airtable form. Is there a way to do this so I can have some level of automation for each user?

I have registration forms that collect a digital signature. It imports into airtable as a url, like this: (https://s3.amazonaws.com/files.formstack.com/uploads/3669579/85172110/582992994/signature_85172110.png) Can someone help me with a script that would convert this to an image attachment?

Hi all, I need to retrieve a list of items from a formula filter like this filter To do this I use “API URL encoder tool” here is my formula: AND(RECORD_ID_CONTACT="recXXX1234", Statut="🤝 Mission conclue", IS_BEFORE("Fin de mission", TODAY())) curl: curl https://api.airtable.com/v0/appXXX1234/%F0%9F%96%B2%20Disponibilit%C3%A9s?filterByFormula=AND(RECORD_ID_CONTACT%3D%22recXXX1234%22%2C+Statut%3D%22%F0%9F%A4%9D+Mission+conclue%22%2C+IS_BEFORE(%22Fin+de+mission%22%2C+TODAY()))&sort%5B0%5D%5Bfield%5D=Fin+de+mission&sort%5B0%5D%5Bdirection%5D=desc&view=%F0%9F%94%BD+Chrono \ -H "Authorization: Bearer keyXXX" response is : {"records":[]} If I remove IS_BEFORE from my request, I have results. Maybe I’m writing my formula incorrectly? Thank you for your time :slightly_smiling_face:

Hi there - When using createrecordsasync, it’s helpful to know what record ID was just created. How is it possible?

Dear Community I am relatively new to Airtable and all its fab benefits, I have a query about automating and scripting and how best to use this for my example here. We use many bases, one for each client as we find it most useful and each contains many tables. I have thought long and hard about making this one huge base and having different views or tables but honestly, for us we prefer to see the clients in the bases (bad practice?). If I automate a trigger to bring information into Airtable from google forms, can I set it up so it creates a new base each time, rather than a new table in one base? We use a base per client as we have a lot of data and find this easier for us visually. I could always bring all the form information back to the one base if I had to and then maybe there is a script I could run from within AT? Thoughts and ideas on how I can handle appreciated. Thanks Community. Catherine

I did not see these APIs in the documentation. Does anybody know if these APIS exist? - createTable, createFieldInARecord, createView .

Is there a feature or method to DISABLE the apps window from displaying/sliding open when a script is executed via a button in a table? Or, is this a feature request? I’d just like it to run in the background when manually executed, like an automation.

I have searched the API docs, and I see no way to do this. With the AirTable API, how do I create a new tab (new table) in an existing base? and then populate it? I do not see this feature of inserting or creating an new tab into an existing base, only the ability to insert rows into an existing table that was created by a human that opens a web browser and clicks. We have needs to automate the creation of new tables in an existing base (and down the line, creating new bases programatically).

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.