Development & APIs

Just want to put in a vote for some kind of “import” functionality or js module support for sharing code between automations. I’m resisting the temptation to create a “Modules” table and eval’ing those records into each of my scripts. Please, save me from myself.

Hello, I don’t seem to understand Airtable. I would like to have a Table of Transactions as follows: . TransactionID field is Autonumber Date, Description, Amount, Currency are entered Year is the formula Year(Date) In addition, I have exchange rates between my business currency (HKD) and other currencies, by year: one set of exchange rate for 2019, one for 2020, in the future for 2021, 2022, etc. I would like to have a table that contains the exchange rates for each year, for example like this: Finally, the RateForthisTx Field in the Transaction Table should be the result of a lookup(Currency, Year), e.g., lookup(AUD, 2019), or lookup (CHF, 2020), whatever corresponds to the actual values in a given transaction. I must be thick, but I can’t find a solution Airtable, unless, perhaps, we’d have to resort to Scripts. Once again, a big thank you to anyone who can help. Peter

Hi, Anybody else noticed that the Currency converter scripting block provided as a template when you add a new Scripting App no longer works. The fetch(‘https://api.exchangeratesapi.io/latest?base=USD’) endpoint has changed and also requires an access key. Their api documentation (Exchange Rates API) now shows that the following endpoint needs to be used: https://api.exchangeratesapi.io/v1/latest?access_key = API_KEY This works once you have a valid access key, however, it appears that you can only pull the EUR default base currency on the free plan. When I tried to use ‘&base=USD’ I git the following response: {“error”:{“code”:“base_currency_access_restricted”,“message”:“An unexpected error ocurred. [Technical Support: support@apilayer.com]”}} I am not sure who maintains these example scripts, but this one needs looking at. Anybody know of an alternative api for currently conversion that would be completely free and allow base currencies to be changed? Only very low call rates nee

I have a view that needs the “Grouped By” setting changed every 24 hours. Are there any methods in the scripting block that would allow me to change a view’s group by setting? Alternatively, let me know if there are any apps that can achieve this.

Example Go Program Using API

Is it possible to extend/change webpack config?

How can I get convert the encoded data to actual data shown on the image? Thanks in advance.

Description I wrote this little scriptlet for personal use and thought maybe someone else might find it useful. It fetches the summary of a Wikipedia article in one cell based on a query in another using the public MediaWiki API. example code I’m just starting out programming and I don’t know JS so there’s probably alot of bad practice. I wanted to write it in a more functional way but I couldn’t figure it out how when it’s asynchronous. Feedback welcomed with a smile :grinning_face_with_big_eyes: /* CONFIG */ let queryColumn = 'Query' let resultColumn = 'Wiki' let language = 'en' let table = base.getTable('table'); let view = table.getView('view'); /* SCRIPT */ /* list of all records in view */ let result = await view.selectRecordsAsync(); for (let record of result.records) { let query = record.getCellValueAsString(queryColumn) let seachQuery = encodeURIComponent(query) /* skips wiki request if airtable record has no query */ if (query == null) {continue} /*

Progressing with Javascript and airtable, was distracted with the thought - can I gear a scripting app button to open a link? I know I that the button fields can open links within a base (but annoyingly their labels can’t be configured on a per record basis). The below simply posts the selected link in the output, but is there a method that allows to open directly into a new tab upon clicking the button? let button_test = await input.buttonsAsync( "abc this is a test", [ {label: 'Google', value: 'https://google.com'}, {label: 'Bing', value: 'https://bing.com', variant: 'primary'}, {label: 'Yahoo', value: 'https://ask.com', variant: 'secondary'}, {label: 'DuckDuckGo', value: 'https://duckduckgo.com', variant: 'danger'} ] ) output.markdown(`### Link: ${button_test} `) output.inspect(button_test)

Hi, I am using the useRecords hook extensively in my application, and cannot find an answer in the documentation to this question. The useRecords documentation shows an example of using field options to limit the amount of data loaded from a table like so: // Returns all records in a table, only loading data for the specified fields records = useRecords(table, {fields: ['My field']}); This appears to work, however I am trying to use it with a view like so records = useRecords(view, {fields: ['My field']}); Based on my testing, when used with a view useRecords ignores the fields argument and loads all fields for the records in the view anyway. Can anyone confirm if this is the case, and if so, is there an alternative method to achieve my goal? I need to evaluate one field in the view, so loading the whole view is a waste. I would prefer not to use the table as we are using the view filters to keep logic out of the code. Thanks, Peter Toft.

Did the basic “Hello World” demo app. ie. selected “Add an App” then “Build a Custom App”, selected “Hello World” example and went though installing blocks-cli, doing blocks init and blocks run. I see the " Your block is running locally at https://…" message on my server. I specify the App URL back on airtable’s message box and click “Start Editing App”, but after about a second I get this message: Error running app Error: Disconnected from development server pollForLiveReload/</<@https://XXX.XXX.XXX.XXX:9000/__runFrame/poll_script.js:19:19 (I replaced my IP with “XXX.XXX.XXX.XXX”) When I try with “Simple Chart” example some GUI elements from the app show in the airtable’s dashboard space for that app, bu get the same error again after about a second… Any hints on why this error is happening here appreciated… I’m using demo apps as provided by airtable…

Is it possible to create scripts OR automation on tables using API endpoints? Thanks, Deepak.

Based on template by @kuovonne , I want to use button to run the script. But I don’t want create two buttons. My scenario is when Single Select field is “Not Started”, when I press the button, it will change to “In Progress”. When the field is “In Progress”, then I press the button again, it will change to “Completed”. How do I achieve this? Thanks.

How can I ensure Airtable properly handles dates I write from JavaScript into a Date field? This script pictured below properly inserts the Date retrieved into a Date field as long as I run it before a certain time. If I run it in the morning, for example, I get the date I expect in my Date field. I just ran this at 6:50pm in my current timezone and it entered the date into the date field as if it were a day later: This really has me thinking that it’s an Airtable date display problem, and not a JavaScript DateTime interpreter problem. I have the same issue with this script run as an Automation - Script Action as well. I do not have the Time included in this Date field, and I do not have the “Use the same timezone for all…” option checked: So my presumption is that this field should be interpreting DateTimes relative to the timezone my browser recognizes me to be in, or that my system is set to (and clearly the JavaScript that is fetching the date and displaying it in my script outpu

Hi! Trying to reach Airtable via curl from debian buster. root@689c6c6a3ea9:/app# curl https://www.airtable.com curl: (60) SSL certificate problem: unable to get local issuer certificate More details here: https://curl.haxx.se/docs/sslcerts.html curl failed to verify the legitimacy of the server and therefore could not establish a secure connection to it. To learn more about this situation and how to fix it, please visit the web page mentioned above. Installed last updates of ca-certificates, tried to reload them but it doesn’t help. For now it solved when I manually installed SectigoRSADomainValidationSecureServerCA.crt into debian trusted cert store. Could you please check that issue?

Hi! I’m trying to automatically link records through a script created by @Justin_Barrett (Automatically link record based on plain text or formula result). But I can’t run the script as I get errors in the last line: Property ‘id’ does not exist on type ‘string | SitesTable_Record’. / Property ‘id’ does not exist on type ‘string’ What could be the problem? I have no knowledge about scripting… Thanks!

I’ve been testing out the Scripting block over the past few days. This is the most exciting thing to happen to Airtable…since Airtable :slightly_smiling_face: Does anyone know of a way to make the scripts resilient to changes in a table’s field names? For example, if I have the following code in a script: fname = record.getCellValue(“First Name”); this works great until someone decides to rename the “First Name” field to “Contact First Name” – at which point the script will no longer work. I’m wondering if there is some sort of “internal ID” for a field that stays the same even if the visible field name is changed. Thanks Bill

Hey everyone! I’m trying to create a script that will read whatever content is placed into the first column “Product Title” and create a url handle out of it. I’m just looking for it to copy whatever record is under “Product Title” to “Handle” and replace all instances of spaces with “-” instead. Thanks so much!

I am looking to run multiple search queries/scripts in three fields where users will enter a long format answer explaining project needs. These are populating in a request table. I have second Airtable that lists out my talent at my agency and have created a ‘Keywords’ column that lists out all the different expertise fields and past industries. My goal is to search through the long format answers client input and connect the keywords to the best match talent in my pool. Any thoughts or stimuli from past projects? Below is what I have tried so far, but do not know if there is a simpler way since it is two air tables and not calling another database outside Airtable let table = base.getTable('Project_Needs'); let resultsField = table.getField('Talent v2'); let record = await input.recordAsync('Record', table); let searchQuery = record.getCellValueAsString("TalentTable_KeywordsField") if (searchQuery) { table.updateRecordAsync(record, {[resultsField.id]: 'Updating...'}); output

I was looking into the Airtable API, and I looked into the section “list records”, I can see the sample code in Javascript, and some of the fields I have looked into, it only works on the ‘text’ or string field type. eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { console.log('Retrieved', record.get('Name')); }); Then I tried adding the “profile photo” field, but knowing the field is actually a array type because there are separate URLS for different image sizes in a array. Simply what I did is this eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { console.log('Retrieved', record.get('Profile Photo')); }); I tested in a playcode.io playground and came out as this: Retrieved (1) [{...}] Retrieved (1) [{...}] Retrieved (1) [{...}] Is there a way to get a item in a array field in this? I just want to get the attachment/image url.

Using gatsby-source-airtable. Was working fine until today (have made no code changes that would affect afaik): FetchError: request to https://api.airtable.com/v0/appXXXXXXXXXXXXXX/Products%20-%20T4?view= failed, reason: connect ETIMEDOUT 54.210.4.251:443 Tested via cURL and that seems to be working fine: https://api.airtable.com/v0/appXXXXXXXXXXXXXX/Products%20-%20T4?view=&api_key=keyXXXXXXXXXXXXXX Is this an intermittent server issue, or should I perhaps be looking within my code to debug? gatsby-source-airtable@2.2.0 concurrency: 5

Not a question, just thought I’d share in case any rookie developers like me are struggling with laying out a custom app. I’m having great success making various layouts for my components by utilising grid template areas via Styled Components - it’s incredibly intuitive. Here’s an example snippet and the resulting layout. Would love to hear anymore layout tips! const Section = styled.div` border: solid black 1px; display: flex; align-items: center; padding: 5px; ` const HeadSection = styled(Section)` grid-area: hd; ` const SidebarSection = styled(Section)` grid-area: sd; ` const LineItemsSection = styled(Section)` grid-area: li; ` const DeliverySection = styled(Section)` grid-area: dl; ` const TermsSection = styled(Section)` grid-area: tm; ` const TotalsSection = styled(Section)` grid-area: to; ` const FooterSection = styled(Section)` grid-area: ft; ` const GridContainer = styled.div` display: grid; grid-template-columns: repeat(9

Hi all, I am triggering a script upon row creation. I want to be able to respond to form submissions and manually entering rows as we migrate to this new table. For some reason the available “Field Values” are different when I test the “Trigger” and “Script” directly in the Automation screen: but when the script runs live against a form submission one field is missing: This is how the automation is failing, but you can see in the first screenshot that that field is available when running the tests: Is there a nuance I need to be cautious of when creating/automating form row creations? Or should I be triggering my automation on both form and manual table row creations? Many thanks for any advice :pray:

In 4 weeks, we’ll be rolling out a small change to the URL format returned from Table, View, and Record models via the .url property. Specifically, these URLs will now also include the base ID in their return value. This change affects both Scripting and Custom apps, and coincides with the recent change to include base IDs in Airtable URLs throughout the rest of product. This may be a breaking change if your script or app makes hard assumptions about the format of this url property (e.g. by deconstructing the returned URL into its component parts with substring() or similar). No action should be needed if your script or app only uses the URL for navigational purposes. Browser navigation will continue to work for the old-style Airtable URLs via redirects, although these redirects may not be supported indefinitely in the future. If your script or app constructs Airtable URLs from scratch, we recommend updating the construction logic to also include the base ID. Summary of changes Scrip

Hi All, I have a Tasks table, and an Appointments table, and I often find myself needing to manually link multiple tasks to a a single appointment. Say we are scheduled to meet with customer XYZ next Tuesday, and I have 30 tasks for them, but I’ll only be able to get to 5 of them next Tuesday. So I want to link those 5 tasks to the appointment. Is there a way to select those 5 tasks and link them all to one appointment? So far I have experimented with using a checkbox column in the Tasks table, something like “Ready to Schedule”, and that works okay, but it creates multiple records in the Appointments table, with the automation running the script after each row is checked. Is there a way to have a script run on the selected records (the checkbox on the far left of each row, not an added checkbox column)? Or am I thinking about this the wrong way? Is there a different approach you would take with this use case? In general I find myself wanting to select several rows and do something wit