Development & APIs

Hi all, Having a bit of issue with setting up an Automation. I was wondering if someone could help me? When a new record enters “Tab B”, I want it to link to “Tab A” if the ‘Vehicle Registration’ matches. “Tab A” will already have all Vehicle Registrations listed, so any new records entering “Tab B” will not be random or different. At the moment I’m having to manually click on the Linked Fields column in order to add the record from 'Tab B" to “Tab A”. I have a feeling this might be an easy to do in JS but I’m confusing myself at the moment. Any help would be greatly appreciated! Mitch

Say I have an Airtable base listing details of “Executives” by record… And say I wanted to throw up a rough prototype site to show the profiles of those executives on individual pages… How would I do that? For example, the page http://www.example.com/profile/bill-gates/ should use the Airtable API to get and show details from Bill’s record. It seems to call for a single “profile” web page, and maybe an index to list each executive first. But I can’t wrap my head around how to interrogate the URL slug for an executive’s name handle to pass to Airtable… If there is no such page at “bill-gates”, why would it not throw a 404? If the idea is I should create a page at /profile/index.html, how would I get it to understand “bill-gates”? And/or do I need a system whereby the URL slug is an Airtable “rec*” ID? I realise this is probably due to my general programming stack ca

We’ve got a monorepo for all our development. The blocks cli seems to assume it’s in its very own repository, and there doesn’t seem to be any way to configure the location of config files and the build directory. Are there any command line arguments or config options to override the default locations?

Hi guys. Im making some app and i found that field.options.isReversed is always false for multipleRecordLinks fields. Looks like this option must be true for auto-created fields (when something referencing record from anothr table) And it would be a great tool i really need for my automation. But its always FALSE. I missing something or its a bug? Or maybe this option not for this case at all? sorry 4 potato Eng. Peace!

Trying to use scripting and automation blocks/apps to send HTML emails (similar to sendgrid block) but there is currently only support for sending markdown rendered emails currently. Any workarounds or upcoming updates that anyone knows of?

Hi all, I have created a table with teachers and their availability. Each line corresponds to a teacher, and my columns are the different weeks of the year. The field type of my columns is a linked record, so that I can have multiple date filled in for one week. It looks like this: Name of the teacher // availabilities w1 // availabilities w2 // availabilities w3 // … Tom Sawyer // Mon. Jan. 1st, Tue. Jan. 2nd, Wed. Jan. 3rd, Thu. Jan. 4th, Fri. Jan. 5th // Mon. Jan. 8th, Tue. Jan. 9th // Mon. Jan. 15th … I would like to write a script to go through these “availability” columns and for each record in it, create a record some place else. So that I would have something like: Name of the date // Name of the teacher Mon. Jan. 1st // Tom Sawyer Tue. Jan. 2nd.// Tom Sawyer and s

I’m writing a small package for the julia programming language intended to wrap the airtable REST API to make it a bit easier to access within scripts. Julia has a pretty strong culture of including automated testing of packages, and I was wondering if there’s a sort of dummy table with an open api key that could be used for this purpose. I can create a dummy account and use that, but wanted to know is there a sanctioned way to do this if not, is there any reason not to make a dummy account

Hi everyone, Is there any way on a script to link to a record directly from the script window with the output object ? My usecase is the following : We use a script to detect all missing information in a table and show records where some are missing. We use output.table for that and it works great, but it lacks a way to be able to expand the corresponding records to directly modify it without being forced to do a search on the view panel to find the same records. Thanks for the help :winking_face:

//Can someone look at this simple example I cooked up. I expect Object.keys to return keys and //Object.values to return values. its easy to setup I just used a new blank template, named it Table and //put some names in Name and Done’s in Status. dictionary = ; let table = base.getTable(“Table”); let queryResult = await table.selectRecordsAsync(); for (var record of queryResult.records) { if (record.getCellValueAsString(“Status”) == “Done” ){ dictionary.push({key: record.getCellValueAsString(“Status”), value: record.getCellValueAsString(“Name”)}); } } output.table(Object.keys(dictionary)) // Why doesn’t this output keys output.table(Object.values(dictionary)) //why does this output keys and values? // this is the output I am getting

Hi, I am trying to have an app that dynamically shows information from calling a service whenever a new cell is selected. This is working, but it seems to be stuck in an endless loop and continually re-renders even when the selection is not changing. Any React guru who knows a better way please chime in! import React, { useState, useEffect } from 'react'; import { initializeBlock, useBase, useRecords, useGlobalConfig, useSession, useLoadable, useWatchable, Heading, Box } from '@airtable/blocks/ui'; import { cursor } from '@airtable/blocks'; import ConfigField from './components/ConfigField.js' const _ = require('lodash') const axios = require('axios') function UpdateAsin() { const base = useBase(); useLoadable(cursor); useWatchable(cursor, ['selectedRecordIds', 'selectedFieldIds', 'activeTableId', 'activeViewId']); const table = base.getTableByIdIfExists(cursor.activeTableId) c

Hello Airtable engineers, I’d like to build a few custom apps for my airtable, the first of which is a form to input records into a predetermined table. I’ve dabbled a fair bit with vue.js but never a single project with React, so I’m a total newbie. To aid me on my learning journey, I’m looking for some examples that I can pull apart. Specifically, I’m wondering if anyone has a simple data entry form for creating new records in a table. A field for creating linked records (to a different table) would be an extremely helpful example. Any advice or examples you might have are greatly appreciated! Cheers, Kris

I’m getting a weird behavior when iterating over Records, it looks like the code is skipping items. I’m thinking it is either my code or a cache bug. here is an example

Is there a way to tell Airtable API to ignore unknown fields when creating records via API ?

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.