Development & APIs

I would to have a button to click that acts like a browser "tel:1234567899" link.Attempted to do this with the Button field, but it appears that "tel:" hyperlinks does not work to create a button that opens a URL to call a phone. The button is not clickable, it's greyed out (see image).However, the "mailto:" URL shortcut works, but not "tel:"Are there any workarounds to this that will put a clickable link in any view type? (grid or interface?) An Airtable community member suggested I post here and ask.   

Hi Team,Can Airtable be Integrated with One - Drive ? If yes can you please let me know if it's going to be an one sided integration or two. does it also covered in Airtable Ent. account ?Yakshi

Hi - I have a newbie question here. I am writing a script with the script block to write a value into a single select field but I keep bashing my head against the wall. Can someone give me some guidance? Here’s the short and skinny: If I use the below, it all works, because the “ZIP CODE” field is of type “single line text”. I can write “12345” into it all day long. let newPreference = "12345"; // update the notes history value and reset the notes value VoterTable.updateRecordAsync(record, { "ZIP CODE": newPreference }) However, in the below, the “PARTY” field is of type “single-select”. One of the options is “Green” but I cannot write “Green” into the field at all. In fact, I cannot write ANY of the options into the field at all. I tried prepending the ordinal value as “11Green” and “11|Green” (Green is the 11th value) and nothing works. Every time I run this, nothing happens. let newPreference = "Green"; // update the notes history value and reset the notes value Vote

Hi! Hoping for some insight! I hope I explain this correctly.I work with a talent staffing company for performers. We staff for seasonal events at large attractions, like a big Halloween event that happens only on select days in October. We hire over 100 performers for these events to fill 100 different roles at the attraction.I am trying to find a way to generate a daily schedule based on a person's role assignment and availability conflicts. Here's what I have so far:Table 1 Source of Truth: All performers with their record information (personal info, audition information, hiring/onboarding status, etc). Table 2 Scheduler: A list of all of the event dates with a link to Table 1 so performers can select the days they aren't available via a form on Table 1.Table 3 Roles: A list of all 100 roles that are linked to Table 1 so the casting directors can cast the roles upon hiring and info about each role (what area of the attraction they're in, what rehearsal group they're in, etc)Tab

Hi, I'm getting this error AirtableError { error: 'SERVICE_UNAVAILABLE', message: 'The service is temporarily unavailable. Please retry shortly.', statusCode: 503 } can someone help me

All synced tables are failing to sync and saying 'Unable to sync this source. Unexpected isSafeToKeepProcessAlive error'.

Hi All After many hours of trying, I have to ask for help 😁: I'm getting an error "Field "fldxxxxxxxxx" cannot accept the provided value." The field that is failing is Worker. After testing, everything here works fine and writes well to the base except "Worker": item.workerID.Worker is a linked field, and I thought it would accept a record ID.workerID is definately a valid recordID as I've tested in manually by pasting the values into the worker field.Does anyone know what might be going wrong? const outputTable = base.getTable('Work Weeks');for (item of result) {await outputTable.createRecordAsync({ "Week Number": item.week,"Total Hours": item.value,"Worker": item.workerID,})};

New base color doesn't support getHexForColor in @dashler78/blocks.@dashler78/blockshttps://www.npmjs.com/package/@airtable/blocks?activeTab=versionsI'm developing an extension for airtable in-house,Because it is developed so that the extension color changes according to the base theme colorI hope the new color will also support getHexForColor.

Reproduction Steps:Generate the https://airtable.com/oauth2/v1/authorize endpoint with the expected query string parameters specified in the authorization referenceOpen an incognito browser window (In my case I used Google Chrome 64-bit Version 87.0.4280.141 on Windows) and paste the link in step 1.You are taken to a login prompt as expectedEnter your email, and you are then moved to a "Verify it's you" security prompt, complete the actions You are then taken back to the login prompt where you can enter your passwordAfter entering your password, you are then redirected to the home page of the account you logged into In order to continue with the authorization workflow, you have to re-enter the authorization URL generated in Step 1 into the same browser window session, which then takes you to the page to verify/accept scopes and access of your OAuth 2.0 application Then you are redirected back to the specified redirect URI where you can complete t

