Development & APIs

Hello,I am looking to embed the improved search extension onto my website when searching the database for select information.Is this possible?The basic search bar is extremely poor and doesn't pick up the information I require.

Hi smarter people than me, I hope you can help?I have an integration with CraftMyPDF where I send a payload I build in script through to be used to populate the PDF template. 2 of the fields passed through are date fields: Contract date and Event date. I have noticed that these fields are always offset by 1 day in the past.In the base grid view (or any other Airbase view or interface) these dates reflect accurately, as captured. When I use these same fields in my payload and inspect it, they reflect with -1 offset. The dates are formatted "friendly" and set to my local timezone.Does anyone have any suggestions on how to get the API to honour the date as it is shown in grid views?thanks in advance!

Hi all, I have a docupilot/Airtable integration set up where every time a student submits a form via Airtable, it sends them a PDF of their responses. There is an automation set up via Zapier that creates the PDF and an automation in Airtable that sends out an email confirmation with the PDF as an attachment. Some of the fields in the submission form are long line text with the rich text formatting option so that people are able to italicize text when needed but the problem is that when the PDF is created, it doesn't capture the italicized text and instead adds an underscore before and after the italicized text. (Ex. _text_ instead of text)Does anyone have any idea as to what may be causing this issue? Thanks!NeptuneDev

i have a json with specific format. can i use api to build a new base with the specifation?

This is happening on trigger from record creation, another script triggering a webhook, etc.  The automation just hangs on the first script step endlessly.I've confirmed that the script executes successfully when run by itself.  According to status.airtable.com everything seems fine.Anyone have an idea on what might be the issue? 

Hello community, after the implementation of prsonal toekn if i use curl method it retrives i get only 100 records.. How can i use offset method? earlier i used offset using api key and it works good but now api key was deprecated. Awaiting for solution

