Development & APIs

how to increase the data load time via api? i am ready to pay money

Hey! I have a question that I hope you can help me with. I am looking for a way to do the following: If input A1 is X, then input in B1 is Y. Plus I want it to happen with every new input that adds to the table (through Zapier). In my case, I have a column named ID, and another called Description. Description will be in the format of “This is an event with John” or "This is an event with Sarah… I need a way for the table to automatically change ID associated with “This is an event with John” to “John”, and that of “This is an event with Sarah” to “Sarah”. That should be done with Script Block, right? And I hit Run everytime I need the system updated? or can I do it through Formula fx? Appreciating your insights in advance.

Hi! I’m writing a custom block that is deployed to several bases, and we’re considering automating deploys. I’d like to write tests for our code to try to catch regressions and increase confidence – has anyone done this? I looked through a few of the examples on github and didn’t find any test folders, but I didn’t check them all and maybe I’m looking in the wrong place. Any recommendations for a test stack? I’d rather not reinvent the wheel if somebody’s got this working!

A few weeks ago we added the ability to upload files in the scripting block using input.fileAsync, and wanted to open up another challenge to the community around this feature. For this challenge, submit a script that uses the input.fileAsync API for a specific workflow. We’d love to see creative and useful ways for this new input type to be used! Maybe it’s a smarter importer, for example with fuzzy matching to update existing records, or a way to import Excel files with multiple sheets, or importers for other common apps that export CSV, JSON, or XML files. Or maybe it’s something totally different! The winner of this contest will win $1,000 :tada: . All submissions are due by May 8, 2020 at 6:00pm (PST). What exactly should be submitted To qualify for participating in this content, you should submit: A script using input.fileAsync in the scripting block A short video demo of the script in action A description of what the script does Guidelines on submission format Submit your

Just started using the Scripting block! My team is using Airtable to calculate profit pool for an affiliate program, part of that includes getting the sum of a field (which you can see on the page) update it on another field for all record as total number of that field (in this case sum of ‘# of hoodies’ ) and then updated on another field (‘total hoodies’ ). And then update total number of records from another table in a view (Toal # of Affiliate which is the total records from the Approved affiliate table). Thanks so much for your feedback on this! Lubem

I new at airtable, but not to BI, I actually use PowerBI. I have on airtable a bd (grid) with more than 450 rows. When I use PowerBi Or CURL to get my data, I only receive the first 100 rows, nothing more, nothing less And I don’t figure out own to get more data from the table. Thank you in advance

Currently in Airtable there’s no function provided for a standard deviation like Excel’s STDEV. One user on this community has helpfully written out the function that calculates it, but it’s rather complex. I’m wondering if the script block couldn’t be used with math.std on rolled-up values in a single property to very quickly generate the standard deviation on a set of values? I’m still verrry green at Javascript but this seems like it would work; if you agree I’d love some guidance on where to start on pulling the values from a roll-up column and using them in the math.std calculation. Thank you!

Hi! I’m outlining a bit here since as of this writing, only see a few topics related to the selectRecordsAsync method. Hoping this is helpful to someone else! GOAL My goal here is to update a value in a record selected by the user (e.g. {"Status": "Not Started"} -> {"Status": "In Progress"}). User first selects a record with await input.recordAsync and then the record is updated with updateRecordAsync(fieldId, {"key": "value"})). BACKGROUND & ATTEMPT 1 First - a sanity check and quick background on my approach here. As part of this, I don’t need to/want to present a list of all records. For example, I have about 50 records in total, but only about 10 are relevant, and thus only the 10 should be presented to the user for selection. Since you can render the input.recordAsync from a view, I started by creating a view which is configured how I want it w/ filters, sorting, etc, so that only the 10 records I want are listed. And voila - the input.recordAsync presented just the 10 opti

Hi there, I’m a newbie on airtable… and in the first script I write I encountered a problem and maybe somebody here can help me let table = base.getTable(“MAIN_TABLE”); let query = await table.selectRecordsAsync( { sort: [{ field: “STRING_FIELD”, direction: ‘desc’ }, { field: “DATE_FIELD”, direction: ‘desc’ } ] } ); for (let registro of query.records) { // Do some processing… }; The problem that I have is that the order of the records is always the same, no matter what i write on the sort options invoking the table.selectRecordsAsync function… There is something that I’m missing here? Anyone has encountered the same problem?? Thanks in advance

Hey folks, I’ve got a mystery/puzzle/bug. I’ve recently rewritten one of our scripting blocks, and added the new version to our airtable base. It works great for me, exactly as intended, but when my teammate clicks “run” on her computer she immediately gets this: SyntaxError: Unexpected token '.' Function@[native code] blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:44565 s@blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:3861 blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:3611 e@blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:66 l@blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676d:1:270 blob:https://block---y-ir-meqis-zl-o6-a-k--8sp2agd.airtableblocks.com/d02f16dd-4665-46ed-9f49-116f98a4676

I have a table with a column which can 0 or more string values. I’m trying to search for all records that contain a certain string value in its that column I’m using the following in my request URL but never getting any records (this value does exist within the array of values in some of the rows) filterByFormula=SEARCH("rec6CS1RqOjcYLwXf", ARRAYJOIN(Industries)) Am I doing something wrong?

When fetching, I’m getting this error in console: Access to fetch at ‘https://usgeocoder.com/api/get_info.php?address=18035%20SE%20Newport%20way&zipcode=98027&authkey=’ from origin ‘https://block--hd-i-z-fh-ux-g-vq-m0-t--tiq297d.airtableblocks.com’ has been blocked by CORS policy: Response to preflight request doesn’t pass access control check: No ‘Access-Control-Allow-Origin’ header is present on the requested resource. If an opaque response serves your needs, set the request’s mode to ‘no-cors’ to fetch the resource with CORS disabled. Here’s the current fetch part of my code: let reqHeader = new Headers(); reqHeader.append('Content-Type', 'text/json','Access-Control-Allow-Origin'); //,'no-cors' let initObject = { method: 'GET', headers: reqHeader, }; var targetUrl = "https://usgeocoder.com/api/get_info.php?address="+add+"&zipcode="+zip+'&authkey='+apiKey; console.log(targetUrl); await fetch(targetUrl, initObject) .then(function (response) { return

I have a plan to help our local community who lost their job during this lay off situation. The plan is to create a basic directory model where visitors can hire a local person base on their needs. To complete this task I need a solid solution for our users or job seekers. Selected user and admin received an email when visitors hire them from our database. Which means a separate lead form for each job seekers so they directly receive message. Somehow I think it is possible with airtable web clipper and form feature but not sure how to do it. I am open for suggestions if anyone have any alternative solution.

Is there a way to run my business through air table? I need to be able to put appointments in and they go into calendar and will also be able to go in to invoice and then print invoice. How do I change some of the wording in the invoice screen that prints

Hi. This is my first forum post forgive me if I’ve posted in wrong location or anything. I am a small business owner thinking of switching our company database from Filemaker to Airtable. Initial impressions have been good so far. One thing we do a lot of from filemaker, is email. It’s connected to Amazon SES. We use it for quick individual emails to our staff , statements to our songwriters, as well as mass mailouts to our clients. A bulk mail usually consists of selecting people from our big contacts list, composing email and pressing send. A custom made script in filemaker then sends each email through amazon ses. The script also takes care of any mail merge details, as well as tracking the cost of the mailout. My question is simply, is this going to be possible from Airtable? If so, would it require a script block? or a different method? I’m a total newbie here so please be gentle :slightly_smiling_face: Cheers

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.