Development & APIs

Is there a way to know the IP of my airtable account. I want to call an API from airtable using Zapier automation. The third party needs to whitelist my IP so that i can call the API. Any help is appreciated.

I did some searching but wanted to be certain since I’m still relatively new to the scripting block. Does anyone know if there is a way to create new views? My use case is that I currently manually create a suite of views each time I add a new client and/or project. For every project I will have an All view that shows everything about it, then an Open view that only shows stuff that’s currently being worked on, an Invoice view that gives me a summary of the tasks that need to be invoiced to make my invoicing faster, etc. Currently I have template views that I duplicate and update the related filters to have it show the right records. I’d love to automate this with the scripting block, but I don’t see a way to create new views from script. Am I missing something? Anyone else have any ideas? Thanks!

Hello, I am testing Airtable Api, and I see that no matter in which table the record is, the record get, update and delete methods work normally)Example:I have a record just in "movies" table, but even if I write the id or name of another table "blog" in api url, it still returns the record, you can also update and delete.Get https://api.airtable.com/v0/<app_id>/Movies/recY7Ho4bq4RM94XX/Get https://api.airtable.com/v0/<app_id>/Blog/recY7Ho4bq4RM94XX/They return the same elementIs this how it should work, or it is a bug?

The form builder allows the creation of groups of fields which are separated by a horizontal rule on the form.Is there a way to control visibility of the entire group, including the horizontal rule, rather than controlling visibility of individual fields within the group?Assuming the answer is no, is there a way to disable the extraneous horizontal rule when none of the fields in the group are visible?Thanks!

I'm trying to determine from the API whether a table is hidden or shown, but looking at https://airtable.com/developers/web/api/model/table-model there's no obvious field with that information. Is there another API that has it?

Created a simple form to submit a work order for repair services. User selects services needed from multi-select field. What is the best way to extract the services and create a line item for each service selected so that I can auto populate an estimate in quickbooks?I was thinking about creating a new table called "billable items" and have a script run when the form is submitted to create a line item for each invoice while still including the customer information submitted on the form in each line item.  Example Form SubmittedAirtable record createdscript runs creating 1 record per service requested in a separate tableeach line sent to QB for estimate creation Will this work? Im not sure the simple zap will be able to dynamically adjust to different amount of line items. One work around for this was thinking I could have a new "view" auto created for the billable line items that need to g

Hi!I am working on a small script thats generate a XLSX file from an airtable base.I stucked at when I want to download a file. Is there any solution to download from the extension section and not from an attachment field?Thank you for any help!

I believe I noticed a discrepancy on the documentation for updating a record.The returnFieldsByFieldId parameter is not specified as being an option on the Request Body, but it is mentioned in the Response Format section. It's also mentioned in the description for the endpoint too.Unfortunately, this parameter is not currently supported when updating a record, however I would love it if it were!!See this screenshot: Please consider adding supp

Hey everybody, I'm building a script using Airtable Scripting and I'm looking to reference/extract/use the contents of files in a file attachment field I have. If it matters, these files are mostly PDFs, and my field may contain more than one. I want to take the contents of the file, or in cases of multiple each file, and include that in the payload of a REST API call. Right now, I am totally unable to get to the contents of the file itself in Airtable Scripting.Has somebody done this before? Could you please help out?Best,Cam

HelloI am developing a Airtable Script and I am looking for extracting actual file object which is part of the attachment field in a table. I got the object using record.getCellValue("Attachment field"). This object has information like URL, Filename, MIME etc. But what I am looking for is to extract the actual object in the attachment field (this could be a JPG, TXT,PDF,video etc). I need to pass this object to be stored in the target system through API (Dropbox API). The upload API in the target is looking for an object which is stored in local system. As the object is in Airtable I am not sure how this can be passed to API.The API call is some thing like below-----------------------------------------------------------------------------------------------let dropboxEndpoint =

