Automations

I want to make a tv database for ongoing tv shows. as an example “Loki” tv series it’s first season air will finish 14th july 2021. i added in my base. i want to change the select status to “Finish” if 14th july 2021 day come. is it possible?

form to insert record in view information in tab1 view A, will be carrier over to tab 1 view B (1B) ,(using filter to only have wanted info use airtable automation to create new record in tab 2 view A (2A) up to here no problem, all info will be carrier over but when need to update or change information but cant carrier over. -so i use automation trigger " update the from view 1B", tested no problem action update to 2A, but keep having the problem at here. test → record does not exists. -record id = airtable record id how to solve this problem intend is that using the form it will create a new row information. but when need to edit/update the row info on 1A, or 1B, it will sync over to 2A.

Hi Community, I have a table A, which has 3 fields. Field 1 is Name, Field 2 is Role, Field 3 is Skill-Level. Simulated data for Table A: John, Singer, High Michiel, Pianist, Medium Zule, Guitarist, High Table B has 3 fields. Field 1 is Name, Field 2 is Phone Number, Field 3 is Email Address. Simulated data: John, 12345, john@music.com Zule, 67891, zule@music.com Question: is there a way to ensure that when I add any new record in table A, only new records in table A with Skill-Level = High are automatically added to table B? Having combed through Airtable’s functions, I am sensing that this is not possible without using Zapier or Integromat or some JS code but I hope to avoid these options. Please advise, thank you!

Hi Friends Need some help with automations. I`ve created an automation (Nº1) where it creates a new event in GCAL. The problem is that I am also trying to create another automation (Nº2) where if I change in airtable the date and time of the event it will update the date/time in the GCal event created previously in automation Nº1. The issue is that it keeps me sending me failed Thanks

Is there an approved condition before launching contexts from Airtable to Softr or is there a way to have two tables linked so when the context at the first table is approved it can be automatically added to the second table? I couldn’t find any information online, will be grateful if you can help. Thank you!

Hi all, I think there’s a bug with the Automation tests. I’ve recently started using automation to send emails based on statuses. My understanding is that if the automation is set to OFF and I hit Test, it just verifies whether the email would send or not AND gives me a view of what the email content would look like. However, that didn’t happen today. I created a new automation called “Offer: Coach Match” and it was off. I had one row in my table “COACH MATCHES” that I was testing with and I made a few changes and tested both the trigger and the actions a few times. I wasn’t expecting the emails to fire so was surprised when I went into my Gmail inbox and saw: that I had received 2 emails showing the email had fired (I put myself on Bcc); and the user I was testing with had sent me an email saying “FYI - received 3 emails with the same info.”. Luckily I had given them a heads-up that I was testing otherwise it would have been a little embar

I feel this is super simple and I’m just not seeing something. If someone could put me out of my misery, it would be much appreciated. I want to send slack notifications when someone fills out a form. One of the fields is long text and asks for detailed description. I wanted to only show a preview of that field in the message. I see the “trim” option there but I don’t know how to actually use it! It’s not doing what I assume it should do. I am selecting + > the field (Description) > Continue > trim (insert) and it doesn’t do anything. When I do the exact same with any of the other properties (length, upper case, lower case, etc) it does react the way I would expect. Does anyone know how to do this? :thinking: See it not working here:

Hello, We have a problem regarding Airtable automations. The problem concerns the trigger Google Forms, trigger type “When response arrives”. It doesn’t seem to work for us when the spreadsheet is located in a shared drive. However, it works perfectly fine when the spreadsheet is located in a “personal” drive. What should we do to be able to have the spreadsheet in a shared drive? Or is this not possible?

Hello, I can’t send automatic emails anymore, I get these notifications (as attachments). I don’t know what to do because when I look at my “sent messages” from the Google console, my emails are sent. However, nobody receives them. What should I do? Thank you very much for your help

Hey, I’m facing a specific issue in Airtable Automations: Background: I’ve created a automation to do the following: Trigger: Receipt of Webhook Action: Update a Record in Airtable. The trigger is working fine, however the action is continuously failing with the following error: “Received invalid inputs.”. I’ve taken the usual steps of: Re-test the Trigger and then re-try the Action Re-configure the fields to be updated in the Action Check the field types that need to be updated in the action. Does anyone have experience with what could be the issue here? (Screenshot attached)

do I have to get the pay version to get mobile push notification, I had try Monday, clickup, slack, etc, they all do push notification free. Any one confirm this before I decide not to use it. It is a simple solution, not sure why they make this so difficult. charles

I am trying to figure out how I could create an automation that would fill one cell with tags when the new record that I have made consists a certain word. For example I add a product type chair, it would add all the tags that I would use for chair. Is this possible to do in automation or should I try to think of a script? Thanks for the help!

HI , Currently We have the option webhook receive VIA post method to Airtable base, Is there any way to find the record While receiving Webhook content . If the Record already exist in table then Need to update , if not exist in table then need to create the new record . Please advice.

I’m unable to set up an automation, It’s shows i have exceeded the maximum. how this can be resolved? I’m using a pro plan

Hello, My company procurement system runs on excel workbooks. One of the tedious tasks is generating a new PO req and filling out the vendor information. I have created a table of approved vendors in Airtable. I would like to add an Airtable button, which when clicked would trigger an automation / integration to populate the excel workbook with the information contained in the vendor record. Can a button be used in that way? Are there any suggestions for the integrations to populate excel? Thanks!

Hey everyone, We use quite a lot of automations, and sometimes it happens that someone can trigger a large number of automations by mistake. I really want to know if there is a way to stop that from happening. Eg. if thousands of automations are triggered together they just stop from triggering altogether till someone approves. Alternatively, only allow a given number of automations to run every hour and get a notification in case such a bursting event happens.

Hello All, We have issues on running tests for emailing triggers, are you facing it also ? We are not receiving the email test

Hey guys and girls. Do anyone know of a way to change the status/state of linked records when a record enters a view?

I have a team of videographers, I want to provide instructions on each record for them in long text field as rich text. I want it to auto fill every time a new record is created. How do I do this?

I am trying to create a client portal for my clients so they can see a list of items assigned to them and be able to check off the items they approve of. Is there better way to do this than using Stacker?

Desired outcome: When someone enters our blood donation center (no appointment needed) the front desk looks them up in the donors table and changes their “last visiting date” to today. I want to add a record that shows their new visit and insert the changed date into a date field in a (growing) “visits” table. I created a simple automation: When record is updated in “donors” table, create new record in “visits” table. Date Field to watch: “visit date” (this is the last date a visitor arrived) Action: Create new record in different table and add “visit date” into date field. Weird/unexpected behavior: the date added is 1 day earlier than the chosen date.

Hey there. Im currently trying to figure out how to Link up an automation through Zapier so that i just have to change the status of one item and then it would change whatever is linked to it. Lets say im creating a quiz base with this following tables: Quiz, Questions, Answers. Each should have a line called Status/State so that i can have a view for sending this to my CMS in webflow. I just cant figure out how to link all this up so i dont have to change the status of each linked item. Do anyone have an idea of how to do this?

Hello, most of our automations fails because of an error: “Script exceeded execution time limit of 30 seconds.” How we can fix it? It’s urgent for us to know what we have to do further.

I have a base with thousands of records. I have a simple formula to populate a new field in those records by concatenating some already existing data. I cannot control or change what those source data are. I need to check if the new values in the new field are unique, and tag any records where that value is not unique so I can apply a secondary process to manage duplicates if and when they arise. I need to apply this process to my thousands of existing records, plus also apply it to every new record written to the table, so I can tag any duplicates and then run my secondary process to manage those duplicates. What’s the best way to achieve the uniqueness check and tag any duplicates?

Hey guys, I have a database with tables A - Products B - Vendors C - Requests from clients. B is linked to A C is linked to A I want to give clients option to send request about specific product. An introduction to the vendor. I have a form for clients to post request about specific product in A and that goes to my table C. In that form, I have automatic pre-fill of the form with selected product from A. So inside table C data about clients - email / message / which product they asked for. I want to sent and auto email to the client and the vendor of the product. I have used automation to send email when new record gets created in table C and it work good. But I don’t know how to automatically get email to my table C if a new request is created. So in table C I have linked records from A - a product name. Can I automatically import vendor email based on that? I could put the vendor email into A table but don’t kn