Development & APIs

Hello! I have a database of store inventory, and I’d like to see if there’s a way to search for similar rows, and then add up their quantities, and make a new row in a new table with that sum. For example, I’d like to go through this table, and sum the “Current” and “Past” quantities of rows that have the same “Name” into a new row in a different table. Such that there’s a new table where the rows are composed of: Lollipop Cherry with Current = 15, Past = 35; Lollipop Apple Current = 15, Past = 15; Gum Strawberry Current = 50, Past = 30; Gum Coconut Current = 45, Past = 30. Would that be possible? If not, is there anything else that could be done to sum said values up?

I am doing work for a non-profit organization. I have the following tables: Members (company name, address, etc) SocialMedia (FB, IG, YT, etc) <-- links to Members Type (Potential, Regular, Associate etc) <-- links to Members The SocialMedia table has a count field that totals how many Members have each SM platform. It looks something like this giving me the total of all Member types: FB - 111 IG - 50 TY - 75 I would like a script that allows me to see the SocialMedia COUNT by Type. It can be either a group or filter option as long as I can see something like below. Example: Regular FB - 10 IG - 5 YT - 3 Associate FB - 15 IG - 6 YT - 5 Potential FB - 7 IG - 3 YT - 0 Thank you for any direction you can offer.

Hi everyone! I’m a long-time Airtable user and novice developer. I’m currently teaching myself Javascript and have a small script I’m trying to create (at least I think it’s small/simple). I want to create a script that loops through a list of sitemap urls and returns the total count of pages for each record to a field in my table called “Page Count” So far, I’ve been able to figure out that I can use a bit of javascript to count the number of xml nodes in a document using something like this: var x = xmlDoc.getElementsByTagName("loc"); return(x.length); But I’m not sure how to pull in an xml doc hosted at a specific url or loop through airtable records…anyone willing to provide a little direction? Thanks, Max

Hi there devs, we have so many bases we need to keep in sync. Right now we need to do it manually and this is very annoying. I want to build a script that displays the difference between different tables from two given bases. So does somebody know how to retrieve the table schema of an airtable base? Airtable is making an xhr call to: Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free. In this response there will be a json object retrieved with all the infos: tableSchemas: [{id: “tblCQdEDrzVc5QEQKf”, name: “STANDUP”, primaryColumnId: “fld9TUSAYKjLZgDhVR”,…},…] 0: {id: “tblCQdErzVc5DQEQKf”, name: “STANDUP”, primaryColumnId: “fld9TUSADYKjLZghVR”,…} 1. columns: [{id: "fld9TUSADYKjLZghVR", name: "To Do", type: "text"},…] 1. 0: {id: "fld9TUSAYKDjLZghVR", name: "To Do", type: "text"} 1. id: "fld9TUSADYKjLZghVR"

Our start-up runs on PostgreSQL database. Many of our customers use Airtable. We are exploring integrations to make their workflow easier. (I am very new to Airtable so please pardon my ignorance) I believe one simple way we can do this is to let our customers download data from our platform in an Airtable-friendly CSV format. But then our customer would still need to manually upload the CSV to their base right? (not ideal) Is it feasible for us to connect to our customers’ Airtable API keys (we have may individual users), and allow our customers to automatically pipe information from our system into their Airtable base? Is there a better way of doing this? I know security is certainly a concern - but we would only do this with the permission of our customers for a specific purpose. Are there other companies doing this already? Are there other pitfalls I’m not thinking about? Thanks everyone!

Please can you help me? I want to connect my database to give people function to login in my site that I am building! Can you help me?

I’ve seen this question asked a few times but still no solution. I would like to use airtable as the database for my trivia app. I need a way to randomly select row/record which will have the question, and then display the contents. The part I havent seen a solution to yet is how to select a random row/record from only the populated rows. Any ideas?

Using the scripting block, is it possible to prompt the user to select multiple records? My script is going to start with asking the user to select a record. Then (ideally), they will be prompted to choose which of the linked records to move forward with (checking off all that apply). I haven’t found a way to do this so far using the methods described in the scripting block documentation.

I have data that I can transfer in API form. All I have to do is give the endpoint API. How do I do that? I have the data in the form of a table

How can I get records in a table, sorted by creation date, ascending? The API doesn’t accept anything outside the fields object for sorting.

Hi everyone! Let me preface by saying I’m a non-developer diving into the scripting block in order to make our base more efficient. I’ve looked through a bunch of the examples on here already and don’t think I’ve found one that quite fits what I’m looking for. I have three tables I am trying to integrate. Projects, Production Calendar, and Tasks. I’ve used a script from this example base to generate a list of project beats for projects that need it but I also need code to then create tasks for each “beat” using a linked field in Production Calendar to the Tasks table. Key fields in my Production Calendar template: Project (linked to Projects Table) Phase (single select) Next Beat (Successors for order) Subtasks (a linked field which then contains Priority-single select, Status-single select, Department-single select in my Tasks template) Is is possible to bring these all together in one script? Or run another script that subsequently creates the tasks associated with the Project Beats

