Development & APIs

Hi I wish that there where som stats on publicly shared views. But in terms of how many views but also downloads. Say I have a shared view with a lot of downloadable content. It would nice to get an idea of what content was downloaded.

Hi, I have read as many related posts as I can find about calling the API and filtering on field that is pulled from another table. I Can’t find a way to correctly form the API call to get the correct records. I have a table Articles that has a field “Customer” which is a “Link to Customer”. Customer has a “Customer Name” which is what is displayed in the Article table, but I also happy to search on the id if I have to. My API Call returns for example. customer: [“recjn4jFUGzYplO2N”] how do I filterByFormula to get only those with this customer. I have tried… filter_string=urllib.parse.quote(“filterByFormula=SEARCH(“recjn4j…lO2N”,ARRAYJOIN(Customer))”) filter_string = urllib.parse.quote(“filterByFormula=SEARCH(“recjn4j…lO2N”, {Customer})”) filter_string = urllib.parse.quote(“filterByFormula=SEARCH(“Customer Name”, {Customer})”) etc. I have everything working using Views and filtering by View on the API call, I simply want to

Hi everyone! My name is Taylor, I’m a new product manager at Airtable working on the Airtable platform. Super excited by all the work the team’s doing, and to work with and learn from everyone here. But first - a new block! Say you’re in a meeting with lots of topics to cover - Topic Timer lets you pick a Base collaborator as a moderator and shows a countdown timer to everyone currently in the base, and then when the timer’s up lets all active contributors vote for whether or not to continue discussing the topic. Click here to join the beta. Once you click that link, the “Topic Timer” block will be available in the list of blocks when you go to install a block. We’d love your feedback – please reply with thoughts and sugge

