Development & APIs

Has anyone retrieved data from multiple tables via the api? I can retrieve one set from one table no problem and I know how to to do this in SQL for muliple inner or outer joins but I have a little bit of a block doing this in node.js using the api. Thank you

Hey all is Airtable able to do what JotForm does? Not wanting another solution if I can make it work with Airtable? jotform.com Online Form Builder & Form Creator | JotForm Dropbox File Request: How can someone upload to my Dropbox? I basically just need to have a form my website that allows them to input info and upload the files to dropbox just like jotform says it can do.

how to return the values ​​of a related table, not the key, I try to do this from the javascrip api, what i have is this: const response = await airtablePlanes.list(); and he answers me: [ { “id”:“recJhPPsonGK6WQiO”, “fields”:{ “valor_mensual”:4569, “Name”:“PLAN_4”, “planesToCoberturas”:[ “recGBXvrvXt6KhatT”, “reckjMfRzp6jnHEED”, “recCFBaAfBirzw6V3”, “recg1TjYd6ekRHXqJ”, “recM04lVdWj2CDIeI” ], “descripcion”:"Plan 4 ", “valor_anual”:54825 }, “createdTime”:“2020-04-08T22:25:48.000Z” }, { “id”:“recZQkZ6hI62FqvJ0”, “fields”:{ “valor_mensual”:1286, “Name”:“PLAN_1”, “planesToCoberturas”:[ “reczIR8pPZBAJdSsM”, “recH0CU0TqA9cfiFg”, “receQ9xxWZqrtd2V9”, “recG7E3gux8diAm2D”, “recSsWKkZTCda0kab” ], “descripcion”:“Plan 1”, “valor_anual”:15431, “registros”:[ “recovGEbYXVD3ISb3” ] }, “createdTime”:“2020-04-08T22:24:27.000Z” }, { “id”:“recpDt0xL5yDPcrec”, “fields”:{ “valor_mensual”:2380, “Name”:“PLAN_2”, “planesToCoberturas”:[ “rec9zIsScaSyFwTc0”, “recRFqypir5CyMG9z”, “recNIguFd32J9H5ma”, “recDNT4YUm

Hi, How can we use an Oracle SOAP Service to populate data with an attachment to a table type base created in AIRTABLE? I see you have API examples to create a record in the table by passing the data elements but is there a way we can call an external webservice and populate data? Any help much appreciated! Thanks, SJ

Dear Airtable scripting community, is it possible to share commonly used functions between different blocks of the same database? Currently I use different script blocks for different purposes and would like to avoid duplicating code between them. Is there a way to achieve that? Thanks, Stefan

Hi, I would love to be able to use Cursor model to move the currently selected cell. My use case is to help users find linked records. So here, when the user click on a Record Card, instead of expanding the record, they will be redirected to it. I already send the user to the correct table and update the Block to show the detail of the clicked record, but it will be helpful to select the right cell in the table view. Thanks,

I found a somewhat similar thread in the Support forum (Reordering Link to Another Table column items), however I think this is substantively different. If I were to ask a user to manually order linked records by some criteria, they would intuitively place the “first” records at the top (or left) because that’s visually “first”. However, when fetching results via a formula or via the API the first record returned in the array is the “bottom” or “right” most record—what I think is the “last” record. I understand that the newest record entered “pushes” the other records down/over. I don’t really have an issue with that. It’s just that I can’t think of any reason why the formula/API would show the last record first.

hi, i have this php code. i want to filter the fields to be retrieved to only 2 fields as ‘Registration No.1’ and ‘Registration No.2’. However i cannot get it to work. Here is my array: $params = array( “filterByFormula” => “AND({Email Address}=‘xristos@skyworx.com.cy’)”, “fields” => [{Registration No.1}, {Registration No.2}], “view” => “Registration Application”, ); Can u heklp me out?

This is my code and I can’t populate the field ‘Activities’ which is linked to another table, the error is in line 24

good day! I am looking for a best practice in Airtable for preferrable a Calculation that will write out the long form of an amount, such as is written on a check up to $1,000,000,000.00. I may also be looking to hire a developer to write such a statement. I had done it previously in Filemaker but I’m overloaded with conversion to Airtable and not sure how to handle effectively. Thank you in advance, Ray

Hello I’m trying to write a script that would copy all records from one tab to another. Source tab is called “Activity” and the destination is called "Contacts I think I’m almost there, but confounded on a few things. The script cycles through each record in both tables to: Make sure the emails contact email matches It hasn’t already copied before, dropdown in sync column set to “added to contact” Later will add the values to copy from activity to contact I’m seem to be almost there, but here’s somethings are confusing me it seems to be looping through the activities multiple times even though activity only has one loop, why? It CRASHES when I try to write the Contact Record column in the Activity table. Says “Something went wrong. Reload the block” The update contact part does not work, nothing gets written to the contact table. // Test let contactsTbl = base.getTable(“Contacts”); let activityTbl = base.getTable(“Activity”); let activities = await activityTbl.selectRecordsAsy

I have a formula that calculate’s a person’s age. The problem that I’m having is that when information is entered for ‘Died’, nothing is entered for 'Age of Death’.![Actors|690x225] What can I do to correct this?

Hello there! I was trying to create an filter that acts like this SQL: SELECT * FROM table t WHERE t.Status = “Pending” AND t.Name == “Robert” AND … (and so on…). How can I translate that to Airtable Filter By Formula in the API? I just want to return the records that match those conditions. Using airtable.js to do it.

I’m using the API to update an Airtable table on a daily basis. Everyday I’d get around 100 records to be updates or created on the table. What’s the best way to tell Airtable to either update the record if a specific field matches a record which already exists otherwise create a new one? Do I need to perform a search for each one of the records manually or is there a better way to do that? Thanks!

Hi community. I’m very new to JS so apologies if this seems basic :pray: . I’m using Twilio Functions (node.js) to load to AirTable all incoming texts. I’m utilizing 2 tables - “Receive Text” with columns Text date, Text Body and UID. “Users” with columns UID and Phone Number (and a bunch of others). When a text comes in, I’m trying to use FilterByFormula with the phone number to retrieve the user’s UID from the “Users” table. Here’s the code I’m running - var filter = "({Phone Number} = '" + event.From + "')"; base('Users').select({ filterByFormula: filter }).eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { console.log('Retrieved ', record.get('UID')); alert('Retrieved ', record.get('UID')); }); fetchNextPage(); }, function done(error) { console.log(error); }); let message = { "UID" : record.get('UID'), "Phone Number" : format_phone, "Inbound Text Date" : Date.now(), "Inbound Text Content" : ev

Hi all, I was wondering if there was a way to link records with the Airtable API?

I wish Parabola had an Airtable export feature, but in the meantime, I’m struggling with the code to allow me to create records in Airtable with multiple associated linked records. I got it to work when there is only a single linked record in a field, but I keep receiving a 422 error code saying “invalid record id” whenever there are multiple linked records. The record ids going into {id (1) (concat)} below are a comma separated string (i.e. recXXXXYYYZZZ, recAAAABBBBCCCC). The code I’m using is below. Thanks for any help that you can provide. { "fields": { "Client": ["{id}"], "Timesheet Items": ["{id (1) (concat)}"] } }

Does it copy the entire source directory to a base or only the built output?

I’d like to prompt the user for the password to an API call but input.textAsync displays the input in plain text on the screen. Is there a way to mask the input so it shows as ********** when the user is typing? Like with HTML input type=password?

I’m seeing this error today in my custom block, but don’t think that I’ve changed anything dramatically in my code. Can someone tell me the fix? Thanks.

Hello, I have been working towards mapping some CSVs into one of my bases using the Scripting Block. Since I’m new to JavaScript, I’ve been using a lot of the documentation within the Scripting Block, which has been super helpful for what I need. One issue I have run into is during the mapping process, where I’m mapping the fields in my Base to the fields within my CSV. The format of mapping a field for me generally looks like this: data.FieldName Where “data” represents the parsed contents of my file and “FieldName” represents the name of the field within that file. My issue is that, in some of the files I would like to use, there are special characters and spaces within the names of the fields. Meaning I would like have a mapping that might look something like this: data.Field Name # For spaces, I attempted to use underscores but wasn’t able to get that to work. When using a special character like # or /, I get errors thrown by the script. From my understanding, I believe this mapp

I am attempting to map a csv file to one of my bases via scripting due to some pre-processing I would like to do, however, I began running into issues with parsing. Figuring that I had made a mistake I created a new script to test a more simple csv with state names and regions essentially hoping I could troubleshoot on my own. This is the output table I get with an csv I upload: And here’s the script I’m using: // Prompt for a file upload let csvFileResult = await input.fileAsync( 'Upload a CSV file', {allowedFileTypes: ['.csv'], hasHeaderRow: true} ); //Display table w/ parsed contents let csvRows = csvFileResult.parsedContents; output.table(csvRows) I’ve been looking at the spreadsheet importer example and the documentation within the block but have had no luck thus far, any help would be much appreciated. Thank you, Sam

Has anyone found a javascript chart library that they like, that also works with React? I’m assuming that is one of the requirements as I seem to have struck out using d3.js inside my simple example. Really excited to create a richer charting block, if I can only find the right library. Thanks!

Hello all, We just launched a website to help small independant shops to sell gift cards during the covid19 crisis. Every week, we send them the list of their clients orders via Airtable. Today, I put all the orders in one table, then filter one by one the orders for each merchant and create manually a new table for each merchant where I paste the filtered orders. Can we create these new tables automatically ? A script or formula would have to filter each merchant and create tabs accordingly. Can we update these tables automatically ? A big thank you, we really need help, this project is volunteer and we already help 3000 small shops in France ! Jonathan

Hello, I know there is an API limit of 5req/s to query AirTable. What about Attachments’ URL ? Can I directly use a link to the attachment’s URL ? is there a secret/token in the URL that should not be displayed ? Is there a cache mechanism on AirTable side ? Or should I download and cache the attachment ?