Development & APIs

I have a table that gets a partly populated row via IFTTT at the end of a 3D print job. The table has a script block that parses information out of the supplied data to fill in other fields in each row (quantity, object printed, material type). I want to use this to track the output of a distributed print farm making PPE. My question is whether there is any way to periodically trigger the script to run either internally or via some external tool like Zapier. All the external tools I’ve found only seem to create/delete/edit records and it doesn’t seem like internal script triggers are supported yet. Thanks!

I’m not great with Scripting, but I can struggle my way through sometimes. I’m trying to get the day of the week from a Date field type. Any suggestions on how to accomplish this? Thanks!

Hi Airtable community, I’m just wondering if anyone succeeded to connect Airtable API with UI Bakery (nocode UI builder)? All the HTTP requests I’ve made fails and I can’t find why. Thanks for your feedback.

Hi Airtable Community, I’m running a boutique Headhunting Practice, and am a recent convert to Airtable as central tool for Recruiting (Candidate DB), Marketing (Prospective Client/Candidate DB), and Sales (Client & Deal DB). That said, I see an awesome opportunity for someone who’d like to upgrade the Email <-> Airtable workflow and overall CRM-like functionality of the platform. Sales & Recruiting is a communication business -> everything revolves around the messages coming into your inbox, and being able to process them quickly, while noting what you did so you can know where you’re at with a pipeline of 500+ candidates and 50+ potential clients. Being able to operate from Gmail without having to switch between windows to the CRM (Airtable) to edit and update contacts is a big time saver. Time is money. My favorite CRMs in the past generally have had a Gmail integration. Usually, it looks like a pane that pops up inside Gmail on the right-hand side of the screen. It

Are items in an Airtable view that is embedded in a website searchable by search engines (such as Google)?

Hi I have 3 tables and I created a script that fill some columns across the first table with data from the others two tables (it is a kind of manually link). It works fine. So now I created an automation to run this script when a record is created in the first table. But it is getting too long because my script run across all record. For the script used in automations, I would like to run my code just for the new record. So is there a way to get just the new record that triggered the automation to avoid run the code for all record of table every time?

How can I do to get data from a specific view as a Restful API in Airtable?

I’ve set up a few automated scripting actions using the beta automations features but keep receiving the same error message when I try to run the automation. The same script runs without issue in the scripting block, so I’m not sure how to resolve this. Any pointers? I’m also a JavaScript novice.

Hello everyone! I’m having significant challenges with getting an automation to run on a schedule. Airtable says: " Can I set up a script to run on a schedule using Automations? At the moment, there isn’t a built-in way to set up a script that runs on a regular time-based schedule (e.g. every day at 9am). A workaround is to use a time-based filter on a view." However, the time filter doesn’t seem to work very well for more frequent than daily. I was able to get ~ every minutes, but I was hoping to get something more real-time. To test the concept, I made a table where the first column is the “age” of the record using the following formula: DATETIME_DIFF(NOW(),CREATED_TIME(),"seconds") I then set up the automation to trigger when a record enters a view which filters all records newer than 10 seconds. The automation adds a new record to the same table. In theory, the automation should be running every 10 seconds continuously. But, that formula only updates every 5 minutes or so. I’m

Im trying to expand the report example, to make my own custom report. However I’m completely stuck on filtering an array of records that contains a specific name. I’ve tried a few different things (commented out below), but I don’t seem to get it to work. I have a table called ‘report’ in that base there is a field called ‘names’ and I want to filter all away all the records that does not contain the value ‘Dan’ in my names field. I hope someone has time to help an aspiring JS developer. let tableReport = base.getTable('report') let filter = 'Dan' //loadReportRecords let reportRecords = await tableReport.selectRecordsAsync(); //let filteredRecords = reportRecords.getRecord(reportRecords.recordIds).getCellValue("names") //let filteredRecords = reportRecords.records.filter(record => record.getCellValue("names")===filter); /* let filteredRecords = reportRecords.records.filter(function(reportRecord){ return reportRecord.getCellValue('names') === 'Dan'; }); */

Hi, I need some help please. I use integromat webhook to create new document from existing google drive document for a new client. The trigger is button field in Airtable. When I activate the trigger google drive creates new document for all the clients in the base. How do I set up to have drive create a new document only for the client/record I have selected in Airtabe. Thank you for your help. Pjero

I’ve been accustomed to using Zapier to do some pretty powerful stuff with my Airtable bases. Was super excited to see Automations come out. Would love to hear about the roadmap for that feature. I am currently building some no code apps and would really like to know when I would be able to find a record via automations and then update it. It will be a gamechanger.

Hi, while this Airtable Scripting is a good start. Is there any way to get the last logged in date or update the sharing permissions the collaborator might have on the base? Thanks, Nigel

