Development & APIs

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 troubleshooting I’ve trie

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("Projects"); let projectQueryResult =

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!

I’m not great with Scripting, but I can struggle my way through sometimes. I’m trying to get the day of the week from a Date field type. Any suggestions on how to accomplish this? Thanks!

Hi Airtable community, I’m just wondering if anyone succeeded to connect Airtable API with UI Bakery (nocode UI builder)? All the HTTP requests I’ve made fails and I can’t find why. Thanks for your feedback.

Hi Airtable Community, I’m running a boutique Headhunting Practice, and am a recent convert to Airtable as central tool for Recruiting (Candidate DB), Marketing (Prospective Client/Candidate DB), and Sales (Client & Deal DB). That said, I see an awesome opportunity for someone who’d like to upgrade the Email <-> Airtable workflow and overall CRM-like functionality of the platform. Sales & Recruiting is a communication business -> everything revolves around the messages coming into your inbox, and being able to process them quickly, while noting what you did so you can know where you’re at with a pipeline of 500+ candidates and 50+ potential clients. Being able to operate from Gmail without having to switch between windows to the CRM (Airtable) to edit and update contacts is a big time saver. Time is money. My favorite CRMs in the past generally have had a Gmail integration. Usually, it looks like a pane that pops up inside Gmail on the right-hand side of the screen. It

Are items in an Airtable view that is embedded in a website searchable by search engines (such as Google)?

Hi I have 3 tables and I created a script that fill some columns across the first table with data from the others two tables (it is a kind of manually link). It works fine. So now I created an automation to run this script when a record is created in the first table. But it is getting too long because my script run across all record. For the script used in automations, I would like to run my code just for the new record. So is there a way to get just the new record that triggered the automation to avoid run the code for all record of table every time?

How can I do to get data from a specific view as a Restful API in Airtable?