Automations

Hi all, Brief: I am trying to use the Google API to run a script on Google Apps Script (GAS) from a scripting block. Has anyone accomplished this? I read through this thread and decided to pull data into GAS from the Google side, but my client wants me to handle it from Airtable. Full Explanation: I am new to Airtable and am developing a script that will scrape a website for video metrics. I saw in Airtable’s docs that direct DOM manipulations allowed in vanilla JS are excluded, so I decided to stick with a script I already had in GAS to perform the task. I saw Bill’s in-depth response at the link above and decided to run the processes from Google for simplicity, as the Airtable API is a lot nicer to work with (i.e. pulling data into GAS) than pushing data to GAS from Airtable using the Google API, which requires Oauth2. The group

Hi there,I have a Zap running that asks chatGPT to choose from a list of 8 commitments and put them in the field 'commitments' in airtable. My problem is that sometimes ChatGPT returns the commitments with a capital letter or a full stop. This then creates a new multiple select and messes up my reporting. Is there a way to ensure that airtable disregards the full stop or capitalisation? Thanks! 

Hello! I'm wondering if an automation can be built to send an email alert whenever an email sync takes place.What I am trying to accomplish is this1. Team A sends a csv file that is sync to an Airtable table2. Within that csv will be a list of records3. I wish to alert Team B via email whenever Team A sends a csv file to Airtable emailed data syncMy conundrum - If I were to use Automations to trigger when a record is created, it will fire off 1 notification for every record which isn't good.How can I build an automation to fire off 1 single email notification whenever a sync takes place? Thanks!

I want to set the value of a Rich Text Field with formatting through automations. However the formatting doesn't work when updating through Automations. Is there a way to do this? Or maybe through a script? How do I ensure that the formatting stays?

I was following the directions found here: https://support.airtable.com/docs/use-automations-to-timestamp-status-updatesHowever, when it came time to select the "Last Modified" field, per the directions, I saw an error stating that "this field cannot be used because it if computed".  What struck me as odd was that this was in contradiction to the exact steps to take in the link.  Now i can't complete this automation.

Is it possible to have an ‘Update Record’ action add to a field instead of overwriting whatever is in there? IE: We have a request base. If the department is Training then Jane Doe needs to be tagged in the Collaborator field on the record. But if the department is Report a Bug, John Doe needs to be tagged in the Collaborator field on the record. The problem: If a record is tagged with Training and Report a Bug, it’ll overwrite Jane with John, instead of adding John.

Hi there!I have set up a masterlist of advocates that is pulling all of our advocates from different bases, using synced tables. Now I want to have a field that will tell us when the person was last reached out to so we have a good overview. I have set up an automation that says 'When this date field is not empty in this table, please update the date field in the masterlist table with the same data" However, it works only the first time. Afterwards, when the original date field is updated to a new date, it's not updating the field in the masterlist table. Is there any way to make the automation triggers every time there is a new value in the original field? Thank you!