A few months ago, we announced some unstable APIs for creating tables, creating fields, and updating field options using the Custom Blocks SDK. As of last week’s new release of the SDK (v0.0.54), these APIs have been marked as stable. These methods include: base.createTableAsync() Creates a new table in the base with specified name and fields table.createFieldAsync() Creates a new field in the table with specified name, field type, and field options field.updateOptionsAsync() Updates the options of a field (e.g. adding or renaming choices in a SELECT field) If you’ve been using the unstable_ variants on a previous version of the SDK, you can remove the unstable_ prefix on these method names when upgrading your @airtable/blocks version to v0.0.54 or later. No other changes to the method arguments are required. We’ve also added a new guide Changing base schema to the public docs site to illustrate how you can use these new methods inside your own custom block. Please refer

New to script blocks. I’m wondering if it is possible to present a date/time selector when the script runs? I’m using a Button to call a webhook script, and would like to prompt the user for a time. Currently I have a time selection field next to the button, but would prefer a nice popup on execution. :grinning_face_with_big_eyes:

I need to be able to calculate the number of working days between two dates determined in “Start Date” and “End Date” columns. I know the DATETIME_DIFF formula exists, but it includes weekends and public holidays – I need only working days to be calculated. Is this something that can be achieved with a Script block?

Is it possible to nest two fields in the API response? I’m trying to create a nested repeat in Appgyver and am struggling to format the array correctly–it requires objects in the source array to contain another array of objects. workflow 1 feature 1 feature 2 feature 3 workflow 2 feature 4 feature 5 feature 6

Hello everyone! I’m trying out the Button field and I want to be able to send a templated email to a static address on button press. I don’t have a paid account so I can’t use the SendGrid action and was trying to recreate it in a scripting block using SMTP https://www.smtpjs.com/ I ran into issues trying to use react/html tags in the scripting block, is this possible? Is there a better way to achieve the same thing? Thanks

Using this tutorial there is a small error that we got stuck on in part 4. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. We ended up editing it this way I am sure something more elegant is what you guys had in mind. This is just an example. function TodoBlock() { // YOUR CODE GOES HERE const base = useBase(); const globalConfig = useGlobalConfig(); const tableId = globalConfig.get('selectedTableId'); const completedFieldId = globalConfig.get('completedFieldId'); const table = base.getTableByIdIfExists(tableId); const completedField = table ? table.getFieldByIdIfExists(completedFieldId) : null; const toggle = (record) => { table.updateRecordAsync( record, {[completedFieldId]: !record.getCellValue(completedField)}

Hey all, I have a table called “Contacts” which contains the following columns: Mailing Address 1 Mailing Address 2 Mailing City Mailing State Mailing Zip Cod I have another table called “Leads” which contains the following columns: Lead Address 1 Lead Address 2 Lead City Lead State Lead Zip Code I want to create a button that runs a script to copy the address info from the related Contacts row to the Lead Address, in cases where the lead and mailing address are the same. I have no experience using the scripting block.

I have built a dashboard pulling in data from 2 different views, both of them filtered by a formula field that prints out the month. For instance, if it’s August the formula returns 8 and I manually filter both views by number. Once that’s done my blocks get updated and I can see the monthly dashboard. I would like to achieve this dynamically from the dashboard by having an input field/dropdown, in which I would just type in the number to filter the view, rather than having to do this manually in the view itself. I’ve looked at the Views API but I can’t find anything that would the job. Is this achievable?

I am wondering how permissions work with scripts and automations. I have gotten errors in my automations, that the script won’t run because of insufficient permissions. I assume it is because I had set table or field permissions about who can edit them. I assumed that automations could run under any permissions, but it’s clear it cannot. Does anyone know what must the permissions be at table and field level for automations to work correctly?

After writing some new code, after refreshing my block in Airtable (and re-running my local server that is serving up the block)… I keep getting old code or some sort of old instance of the block. The block builds successfully. Is there any workaround? https://github.com/avimoondra/airtable-block-graphql-import if it’s possible test elsewhere

I have a script (adapted from a template) to create a new project in one tab, and a list of associated tasks in another tab. What I’d like to do is add another input where the user provides a project launch date, and then have dates for all the tasks that build off of that initial date (preferably + a specific number of workdays, as a function might do in Excel). I’m not sure what to use for the input (I’m new to JS) so that the user can enter a date in MM/DD/YYYY format, and I’m also unclear how/if I might user formulas within the task creation to have sequential dates. Anyone have any suggestions? // pick tables from your base here let projects = base.getTable(‘Projects’); let tasks = base.getTable(‘Tasks’); // prompt the user to pick a template for our project output.markdown(’# New Project and Tasks’); let name = await input.textAsync(‘Project name’); // create the project - change the field name to one in your base let projectId = await projects.createRecordAsync({ ‘Project’: nam

Good Morning! I am having some difficulty with getting an automation to connect with Teams. My admin said he logged in and granted access, but when I try to log in, it doesn’t work. Do I have to be on his Airtable account? Or have him perform the Teams login on my account? Any similar experiences out there? Thank you!