Development & APIs

Hello! We use a simple bid and job numbering system to create new bid and job numbers, and we have a table in a base where we input a new record for each new bid and job. Is it possible to have the scripting app do this for us automatically (or after clicking a button or run)? The recipe for bids and jobs is as follows: XYY.MM#.### where: X is 5 for jobs, and 4 for bids YY is the 2 digit year such as 20 for 2020 MM is the 2 digit month, such as 09 for September and #.### is a running counter of the respective bids or jobs that we have, such as 3232 for bids or 6933 for jobs. Here are two examples: 520.096.933 is a job that was created in September 2020 and is the 6,933rd job that we have ever created. Is this possible to do with a script?

Hey there! I’m trying to create my first custom app, but I’m running into this error when trying to initialise it: I’m running this command (copied from the “Get started” flow of creating anew custom app: block init appql2cWuSDIYP4pk/blk5ErqYl4U45VObE --template=https://github.com/Airtable/apps-update-records MY_APP I get this error: No valid exports main found for '/Users/ME/.nvm/versions/node/v13.4.0/lib/node_modules/@airtable/blocks-cli/node_modules/@octokit/endpoint/node_modules/is-plain-object' I’ve already updated npm to the latest version and I also installed octokid/rest, since I thought it had something to do with it. Does someone know how I can get past this hurdle? Thanks! Oli

Hi, I have a table of orders, with their value in $. I wanted to create a dashboard that will show the current sum of the orders vs. a goal. Since there is no (as far as i found) a way to do that with the current apps, i thought of using a script. Can someone share an example of a formula that will calculate the sum of raws in the tables and then will take a # and reduce that sum from it? Thanks

Make is the vastly superior platform to Zapier.I have written up a post on Make vs. Zapier here:https://air.tableforums.com/t/make-vs-zapier/737

steps to reproduce: 1 create a synched table, say Users and create one user 2 in another db add the synched User table 3 create a table, say Exam, that has a field that links to the user 4 verify that you can, from the Exam table, link a user from the synched table 5 from the API call the create method on the Exam table with the field user : [ user-rec-id ] 6 notice you receive an error 422 ‘Record ID user-rec-id does not exist’ expected result: You should be able to create an Exam record from the API with a user linked to the synched User table

Hello everyone, I’m new here. I got an error after I issued the command: block release :x: Error: :x: The base could not be found. Make sure you have access to the base in which this block was created. I have a Creator permission to the base. No problem encountered during development after “block run” command is issued. The custom app can successfully create a new table during testing. But when I issued the command “block release”, the error occurred. Is there anything I missed? block --version 0.0.59 node --version v12.18.3 npm --version 6.14.6 Thank you in advanced.

This question is in continuation of the question I asked here: How to have a script that keeps running in the background or automatically run when i open the table?

Hi, I’m looking to create a custom view from a table that will display a summary of data for each month. Firstly, I want to select only rows from Table A where the Table B field has the value “Example Value”. Then, I want to calculate certain sums based on subsets of the “Example Value” rows: I want to calculate a “i.e Staff Hours” value for the given month, which is the sum of “hours” multiplied by 8 multiplied by the number of business days in that month. I also want a “i.e Work Hours” field, which is found by taking the sum of hours for rows whose “i.e Work Status” field is not “i.e Full-Time Employee”. I also want a “i.e Senior Staff Hours” field, which is calculated by summing hours for “Table A” where the “i.e Proficiency Level” of Table B is 4, then multiplying by 8, and then multiplying by the number of business days in that month. Is there a way to do a custom view instead of making a script?

Is there a way to use API commands search for a base? Is there a way to use API commands to create a new base from an existing base?

Hey I wanted to automate the process of fetching files from URLs and putting them in a Attachment filed. I found a script to do so at: Setting Attachment URL dynamically Ask the community Hello there, newish to AT, i wonder is there a way to set the URL of the attachment field dynamica

I wish to find an integer between 1 & 5 in a number field and replace it with a zero (0). The example script gives an error message: “TypeError: originalValue.replace is not a function at main on line 20” I have never programmed a Java script! Please help.

I Want to see the results of all the records in various tables in various bases inside a ‘summary table’ where the status = followup. But I don’t want to click any button to run the script, it should autorun it when I open this summary’ table. How can i make it happen ? With set Timeout or is there a function that will auto run when i open a table ?

So I want more control over a CSV import…what if I don’t want to import all records? What if I want to “rollup” records. Like hypothetically, if I had a say a bunch of transactions on Wednesday but in the CSV each transaction was individual, with a date (Wednesday), amount and location…is there a way to program in javascript to essentially “rollup” all those transactions so I write to airtable a single record, with the date of that record, a total amount from all the records with that date and a field with the locations. Is that possible or should I just build a whole other table to do the rollup? Seems like a time consuming extra step that I could just program in and skip an extra table and time rolling it up. At very least is there a way to “limit” what gets imported?

I can’t seem to release a block that’s based on the unmodified Url Preview example block code. I literally just ran: block init [id] --template=https://github.com/Airtable/blocks-url-preview google_drive_preview “block run” works fine. But when I try to run “block release” here’s what I get: scotty:google_drive_preview scotty$ block release building copying package.json file copying package-lock.json file installing node modules [npm] [npm] > core-js@3.6.5 postinstall /private/var/folders/xb/yhygdpg55d734fcsckghy__m0000gn/T/airtableBlocks/build/1590085769112/transpiled/user/node_modules/core-js [npm] > node -e “try{require(’./postinstall’)}catch(e){}” [npm] [npm] added 78 packages in 1.701s Error: :x: added 78 packages in 1.701s Failed to build the block code!

Hi everyone! I have a particular situation where I’m trying to link several records from a view in one table to a specific view in another. I did some research from pre-existing articles–mainly this one–but I have a couple wrinkles for my script and don’t have the knowledge to make it happen: I work for a non-profit where volunteers go online to write encouraging notes to authors who have sent digital stories to us. In this example base, you’ll see that I have one table for the digital stories, one table for the volunteer events, and one for the companies we work with. Here are the complications: 1) I don’t want to “pack” any stories that were assigned to the same company from a previous event. 2) I want to assign a certain # of stories to the event based on number of attendees. So the script would count the number of attendees, multiply tha

