Development & APIs

Hi, Is there a script that finds all errors in a specific table (or even better in the entire base) and then returns those error fields? That would help greatly with troubleshooting larger bases, so I don’t have to scroll through hundreds of fields looking for the red error sign when making larger changes.

I tried to search for this topic and could not find any answers. I am trying to know if it’s possible to create a search page and when that record is available, I can manipulate the layout of the result? I am using the pro plan.

We are using Airtable to support City activation of volunteer resources in the event of a disaster or other community-wide emergency. We have fiber optic loops around the city to critical locations. If the public internet goes down, we would like to have our Airtable data stored in our local servers, which have their own redundancy, security, and back-ups. Is this possible to arrange with Airtable?

Hello! this is my first time using the scripting block and first time trying to use an API with code (I’ve used lots of no-code tools in the past; Zapier, Integromat etc.) I want to use a text field in my base to create a ‘tag’ in Toggl using the Toggl api; The Toggl API documentation looks good, and I think I understand most of it, but I don’t know how to actually start - what is the first think I need to write? All the toggl examples start with ‘curl’ e.g. curl -v -u 1971800d4d82861d8f2c1651fea4d212:api_token \ -H "Content-Type: application/json" \ -d '{"time_entry":{"description":"New time entry","created_with":"API example code","start":"2012-02-12T15:35:47+02:00","duration":1200,"wid":31366}}' \ -X POST https://api.track.toggl.com/api/v8/time_entries Is this what I would paste into the script editor? I assume I need the toggle api url somewhere (

Hello, I have a script that I’d like to run as an automation when a record is updated but have been running into a problem when trying to update the record (specifically one field - “Conflict”) since it exceeds the 15 mutations per second limit… The records are screenings of films in various venues, across 10 days. The script is checking whether there is enough turnover time between the screenings at a single venue. If there is less than 55 mins, both records will get their Conflict field checked to notify the humans working on the scheduling. SlotIDs are ascending numbers unique to each scheduling slot and this is how I’ve been able to determine the time difference. The script does what we need it to do when run manually, inside apps. But turning it into an automation gives the error. I’ve narrowed down that it’s the for loop used for updating the records that’s causing it but don’t know how else to achieve the same result. I’ve also tried using a while

We have a requirement like below. e.g. Consider a table with column as Names. Names abc xyz abc pqr pqr We want two columns in another table as below. UniqueNames NamesCount abc 2 xyz 1 pqr 2 Is there any way to achieve this?

Hi All, This might be completely impossible but I’m trying to get rid of duplicate linked field values. Is there any way I could force it to do this via scripts? The dedupe app doesn’t quite do what I need it do and although this can be acheived via a rollup column, the values are now not linked. I know this isn’t a native feature so I’m trying to find a work around because I can’t generate neat pivot tables at the moment. Some advice would be much appreciated.

Hi I am trying to build an automation. When a record enters a view, I want to update another table for the linked record. For example: In Table A there is linked record to Table B. In Table A there is a field Field A. When a record enters a view in Table A, I would like to update Field B in Table B for the linked record with the data in Field A. I think I need to run a script to get the record id for the linked record because you can’t select a linked record as the Record ID in the Update Record function in an automation. I tried to just ‘Lookup’ the record ID of the linked record, but this does not seek to work either. I could use some help to get the record id of the linked record. Thoughts/assistance?

Dear airtable community, currently I’m using the “QR Code Maker” app in Airtable, which works great for me at this point. Now I want to take the next step and fully automate my process, by letting the app generate a qr code, without me manually having to confirm that procedure. As soon as a certain field is filled the qr code should be added to the chosen line. Since I couldn’t find this option straight in the app, I had a look into the automation category and noticed the custom script option. As far as I can assess this, I think that this is the best option. If there is another great solution to tackle my automated qr code creation, please be so kind and let me know, any help is highly appreciated Thanks in advance guys, take care and stay safe! Kind regards, Karim :slightly_smiling_face:

Hi all! I’m looking to use the URL Preview App to preview another bases’ record. I can successfully open the source record from another base, but I’m looking to preview that view and make edits within that preview window instead of being sent to that original record in a new window. Currently it’s not working when I select the URL field, I’m met with the “No Preview” message. I believe instead of choosing the option to Preview a URL (even though that’s what I want) I would actually need to be selecting the option to Run Script - but not sure what the build is for that custom option. Any help is much appreciated! Screengrabs of what is happening vs what I’d like possible attached.

For any Python developers here, I wanted to share the latest release of pyAirtable, a Python Client for the Airtable API. The library was previously called airtable-python-wrapper. This new release includes many new features, including a cool orm-style class, as well as new utilities like date conversions and a few formula helpers. Feel free to message me here or open a github issue if you have any suggestions or feedback. Contributions are welcome. Repo:

Input.fileAsync force change ID to Date. //read csv let latestStock = await input.fileAsync('Please CSV', { allowedFileTypes: ['.csv'], } ); console.log(latestStock); ↑It’s true ID"0002-3". But Date format. If Do you know resolve. Please teach me.

npm

I am trying to retrieve several records for which I know the ID but not the number of records: I tried to use Airtable’s search records but I don’t know how to fill in the Formula part : Can you help me ?

I need to monitor the use of the “Send email” automation action for many bases and over 100 users. Is it possible to use a script to create some kind of log of active automations? Or notify when an automation sending information outside of airtable is created or used?

Not sure why I keep getting an error message when I try to automate this script: I just need the first 5 digits of the Project code pasted into the 5 digit (linked) column. If it doesn’t already exist, it needs to create a new record. Help?

Hello, I am wondering if there is a way to set a timeout on an await call ? Essentially I have a script where the user is asked a yes / no question, if the user says yes the script continues, if they say no the script aborts gracefully. Upon aborting two functions are run to update statuses in my tables. However if the user does nothing, the script eventually timesout and aborts, and no “shutdown” functions are run. My question is the following: can I limit the await user input call to x number of seconds, so that upon timeout I can run my functions before ending the script ? Thanks in advance ! Best, Oscar

Hi, I have a table that I put numbers to all the columns daily. And I have a problem making a chart out of this. This table represents the visitor numbers of my website daily and I want to visualize the ratio of the visitor’s age group in total. columns are /Age 13-24 / Age 25-34 / Age 35-44 / Age 45-54 / Age 55-64 … Primary row is the date. I cannot figure out how I can make x-axis in chart same as my columns and show the sum of the everyday counts as y-axis?

Hi, any idea why is Vega-lite displaying the last month July 1 2022 of my table as the first month in my Chart, even before June 1 2021 ?!! this happen with whatever Date I start the table on. It looks like a Bug (in Vega or AT) to me, displaying the last month before the first one… Anyone facing the same issue, Thanks ! See code used { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Debug Test Chart ", "width": "container", "height": "container", "mark": "bar", "encoding": { "x": { "timeUnit": "month", "field": "DateTest", "type": "nominal", "sort": "x" }, "y": { "field": "VALUE", "type": "quantitative" }, "color": { "field": "NAME", "type": "nominal" } } }

I am trying to read formatted text from a rich text field via API. However, sometimes different text may result in the same Markdown representation. For example, each of the following four text snippets: ~a~ ~a~ ~a~ ~a~ is represented in an API response as ~~~a~~~. Is it possible to get the contents of a rich text field that can be decoded unambiguously?

I am attempting to create a simple script which will count the number of entries in a linked lookup field. My plan was to invoke .selectRecordAsync() on the table of interest to pull the records and count the number of entries for a given record in that field. I’ve run into an issue early on with this script: the selectRecordAsync call appears to only be returning the name field and Id for the records, but no other data. My code is below. let vendorTable=base.getTable("Vendors"); let quoteField=base.getTable("Vendors").getField("Quoted Parts") let records= await vendorTable.selectRecordsAsync() console.log(quoteField) console.log(records) let exampleValue=records[0].getCellValue(quoteField) console.log(exampleValue) I’m getting the following responses in the console.

I wanna delete cells-value in Amount Field. I am referring to this↓ Airtable

Hey guys. I wanted the Enterprise API and i have registered with a free account for now. But the Page says that the link says “Page not found”. Is there something i can do? or do i need to switch to the paid version to access it? Airtable

I have a simple script I’m trying to write, but since I’m new it’s not simple to me… LOL I have a junction table I’d like to automatically populate. In this example… I want to connect every bug with every home. So anytime a bug is added to the Bug Table, the junction table is updated to connect it with every home. Likewise, whenever a Home is created, the junction table is updated with every bug. Lastly, I want the script to clear any junction records if either a bug or home is deleted. I started with the script from this thread HERE, but just couldn’t figure out how to modify it to make it work. Lollipops for anyone who can help me! Thanks. :slightly_smiling_face:

My application has several Select components which the user can use to enter information. The first two fields have only a small number of options. The third field has over 70 options and can be tedious to use. I want to use the values selected in the first two Select components to filter the available options presented to the user in the third Select. The options in the third select are pulled from records in the base. These records have linked fields. Some of these linked field values are options chosen in the previous Select components. So, lets say I want to filter returned records from a table where values in a linked field (s) match either the record ID of string value in said linked field.