I’m creating an automation to run when a record is updated like this: " In the script, how can I get the record that was updated or its ID? So I can target only it. The example I’ve found select all records: // Update all the records let result = await table.selectRecordsAsync(); for (let record of result.records) { console.log(record) }

I want to use a single select that is submitted via a form to populate a field in this record called art_tone. This is Airtable automation.Note: the aim of this was to use this approach for a few thousand variations so IF statements with No code would hit the 25 actions limit very quickly.The input variables are the airtable record id = recordid. The other input variable is the field heading name we are looking for in the 'Name 1' table. This is named name1fieldname, the value of this input is from the field 'tag' from art1. I am only interested in the first record [0]. I want the cell value from the field with the value 'tag' pulled through from the input variable name1fieldname. Help? // Access the record passed in from the automation let inputConfig = input.config(); console.log(inputConfig); // Get the values from the record fields let recordid = inputConfig.recordid; let parentingfieldname = inputConfig.parentingfieldname; // Input variable parentingfiel

I create a basic javascript web app with some ajax javascript call using the api. I try to get all the records from a table but the response show me only 100 records. Can someone give me an example for solving this problem? I use maxRecords and the offset functions but i’m not understand how i have to use that. Thank you.

I wanted to know if there is an endpoint in the Web API or otherwise, that can list all workspaces that belong to a specific Airtable account. I'd like to be able to programmatically query all the bases that belong to any given workspace, so I can create a script that'll handle onboarding and offboarding on Airtable. I know that you can use the Get Enterprise endpoint (https://airtable.com/developers/web/api/get-enterprise) to get a list of workspace ids. But for my specific use case it isn't helpful. I need to be able to see workspace information beyond just the id. 

I have a few tables where each table has linked records to the other table and I am fetching it with the Airtable api the problem is though that I need to first fetch table 1 and and get all the linked records IDs and then I fetch table 2 with the record ids and so on until I get the whole object graph and it’s very slow my question is is there a way to get the whole graph in a single api call?

I’ve tried to update my code to take advantage of the field IDs instead of using field names. It works great when sending data to Airtable. But when I query Airtable for records, it sends the field name. Is there a way to get Airtable to send the field IDs instead? Currently, I’m receiving something like this with field names: { id: ‘rec2FTSuyeCV042Pa’, fields: { Person: ‘Steve’, Birthday: ‘1992-03-30’ }, createdTime: ‘2022-03-14T22:32:21.000Z’} But I want to receive something like this with field ID’s instead: { id: ‘rec2FTSuyeCV042Pa’, fields: { fldF2IRPW6dwD0VDr: ‘Steve’, fldkuv35FqhZPq2GT: ‘1992-03-30’ }, createdTime: ‘2022-03-14T22:32:21.000Z’} Any help is appreciated!

Probably a pretty simple script update here but I'm stumped... Everything just comes back as undefined rather than the value 1.  

Hello,I have a working API to list the records from base. When I test from postman with below URL, it returns the data as expectedURL: https://api.airtable.com/v0/app123/Locations?view=LocationDetails&api_key=2345{ "records": [ { "id": "12345", "createdTime": "2023-05-30T15:23:34.000Z", "fields": { "Location": "ABC1", "Record Creation Date": "2023-05-30T15:23:34.000Z" } }, { "id": "12346", "createdTime": "2023-05-16T15:23:34.000Z", "fields": { "Location": "ABC2", "Record Creation Date": "2023-05-16T15:23:34.000Z" } } ] }I would like to add a condition to filter out response based on field (i.e: Record Creation Date) from base.E.g: I would like to get the response from API to only return entries where (Record Creation Date > 2023-05-16T15:

Hi!I follow Hello World tutorial step by stepAll works fine except the releasing step:>block release Bundling... doneUploading... IncompleteError: ❌ The block could not be found. Make sure your API key is correct and that you have access to the block.Code: airtableApiBlockNotFoundWhat could be the reason of the issue and how can I fix this?Thanks!

HiI would like to know the pros and cons of using Airtable scripting extension to save emails  sent to either a domain specific mail id (like "someuser@exampledomain.com" ) or to a gmail account. I think there are some extensions in market place which does this job but it has recurring cost. For instance if we plan to use gmail account as the mail receiver then I think gmail API can be used to create a custom scripting solution to store emails (along with attachments) into Airtable base. I think the same approach works with other domains as well as long as they share an API to read e-mails. Please share feedback on this approachThanksHenry

 var authHeader = "Basic " + Utilities.base64Encode(wordpressUsername + ":" + wordpressPassword); I am getting error at "Utilities"  saying"Cannot find name 'Utilities'"  . I need to send post to wordpress using it's rest api and Utilities is required for it's authorization . Kindly help me , any information  regarding this will be great. Thankyou

Hi everyone, We are hosting a festival across our catchment and basically want to create a loyalty app so that when participants do an activity they get a 'stamp' and then can collect a badge at the end of the week. Would something like this be possible with airtable? Any suggestions on how to go about it? There would be upwards of 1000 people participating in activities and 200+ activity hosts.

Hello!I am using formula fields to generate prefilled form links to send out via email and SMS. The emails are pushing through fine, however, the URL is not being generated and sent through the SMS via Twilio. The message comes through, but there is no URL included.  

Bonjour,J'utilise Airtable sous Windows 8.1 à jour. Depuis ce matin, lors de son lancement, le message suivant apparaît :Le point d'entrée de procédure DiscardVirtualMemory est introuvable dans la bibliothèque de liens dynamiques C:\Users\Pascal\AppData\Local\Airtable\app-1.6.0\Airtable.exe.Voici ce que j'ai fait :- Désinstallation / redémarrage et réinstallation en tant qu'administrateur- Ajout exception sur le setup dans l'antivirus Trend Micro- Erreur Windows :Nom d’événement de problème: APPCRASHNom de l’application: Airtable.exeVersion de l’application: 3.0.0.0Horodatage de l’application: 645bc1f5Nom du module par défaut: Unknown!LdrHotPatchRoutineVersion du module par défaut: 6.3.9600.20718Horodateur du module par défaut: 636f3964Code de l’exception: c0000139Décalage de l’exception: 00000000000ed1b0Version du système: 6.3.9600.2.0.0.768.101Identificateur de paramètres régionaux: 1036Information supplémentaire n° 1: ac05Information supplémentaire n° 2: ac0507478d1c5bd693

I am using Airtable as a finance base that enables us to create a financial forecast for the current year.  I want to be able to correctly predict all salaries that are going to be paid out.  All compensation changes for each employee are located in the "Compensation" table. Compensation can be changed on a quarterly basis for each employee. When I enter new compensation for an employee, I need to run a script that would find the last compensation for that particular employee and within the last compensation record enter CompensationEndDate which should be the day before the new compensation 'CompensationEffectiveDate'. I have tried to write a script using AI, however, I continuously get this error message:"TypeError: Cannot read properties of undefined (reading 'getCellValueAsString') at updatePreviousCompensation on line 13 at main on line 33" // Fetch the table and sort it by CompensationEffectiveDate in descending orderconst table = base.getTable('Compensation'

I would like to find records whose ID field match a given value, playlistId, in a specific table I defined as playlistsRecords. In other words, I want to find matches in a field, get their record IDs, and if there are no matches to tell me that there are no matches. I've tried "playlistsRecords.includes(playlistId)" without success and suspect I need to rely something like the following: base('Playlists').find(playlistId, function(err, record) { if (err) { console.error(err); return; } console.log('Retrieved', record.id); }); Any pointers? Past experience?