I changed a column in Airtable from text to a checkbox (I am filling in with TRUE/FALSE (all caps)). Now I get this when I try to insert: data: { error: { type: 'INVALID_VALUE_FOR_COLUMN', message: 'Field "Active" cannot accept the provided value' } } I have seen articles saying to add: "typecast": true but this does not work. I’m not sure that I’m adding after the right curly bracket, as none of the articles I read are explicit on this, other than ‘add “typecase”: true’ somewhere. I don’t know whether to add it after each fields entry like so, or somewhere else? { "fields": { "key": "value", "key": "value" }, "typecast": true }, It is obviously being added in the wrong place, I am getting: data: { error: { type: 'INVALID_REQUEST_BODY',

I'm trying to avoid having to add a view for each new coach in a coaching engagements base.  The filtered URL works beautifully in a browser, but when I add it to the embed code in the iframe, it gives me the airtable.com refused to connect message.<iframe class="airtable-embed" src="https://airtable.com/appNTRWwuGJYQDcYK/shrPcWPXGkhHeb30F/tbl38pqjIpX(rest of code hidden for privacy)&filterContains_Engagement=(First Name)+(Last Name)&filterIsAnyOf_Status=In+progress&filterIsAnyOf_Status=Awaiting+SOW&filterIsAnyOf_Status=Assigned&backgroundColor=blue&viewControls=off" frameborder="0" onmousewheel="" width="100%" height="1000" style="background: transparent; border: 1px solid #ccc;"></iframe>

Can a Salesforce Integration be Done Via API? I can’t stand using Salesforce and due to acquisition, our company has multiple instances, which screws up data integrity. I’m using Airtable on the side to clean up records but would love to be able to pull in fields form Salesforce or publish new data back to Salesforce.

I can't get Block SDK to work with Personal Access Tokens. It doesn't accept the format and returns...Error: ❌ Invalid Airtable API key specified. Make sure you copied it correctly from airtable.com/account.Code: airtableApiKeyMalformed@Olafur_Petursso: I saw your post from a few weeks ago and adding the secret key seemed to work for you. You do mean this key, correct?Any help is highly appreciated!  

If you have a many-to-many relationship, chances are you have a junction table. And chances are, setting up and maintaining that junction table is probably…not your typical idea of a fun time. Welp, now it can be! Thanks to some serious help from @Stephen_Suen, we figured out how a script could help us automate this process. In the below example I have a list of projects, and for each project I’ve assigned multiple companies to it. I also have another table named “Tracking” where I track all the details related to a specific project-company pair. Previously to create that junction, I had to do a lot of finagling, which took a fair bit of time. However, with a script, I can automatically c

I have an automation script that searches a table for a matching record. Based on the examples I could find, I wrote it to retrieve that column from all the rows using selectRecordsAsync(), and then loop through all the rows looking for a match. But this sometimes times out after 30 seconds. The table has about 1800 rows.Is there some way from a script to get the lookup done on the server side, e.g. by passing in a formula? I was able to do this easily in make.com using the airtable search action and a formula, but it seems like there should be a way to do this in airtable itself.  

I have an automation that uploads attachments to OneDrive, then adds them to Airtable with their publically accessible URL.  This has worked for for well over 2 years, and a few months ago, randomly stopped with no changes on my end.  No errors get thrown anywhere, and we can actually see an attachment pop in for a second in Airtable and then clear out.  The revision log appears to show me adding the attachment, then deleting it. After weeks of forking around and thinking I was going crazy, I stumbled upon another form post and Lo!  'tis apparently a

I have a public readonly table with many links. When I click on any link, a "leave airtable" modal window opens. When I try to click on the "continue" button, the window just closes. Because of this, I can't use my table

The public api returns a very limited set of attributes in the list and get endpoints for bases and records, such as who to attribute creates and updates to. This would be very useful information to include in the api response so that third party apps can attribute Airtable records / bases to their authors. Currently record comments are the only thing to reference a user.Even at the enterprise level, the audit logs have some limited user information on creates and updates to bases, but nothing around records.

How to export Table into MYSQL table file or CSV?Can be synced table from Google Sheet into MYSQL?

I am currently trying to set up the Google Cloud Vision API via an extension in Airtable. When adding the API key, I am currently getting the following error:'Cloud Vision API is not enabled. Enable the API.'However, I have followed all the steps required for the API to work:1. Created a Google Cloud project 2. Set up billing 3. Enabled the Google Cloud Vision API, added it to my project and generated an API key.I am still getting the error message despite having disabled and enabled again, removed and re-added the extension and deleted and re-created an API key.I would be grateful for any additional suggestions regarding how I can add this extension.Many thanks,Jamie

Dear Airtable lovers, could you suggest me how to create a simple Alfred App search workflow for simple searching of defined base? More about Alfred workflows: https://www.alfredapp.com/help/workflows/. Thanks!

Hello Community,I am new to airtable. I have already created different tables in airtable database. Now I want to add data in airtable from outside using python script and later I want to update certain airtable data. So is there any way we can do it ? I am new so any blogs or threads which provides answer to this will be helpful. Regards,Viraj 

Can the buttonAsync be created dynamically? I have an array of Order Numbers called filteredOrderNames. Can each value of the array serve as the button label? let selectedOrder = await input.buttonsAsync( 'Select Order Group from List below', [ {label: filteredOrdersNames, value: filteredOrders} ]);

Hey there,The "Insights" tab in our base is so useful for clean-up, and one of my favorite features is when it tells us which views in our base haven't been accessed for 90+ days. We're doing a base audit to clean things up, and we want to go through all of our views in a slightly more programmatic way. From the API docs, it looks like the metadata we can pull about a view doesn't contain its "last accessed" date, or anything like that:The only way I could think of to access this data would be to pull our Enterprise logs, search by view ID, and then grab the most recent date stamp for each access. That seems like a rather painful workaround, and since the data is already packaged so nicely in the insights tab, I was wondering if there's a workaround anybody knows of to grab it more quickly without having to do a brute force search. TIA!