We use Airtable as a back-end for many of our major systems. A big part of these systems is the use of scripting apps in order to streamline many of our processes. We have one system to track shipments. We get data in at the end of our day and someone will upload that data into one of our bases. From here, we run a series of scripts that scrubs and processes the shipping data since much of it can come in very raw. I was in the process of working on one of these script today when all the sudden I was thrown the error “You can only send 15 mutations every 1000ms”. Now, I haven’t made any changes to these scripts today and have never seen this error prior to today. The issue is that we process large amounts of data and while putting an ‘await’, which we don’t normally do, in front of an ‘updateRecordsAsync’ function will allow the script to work, it takes us from a process that used to take 5 minutes to one that takes ~30 and potentially ruins our entire decision to move

I’ve successfully applied both those conditions distinctly: filterByFormula: {customerOwnerRef} = '' filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}') But I don’t understand how to make a logical OR between both conditions, I tried the following but it fails with INVALID_FILTER_BY_FORMULA error: filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}' OR({customerOwnerRef} = '')

I know there has been lots of discussion about Airtable Apps regarding API keys and the best way to store them—I believe the current recommendation is still in globalConfig. My request is about Airtable’s own API keys in particular. It would be great if a Custom App was able to access the current user’s Airtable API key via a new readonly field in their CollaboratorData. When accessed via the App’s Session, this could really help with customizing the app per user and ensure any API calls they make are tied to their Airtable account. I don’t think this is currently possible, but I’d be curious to see if others would find this helpful as well?

Hi! I understand that the API has a rate limit of 5 requests/second per base, and I’m open to creating a database to cache the retrieved data to account for a potentially higher read volume, as recommended in the API documentation, but I just wanted to ask whether there are any other limits/caps on the number of total requests per, say, day. Thank you!

The following request works as expected: https://api.airtable.com/v0/appD1JKW7PlQhRMrF/Docentes?fields=Email&fields=Status But this one fails with status 422 Unprocessable Entity: https://api.airtable.com/v0/appD1JKW7PlQhRMrF/Docentes?fields=Email The response is: {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}}

Hi Airtable, I would like to automatically retrieve historical exchange rate data from this website secure.mas.gov.sg Monetary Authority of Singapore Any kind folks can help me?

I have an app in G Suite that uses a trigger script from a spreadsheet to create a set of record-associated Google Docs, and retain their URLs within spreadsheet cells. This is done in the background, as a trigger. Can I access the Google Docs API to enable such a function, and how would I enable it as a trigger, similar to a trigger from a Google Sheet? Sorry if this sounds basic, I am just starting with Air Table. Much tighter and somewhat more intuitive than G Suite.

Hi all Is there a way to retrieve or update a record’s activity/comments using the API? I’d be keen to hear about any attempts at doing this. Thanks! Alex

Hi, I have a formula field that has long SWITCH statement and I want to modify this formula dynamically in backend. Is there a way to achieve this?