Hello,I have successfully created new table from a custom extension. Nevertheless, I want to create "Button" field in that table that will invoke my custom extension.There is an example in documentation which says I must obtain the URL of the block here:  { // The label of the button label: string, // URL the button opens, or URL of the block that the button opens. // Null when the URL formula has become invalid. url: string | null, }   What I am obviously missing is how to get URL of my blockThanks in advance.

Hi, currently Zapier can only connect to Airtable via an API Key per https://help.zapier.com/hc/en-us/articles/8495995404173-How-to-Get-Started-with-Airtable-on-ZapierIs it the Airtable dev team's responsibility to update their integration with Zapier, to make use of personal access tokens or the new oauth mechanism?Or, can someone on the dev team prompt Zapier to do it?

Hi i’ve created an attachment cell and attached an mp3. If I grab the url from the api it does not play? Any ideas?

I am now working on integration the Airtable OAuth to my existing system.So I am trying to test on Postman first.But when I send the GET request (e.g. https://airtable.com/oauth2/v1/authorize?client_id=xxx...) for Authorization in Postman, it return the web page "verify it's you -Airtable". The page also says "Our systems have detected unusual traffic from your computer network. Please help us with a quick security check to validate it’s you sending this request".But if I run the GET request on a Chrome browser, I can get the return code without issue.Can anyone help? 

I am going to integrate the OAuth2 authentication with my existing apps.The first step is to send a GET request to https://airtable.com/oauth2/v1/authorize .But I failed on the first step.Here is the error:http://localhost/?error=invalid_request&error_description=%22code_challenge%22+must+be+a+valid+url-encoding+of+the+the+sha256+of+the+code_verifier+variable+generated+%28length+43%2C+alphanumeric+characters%2C+%22_%22%2C+or+%22-%22&state=e3f98sdasfdafsafdafsdasfwerwersfa03Below are the parameters for the GET request:client_id = //not exposed hereclient_secret = //not exposed hereredirect_uri = http://localhost/response_type=codescope=data.records:read data.records:writestate=sadjfhkjDFHKJShk23489sldfhjksdkssdffsf // random textcode_challenge_method=S256code_challenge=MTA4ZDJhYTQ1YTVhMGE3M2MwNTc3NmJiMzYyZTdhNDc3ZjgyNGUzN2U3NGZhYzA0ZGQ1NDAwYTE5OGM0OTMzYw// where the code verifier is SLAJFlksdlksfjljasldjflasjflasjflasfjisfjjdI already encoded the code verifier with SHA

I am creating a new record triggered by a script with the following code: let newRecs = {};newRecs[0]['id'] = 'recDYGIT7fj80tTAH';await table.createRecordAsync({'Start Date/Time': billTillDate,'Contact': newRecs,'Notes': 'New Record note'});I am getting the following error:  TypeError: Cannot set properties of undefined (setting 'id') Can you please modify the script - assuming the record Id is correct - so I can populate my Contact link field? Thank you!

I will be processing a very large number of social media posts in both image and video format. Due to this I will inevitably run into storage issues very quickly. I have image URLs set up like this within my table:https://ik.imagekit.io/sq64zigvs7/tr:w-2700,h-2025,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1500,h-1000,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1200,h-630,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1080,h-1080,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1600,h-900,/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1080,h-1920,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpgIs there a way to automatically download these as an attachment (like if time to scheduled post is say less than 2 hours or

Is it possible to create one collumn that contains name with a hyperlink combined?I know how to do it manually. Is there a way how to do it automatic?I can easily do this in bulk on google sheets. But when trying to paste the data from sheets to airtable it just shows the name without the hyperlink.How do I do this automatic?

I am configuring a Learning Management System that has a master table of all trainings that could be assigned, which are then linked to an "employee type" table that contains every possible role. This is a modified re-creation of the "create new tasks for certain project type" script/tutorial found here: https://youtu.be/zHQjljEov30I was able to repurpose the script to create new tasks but I just realized, I think that the script is ignoring applicable trainings that are linked to multiple employee types. I am pretty sure the way the script is filtering through the templates is to blame. This section is what I think I need to fix. I am new to scripting and I'm not sure if there is a different way to basically say "if any linked records in "employee type" for task match the specified employee, return that task" Since right now I think it is only reading the first linked record employee type... does this make any sense? I can definitely link the whole base/script if unclear &#128578

Hi. I'm trying to create a new user via API. I'm passing names, and emails in the body payload but I always get an error, "Invalid request". Is there something I'm missing. Here's an example payload similar to what I'm using.{ "name": { "familyName": "Jane", "givenName": "Doe" }, "schemas": [ "urn:ietf:params:scim:schemas:core:2.0:User", "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User" ], }, "userName": "foo@bar.com" } 

What are the acceptable colour choices for single/multi selects in scripting?I've been creating new fields via a script and now I want to make a multi and single select, which is fine, I can do that much like so: await table.createFieldAsync("new", "multipleSelects", {choices:[{name:"test"}]}); But all the colours become grey and I'd like to specify the colour of the tag (or randomise it). I know there's a `colour` option for the array, but the documentation doesn't specify or give examples of what this should look like other than it being a string. I've tried using hex codes for colours, colour names etc., even the specific colour code of the default colours I can use, but I'm always getting this error message: j: Can't create field: invalid field config. Failed schema validation: <root>.options.choices.0.color does not match one of the possible values But I can't see anywhere that tells me what any of the "possible values" are!Can anyone help?Thanks

I’ve been trying to access the symbol of a currency field. However with no luck as my output returns undefined. I’ve been looking in the API reference and it seems the the field has who properties, symbol and precision. But how do I access the symbol value? const table = base.getTable('report'); let price = table.getField('price').symbol output.inspect(price) output.inspect(price[symbol])

This is a code that uses the Scryfall API to search for Magic the Gathering cards based on user input. The first line prompts the user to enter the name of the card they want to search for. The second line sends a request to the Scryfall API with the user's query, and the third line converts the response to JSON format.The code then checks if the API returned any search results. If there are no results, the code outputs "No results found." If there is only one result, the code creates a new record in a table called "Cards" in a service like Airtable with the card's information, and outputs a confirmation message. If there are multiple results, the code prompts the user to select the correct card from a list, and then creates a new record for that card in the "Cards" table.The issue arises when after the list of potential cards is loaded as search results, if it cant parse the card name it gives a bunch of options, no matter what option you choose, it wont actually add the choice as a r

In scripts we have input.buttonsAsync to create a n input button but if i would like to give a list with many options to choose from that is not very ideal. Is there any way to have a dropdown list (that is searchable & can have a default value)?On a side note is there also a way of having a radio button?

I released a custom extension I'd like to utilize in different bases within my own workspace. Is there any way to duplicate the extension in a different base without needing to create a new custom extension and re-lint it?

Around a month ago I discovered a discrepancy in the 5 requests per second per base rate limit when using an OAuth token.Executing this snippet with unique base ID's and a PAT results in success, executing the same snippet with an OAuth token results in a 429.I assumed maybe applying a global rate limit of 5 requests across per second across all bases would work but it didn't. For now I've settled on a global rate limit of 4 requests per second across all bases, it seems to work reliably.Airtable staff have confirmed that I'm running into an undocumented rate limit which can't yet be disclosed due to details not being finalised.Just wanted to share this to inform people and to find out whether others have encountered this.

Hey Folks, I am getting the following error when trying to access `v1/authorize` endpoint:```{"error": "invalid_request","error_description": "\\"code_challenge\\" must be a valid url-encoding of the the sha256 of the code_verifier variable generated (length 43, alphanumeric characters, \\"_\\", or \\"-\\"","state": "airtablebardello"}```The value of the code_challenge that I am sending to the server in that particular instance is "YjgwOGJjYTk5MGJjZTdjY2FjYjdkYmJjZDI1YzkxMGI5MDEwZDUxMzdlYjdhYmUwZDI0NWI0MWM5ODAzYjJiNw"Here is the full request modulo the client_id and redirect_uri: https://airtable.com/oauth2/v1/authorize?code_challenge_method=S256&state=airtablebardello&code_challenge=YjgwOGJjYTk5MGJjZTdjY2FjYjdkYmJjZDI1YzkxMGI5MDEwZDUxMzdlYjdhYmUwZDI0NWI0MWM5ODAzYjJiNw&client_id=xxx&response_type=code&redirect_uri=xxx&scope=data.records%3Aread+data.records%3Awrite+schema.bases%3Aread+schema.bases%3AwriteSpent quite a while but still couldn't figure out

Hi,I've registered an oAuth integration here and have given all permissions as seen in the below attached screenshot. I'm able to get the access token on the server side. The access token works for non metadata API calls. However when making metadata API calls like list bases or list tables, I'm getting the errorINVALID_PERMISSIONS_OR_MODEL_NOT_FOUND. I've tried with two different airtable accounts and through my application, terminal and postman as well. same result. Can you please help me resolve this problem? thank you! Error{"error": {"type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message": "Invalid permissions, or the requested model was not found. Check that your token has the required permissions and that the model names and/or ids are correct."}} oAuth integration config

I am looking to automate the assignment of people to call for my Airtable CRM - specifically I'd like an Automation to copy the first 20 records of my 'Hit Lister' Contact view and paste the contact names into the 'Touch Points' related table. Is there an automation or a script that could do this? I'm attaching a video below to better explain my use case:https://share.getcloudapp.com/DOukbKKKThank you!