So, I need to query AirTable in my Node app to only return records that match a given field value. My query looks kind of like this: await base(baseName).select({ fields: […], maxRecords: 100, filterByFormula: “?” }); Here’s the catch. In the filterByFormula parameter, I need to query a field, status, that is a lookup to another table field. In the other table field, the data type of status is a single-select dropdown. However, in the API for the table I’m querying, the return type is “array of strings”, where the array of strings contains the values of the field (which is weird because I thought it was a single selection drop down). So, I’m kind of unsure how to go about querying this. Say, the possible values for status are [“pending”, “confirmed”, “canceled”, “completed”]. How would I go about filtering the results to only return records who’s linked status value is “pending”, for example? Really new to AirTable. I’ve honestly just been learning as I go during this little freelance

Is it possible to view the data stored in the database in conjunction with the airtable?

When I am making api call results are not coming in sequence meand results should come like this 1,2,3,4 but results are coming like this 1,3,2,4 How I can fix this ?

Is it possible to get airtable to import from a CSV in a particular location on a scheduled basis, as a simple form of API? Thanks.

Hi, when I call for a view, is there a way to only give back how the view really looks like, with all the hidden fields not in the response? Otherwise the view= Tag makes no sense imho. Best

Below is my database table structure { “id”: “recudh2aihP7c5Xrl”, “fields”: { “amount”: -9000, “type”: “loans”, “note”: “loaon ami for march”, “loanFk”: [ “recazeHVfHg52dTFn” ], “user”: [ “recbPHNfFnjZOaba5” ], “Name”: “loan ami”, “createdDate”: “2020-05-03T07:05:26.000Z” }, “createdTime”: “2020-05-03T07:05:26.000Z” } I want to filter records using GET API using the “loanFk” key. Can someone help me how to put the filterByFormula as it is to be done on an array? Is there anyway i can convert the array to string as I dont have multiple links

Hi Airtable gurus, has anyone ever made or know of a way to integrate fax into Airtable? We are a budding paediatric telehealth service and exploring the potential use of Airtable as our patient management system. Fax is still a common communication method with GPs. Some ideas include, using the Page Designer block to output a letter in PDF, then integrating with an online fax service. Thoughts and suggestions welcome!

We need the ability to duplicate a record on our mobile apps so we can quickly add, then edit, a brand new record that’s strongly similar to the first, saving us excessive duplicative entry work in records with many fields. It’s easy to do in the desktop application, but the “duplicate & edit” function would be used primarily “in the field” and “on the move.”

The Google Drive integration…will workspaces and bases become searchable in Google Drive? So if I enable Google Drive integration and I have some text in a record in some base, if I use the Google Drive search function to search for this text will it find and return the relevant workspace/base as a search result?

Hey all. I’m tasked with doing some automation of a few processes. As part of this task, I need to create several records in an AirTable base. I’m using AirtablJS, with typescript typings from DefinitelyTyped. I was wondering how I can create multiple records with one request. I saw on the API docs that I can just pass an array of field data to the base(“tableName”).create() function to do this. But, when I try it on my codebase, Node complains that create() has no such overload that takes an array of records. Any advice on doing this?

Hi guys, Completely new to Airtable and have been following the https://github.com/Sybit-Education/airtable.java guide to integrate Airtable with my java project. I understand this is a new API client and is probably not fully supported yet. I think I have everything set up correctly but I seem to get the following error when making any requests to the database: Exception in thread “main” com.sybit.airtable.exception.AirtableException: Could not find what you are looking for (NOT_FOUND) [Http code 404] I’m certain that my API key, base name and table name are all correct. Here is the code used in my project to connect to Airtable: import com.sybit.airtable.Airtable; import com.sybit.airtable.Base; import com.sybit.airtable.Table; import com.sybit.airtable.exception.AirtableException; import org.apache.http.client.HttpResponseException; import java.lang.reflect.InvocationTargetException; import java.util.List; public class DatabaseService { private static final String AIRTABLE_API

I’m using the curl API to pull json data from a table linking to records in a secondary table. I have a working function that pulls down and parses both tables. It then uses the record ID listed in the main table and plugs in the corresponding data in the secondary table. It works fine. But it would be very helpful to perform this without coding the name of the secondary table. Is there any way to retrieve the name of the table source of the linked record without knowing it ahead of time? Or retrieve the record with just the ID and not the table name?

I have a column “Win or Loss” that is a 0 or 1. It is the result of a formula in the Table. I would like to filter a result set to a certain number of rows in that table, which is working, and then sum the “Win or Loss” column. I figure this can be done with a reduce function. In this function which I call for each player, the goal is to calculate how many wins they have: function getPlayerStats(player){ output.text(player); let myGames = query.records.filter(record=>record.getCellValueAsString("Player")==player) output.inspect(myGames); let total_games=output.text(myGames.length); let total_wins = myGames.reduce((total,record)=>total + record.getCellValue("Win or Loss")); output.text(total_games); output.text(total_wins); } The output for total_wins ends up being something like this: [object Object]011 when it really should be 3 - it is concatenating the 1s but not summing them, and missing the first one for some reason. I am new to Javascript and

When I retrieve the content of a rich text enabled long text field through the API, only “bold” formatting works. Strikethrough and Italic are retrieved with a whitespace before the markdown symbol and therefore are not parsed correctly. Example: Is retrieved like this: You can see how 50 años posteriores shows up as _ 50 años posteriores_ instead of underscore50 años posterioresunderscore without spaces between the underscores and the thing I want to make italic. Has anyone experienced this? Is there a way to fix it?