I’m accessing the Airtable API using a Python script below: import requests from pprint import pprint from airtable import Airtable base_key = 'BASE_KEY' table_name = 'Events List' api_key = 'API_KEY' airtable = Airtable(base_key, table_name, api_key) pages = airtable.get_iter(maxRecords=3, sort=["Date"]) for page in pages: for record in page: pprint(record) The above successfully retrieves the first 3 records in the table as follows: {'createdTime': '2020-08-15T10:04:49.000Z', 'fields': {'Date': '2020-08-15T19:00:00.000Z', 'Description': 'Lorem ipsum dolor sit amet,', 'ID': 20, 'Title': 'Proin laoreet facilisis cursus', 'URL': 'https://www.example1.com/'}, 'id': 'rec4oT3PiXXXXX9ph'} {'createdTime': '2020-08-15T10:05:50.000Z', 'fields': {'Date': '2020-08-15T20:00:00.000Z', 'Description': 'Pellentesque viverra gravida lectus', 'ID': 21,

Hi, would anybody know how to pass the second variable (airtableField) in below function? The third variable (shopifyId) is accepted! The purpose is to return just 1 record. Thanks in advance, Ronald let shopifyId = '2418417139848' checkAirtableId('Orders','Order id',shopifyId) function checkAirtableId(airtableBase,airtableField,shopifyId) { let recordFound = base(airtableBase).select({ filterByFormula: `${airtableField} = ${shopifyId}` }).firstPage(function(err,records) { if(err) { console.log(err); return; } return records[0] }) }

I want to access a airtable table through my app i’m making. I have the community airtable API installed into my project, but setting up the thing is a whole new task. I’m trying to add a new item to the table through the app currently. I don’t think the code is incorrect because I used it off the documentation of airtable visual studio api. Here In all the examples of how to use it, there are these two lines that are needed. readonly string baseId = YOUR_BASE_ID; readonly string appKey = YOUR_APP_KEY; I think i’m putting in the wrong numbers somehow. So I put my api key for my account in the second line and the base id for the specific sheet in the baseId line. Ex. const string baseId = "app********" const string appKey = "key********"

I have two tables: database & authorityMatrix . When a new record hits database, it has a field called: cost In the authorityMatrix, I have a table with names, emails, and approvalAmounts. The approvalAmounts are the highest Costs that person can approve. Basically I want to do a lookup on the authorityMatrix, and assign the appropriate approvingAuthority into the database based on the level they can approve. I imagine the evaluation would be something like: where authorityMatrix.approvalAmounts <= database.cost and lowestApprovalAuthority = ‘Yes’ This should insure that the lowest level person has already OK’d it to go up to the next level. If they are the FINAL approval, then I’d want to trigger a field that says Final … but that’s getting more advanced … haven’t though through that logic yet. Any help getting started would be greatly appreciated.

Non developer here. I think different flavors of what I’m trying to do have been asked in this forum, but nothing that’s quite a match. I’ve tried employing what I’ve found in the threads with some variations with no luck so far. What I’m trying to do is populate a blank column titled “Agency Talent” in my Agency table with linked records from my Talent Table. Eventually I want the field to be populated when there’s a match on two criteria (Agency match and skill category {e.g. IT, Operations, Engineering, etc.}), but I figured I would try to make it work on one critiera first to understand what scripting block was doing before adding the next layer of matching. The Agency names are under a column titled “Owner” in that table and are under a column titled “Employer” in the talent table. It seems that I’m not properly defining the "Name (Last,First)id; that is the name of the first column in the Talent table where I want to pull the linked record from. For some troubles

For anyone interested in a powershell interface module for AirTable, here you go… GitHub Zulton/AirTable-Powershell-Interface Contribute to AirTable-Powershell-Interface development by creating an account on GitHub. I am currently working on the readme and examples (I have a ton)

Hi all, Hope someone can help with this. I’d like to create/steal a script that will copy field1 into field2 in the same table They are both same data type (formula number into number field) and the script would run on automation everytime a record enters a view. Any ideas out there? I’m sure it’s simple if you know how. Cheers for your help. Matt

Hey I am working on an app that uses the Airtable API to upload and download data, and I need to roll up a filtered set of records to put that list into a new record field. Essentially I’m looking for a way to enter a field name in the filtering options rather than a static value.

Looking at this issue regarding sending ‘single’ message using scriptiing block which was resolved by @Mike_Pennisi i was wondering if we could also be able to using script block/ Twilio to calculate how much it will cost to send a certain SMS to a number of users? Also a way to get the budget per group or assigned group. And lastly using script block calculate the total cost and and enable/disable the sending according to the actual budget. Has anyone worked on something similar ? or found a hack around this…

Hi airtable team, I am using the current iOS 14 Beta and was wondering whether you are planning on building widgets for the app. I think That would be great. Best regards

Similar to the input field used for the Description block. I’m not a developer, but can smash some available code together. I’m wanting to make something similar to the URL preview block, but instead loads a Long Text input (like Description Block) so that we can view/update a Notes field while still having the record list visible. I could use CellRender to get a non-editable Long Text field to display… but I’d love to be able to update (in the block demo’s, similar to the Todo list block).

Hi, Im trying to build a custom front-end on top of the Airtable base. There will be a number of users that can view and update the data-tables via the front-end. Currently, I only have one API key (which is linked to my account) which is what the front-end uses to connect to the Airtable backend. What’s the best way of creating multi-user support that would be consistent with multi-user setup in Airtable? For instance, if I create/update a record via the API – it lists my user-id as the “creator” (regardless of who actually uses the front-end). Do I have to have each user setup an API key for themselves in AirTable and then store it in their user profile? Is there a cleaner/easier way?

Hey folks, I’m working on a scripting action step for an Automation. It feels like querying the whole table just to search through the records is inefficient. I’m a frequent user of the Airtable API and am very used to simply asking for the record object by its ID. Can I make this simpler? I’m literally only trying to retrieve the field values of records that are linked to the record which triggered the automation. The Automation builder UI doesn’t allow for “looking up” fields from linked records. // Get collaborator email from Client record. let clients_table = base.getTable("Clients"); let queryResult = await clients_table.selectRecordsAsync(); // get all records in Clients table let client_record = queryResult.getRecord(`${inputConfig.client_id}`) // find the one with the client_id from input output.set("am", client_record.getCellValue("Account Manager").email) // Get Site record linked to the Project record let projects_table = base.getTable

I am using curl via command line to try to isolate a single record ID from a list of records retrieved via GET. I only have data from one of the fields in the record (ie: “File Name”:“MyFile.txt”), I do not know what the record ID is for this record. The intent is to isolate and use this record ID to perform another GET which just contains the data from the corresponding record. What is the best way to go about isolating a record ID via curl/ command line? Or maybe there is a way to isolate the entire single record from the list instead of using the record ID to do another GET?

I am working on an automation. Is there a way to have the script select only the record that triggered the automation. I am trying to create a ‘Project Number’. When a new record is added I want to run some script to give it a project number based on some actions (including grabbing some info from another table). Once I have that data I want to use to update the Project Number field, how do I get the script to select the record that started the automation? I see now that I can include a variable from the trigger step. what is the syntax to use this variable to update a field in that record?

Hi! I am new to scripting and thought this would be easy but I’m not getting it… I have one table, and want to find all the records that have the minimum value for FieldA (there could be multiple). I actually want to find all the records that have the minimum value for FieldA, and then out of those the ones that have the max for FieldB, and then add those records to the latest row in another table as a linked record. But for now I’d be happy just figuring out how to find the min value for FieldA :slightly_smiling_face:

Using the new automations feature, I am trying to trigger an Integromat webhook when a new record enters a view. However even though I have configured an input variable, and it is processing just fine, it won’t parse into the webhook URL. I’ve attached some screenshots which hopefully explain what I mean. The code I’m using is: let data = input.config(); let response = await fetch('WEBHOOKURL?id=${data.ID}'); console.log(await response.text()); The test output shows the variable is picked up: However the webhook receives only the code: Would love some help - I’m sure I’m missing something very simple here…

I’d like to use the autoComplete property on an Input in my custom block. Has anyone played around with styling an Airtable-y popup to go along with the feature?

I am quite new to airtable and looking to make an order form for work. The data will be coming from an API of a materials company. What is the best way to add this data to airtable?

I have encoded api from codepen and got this https://api.airtable.com/v0/appdsdsknfsf/Quiz?maxRecords=10&pageSize=1 and i used it with ?api_key=YOUR_API_KEY , it shows error please help me to solve it.

Hi, so I went to https://airtable.com/api and I can’t spot the documentation anymore. Where is it now? Thanks PS: attached an image

I have a table that gets a partly populated row via IFTTT at the end of a 3D print job. The table has a script block that parses information out of the supplied data to fill in other fields in each row (quantity, object printed, material type). I want to use this to track the output of a distributed print farm making PPE. My question is whether there is any way to periodically trigger the script to run either internally or via some external tool like Zapier. All the external tools I’ve found only seem to create/delete/edit records and it doesn’t seem like internal script triggers are supported yet. Thanks!