Hello community. I'm wondering about comparing dates in automations. It seems this isn't a thing that airtable can do, maybe you can help me find an elegant way to set myself up. Our company changed the date of their fiscal year (FY) and I need to calculate which FY a member joined, renewed or cancelled. I can do it with a formula for each date, for example like this for the subscription date: (and let me know if it could be improved) IF({Subscription date}, IF( IS_BEFORE( {Subscription date}, "07/01/2019" ), DATETIME_FORMAT( {Subscription date}, 'YYYY' ), IF( VALUE( DATETIME_FORMAT( {Subscription date},'M' ) ) >=7, DATETIME_FORMAT( DATEADD( {Subscription date}, 1, 'year' ), 'YYYY' ), DATETIME_FORMAT( {Subscription date}, 'YY

Is there a way to confirm if I bbc group of emails which emails actually got the email?Also is there a way for the original email (sent from) to see who all of  people the emails went to. (Like when you send something out of outlook you can see all the emails that the email went to including bbc if you are the sender)  

I've created an Automation that should help me automatically update Records in another table when x happens. So I have two tables: One table with a whole bunch of records (new ones will appear every week) and then I have a table where some of these records appears IF my colleague hasn't accepted them as valid. When they appear in the second table, I'll have to edit one of two fields and give them back to him. Therefore I wanted to make an Automation that automatically makes this update for me. What I have done so far is this: 1. When record matches conditions (field has x value)2. Find records from Table A, view A - Find records based on: Condition: Where ID contains ID (from Table B)3. Update record (Table A)- Record ID: List of Record ID from step 2. - Fields: Field A and B from Table B (so that the record in Ta

What's wrong with this script? let tableName = "Table 1";let viewName = "Books (ChatGPT)";let openaiUrl = "https://api.openai.com/v1/completions";let apiKey = "sk-key";let table = base.getTable(tableName);let view = table.getView(viewName);let record = await input

Hey, I’m struggling to create an automation that sends an email (to myself) when any record under a field in a specific table is deleted. I thought the ‘When record updated’ trigger would work, but it seems I’d need something more custom. For context, I’m using Airtable as a database for a booking app, and my goal is to receive an email when a user deletes/cancels their booking on the app (this action already deletes the corresponding record in Airtable). Any help is appreciated. Tunmise

Hi,I am needing help with an automation. I am needing to change the status of our guest to moved out when the lease end date has past except for when it status is canceled. 

Hi everyone I have created an automation which sends an email of a list of records from my table at a scheduled time. However there is too many records being shown and would like to change the amount. The number of length is by default at 100 and does not let me edit this number. Can you help me please?

I have this table to track some gym progress.I have a number of updated values for each record, e.g.:for a 1 set of 10 for 245 for b 2 set of 8 for 356and etc.there is also column for tracking the latest update.I need to be able to somehow store the progress/history of this values. So what if i update smth like this:for a 1 set of 10 for 245 => for a 2 sets of 9 for 250i could have bouth record in my baseI'm aware about the Revision history function, although it's not providing acces to the information in the most comfortable wayIs there a way, through some formula/automation/etc. to copy the current record each time i'm updating it? 

Am looking for a developer that can connect our Airtable to DocuMint for automation. Also have additional automation needs that need to be addressed.  Please respond below with email and we will reach out!

I'm new to Air Table and having trouble finding a solution for this. I want to press a button to update a record with some information provided by the user. So on hitting the button I want it to set one field to "Completed" (which is fine), one field to todays date (which the work around seems to be having a formula on the table that this can be grabbed from) and the name of one of our team. Ideally the name of our team member would be selected from a drop down but I would settle for them typing it in somewhere. Is this possible?

TL;DR: what's the difference between 'contains' and 'has any of'?I'm setting up some automations with a 'when a record matches conditions' trigger.When I set my 'find records' trigger to the condition 'has any of' the dynamic value I want to use, I get 'invalid value: when a record matches conditions cannot be converted to an array of string'.When I set the condition to 'contains', it works perfectly.What is the difference between 'has any of' and 'contains'? In natural language the two are synonymous (to my sense of the language, anyway), but I assume there's some important distinction in the underlying code that I do

I'm intending to create a simple AirTable script to record duration of a single status field. In my use case I'm tracking a large number of issues where the status frequently goes back and forth between the multiple status',For example there are multiple status':  open, in-progress, and resolved status. A normal workflow would be non-linear, so a record could go from open to in-progress, back to open, then to resolved then back to open, and then finally to resolved again.open > in-progress > open > resolved > open > resolved.I'd like to track the duration that each record is in each status as well as the cumulative time each record is in each status. This way I could say this record was open for a period of 3 days, in progress for 1 day and it was  in a resolved status two days. In the first table I have several records with a status field and a time modified field as well as other important data fields to help

Hi to all! I am having a problem using Automatization for updating numbers in one table, when some conditions are matching in the other one.In table Bills I need to have an updated (lesser) amount of each bill, when in the table RatenPayment a part of that bill is payed. The Trigger is working (consist of the elements if date of the payment is not empty, and when the amount of the partial payment is given).However, the Action in the Automatization keep showing me error (but it seamd to be such a 'peace of cake')....Thank for ANY kind of a help, I am struggling with it more then a half day.. 

Is there any way we can create custom table, form views using airtable scripting or automations?

Hello, looking for help on how to trigger the update of formula field when a record reaches a condition. My example is the following: I have a "Birth Date" field which contains the birthdate as Date. I have a formula field which calculates the current year "Anniversary Date": DATETIME_PARSE(YEAR(NOW())&"-"&DATETIME_FORMAT({Birth Date},'MM-DD')).How can I trigger the update of this "Anniversary Date" when the record reaches the day after the anniversary? 

Hi,I have a base called "Tasks" where each record has an Assignee.I created a new base called "Timesheet" to enter the time spent on each Task with a form or interface.When a new Timesheet record is associated with a Task record, I would like the Timesheet table to add automatically the Assignee for the Task related to that Time entry.I'm trying to get this done by having an Automation that looks for Timesheet records which have an Associated Task not empty, then finding the corresponding Task in the Task base, and finally adding the same Assignee to that Timesheet record.Ho

Hello!My current data base and forms are connected to Blackbaud and E-tapestry. I'm not fully ready to commit to downloading everything into airtable, but wanted to know if you have seen a successful integration with these systems?For context:I'm creating a speakers Bureau and want my updated information to go into E-tapestry. I would also be pulling reports from e-tapestry to integrate into airtable. The forms on E-tapestry are outdated and clunky, I would much rather use airtable for this.I'm also to look automations where a speaker enters information and we send a thank you email. That is also clunky with e-tapestry. But I still need the data to sync between the two for now. thanks! -Rachel 

Basically we have two workspaces. One is for project management. The other is for accounting. Once the project has been completed, we change it's status to "ready for accounting" which then automatically syncs with the accounting workspace. So no new records are being created in the accounting workspace.We then generate a "price code" based on the company name and the product. The price code reference a price list which is a different table in the accounting workspace. I have nearly all the mechanics of this worked out, but currently have to manually copy/paste from "price code" column to "price" column (see screenshots). I'd like to automate this, but I've had trouble with the tutorials I've seen, and I also don't know what an appropriate trigger would be.Thanks in advance for any help!