Automations

Hi, Two questions about Automations: I have a record in a table that is linked to multiple records in another table. I have a trigger set up that triggers when a record in table A matches a certain condition. This works fine. As the action, I wish it to update all records that a linked to the triggering record. This works when only a single record is linked in table B but fails when there are multiple. How can this be resolved? I have an Automation set up to send a Slack message to a channel when a new record is added to a table. This works fine when the record is added via a form as all the data in the fields is added at the same time. However, when a new record is added in Grid view, the automation triggers as soon as I tab away from adding data in the first field of the record. This causes a Slack message to be sent with missing data. Eg: “A new invoice for “” has been added with the cost: “”.”, rather than something l

I need a make an json request with my script, i think the error is body: JSON.stringify because the JSON and other data is working in another script. let response = await fetch(‘https://api.service.com/fb/sending/sendContent’, { method: ‘POST’, body: JSON.stringify(’ { “subscriber_id”: 3039330322761660, “data”: { “version”: “v2”, “content”: { “messages”: [ { “type”: “cards”, “elements”: [ { “title”: “Card title”, “subtitle”: “card text”, “image_url”: “”, “action_url”: “https://google.com” } ], “image_aspect_ratio”: “horizontal” } ] } }, “otn_topic_name”: “Driver” } '), headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer 1170be67ba0d10ac2158fb435fcd6d7

Hi, I send the form results through a Webhook to Airtable Automations and somehow, I can’t see all the data in the Airtable variable. For example: choices. Can someone help? The original JSON is pretty long but less than 100kb. Attached part of the JSON: Headers User-Agent: Typeform Webhooks Content-Type: application/json Payload { "event_id": "01F2RCN9Q5F24TTF2MY2G4FAB8", "event_type": "form_response", "form_response": { "form_id": "gfSaLT", "token": "tc3nuwsqelb7q8a5m82tc3n7nkr9a5zc", "landed_at": "2021-04-08T09:21:44Z", "submitted_at": "2021-04-08T09:22:54Z", "hidden": { "interviewee_id": "123123", "interviewee_name": "My NAME" }, "definition": { "id": "gfSaLT", "title": "Pre-Interview Form", "fields": [ { "id": "e2Hswr4jWPs1", "title": "תמונת פרופיל", "type": "file_upload", "ref": "a1c008b2-7a9c-42bc-9a6c-6e9afcb935a4", "properti

Hi everyone, I have a record called “projects copy” (its just a duplicate name) and I’m pulling projects which are linked to a member’s memberstack ID. I also have a table called “members” The members table also contains this memberstack ID. I would like to automatically update the “projects copy” table in other columns with the information from the “members” table, so that I can bring in their profile information, like picture, slug, username, email, etc. How can I do this?!

I have two tables: Table A: Populated from a form from an external source. It has 3 columns: Customer Name, Customer ID and Entry Date. Table B: Contains 10 columns of customer information, including Customer Name, Customer ID and Completed. Options for the completed field are Yes/No. I want to update the Completed field in Table B to “Yes” whenever a customer completes the form/a new entry is added to Table A. I’ve gotten close and can do it manually by creating a linked field of Customer ID, but is there any way to do it with an automation? I feel like I’m missing something simple. Thanks in advance for your help.

If I have 2 automations with the same trigger, is there a danger of one automation triggering first, which would prevent the second from triggering? Here’s my situation. When I enter a deposit amount into a client’s record (“deposit” is “not empty”), an automation does two things: update client status to “Unscheduled” send email to client I want to pull out all of my “send email” actions from other automations, so they are easier to turn off while working on the database. So, if I break that automation into 2 separate automations that both trigger on “deposit” is “not empty”, is there a danger of only one triggering?

I’m looking to have Base A’s Content duplicated 3 times into Base B. The reason being I’m using it for social media, and need the original concept record in Base A to be duplicated for 3 social media platforms in Base B. Each duplicate will hold the post content for the concept record and can have different publishing dates. The end result is to have the calendar show gather one publishing date for all three platforms.

I have 2 linked tables, CLIENTS and APPOINTMENTS, where I link an APPOINTMENT record to a CLIENT record, and can have multiple APPOINTMENTS linked to a single CLIENT record. Is there a way to sort the linked appointments in the client record? For instance, could I pull the next upcoming appointment from that linked field and put it in a separate [Next Appointment] field? Or, could I pull all past appointments to a [Client History] field? Am I thinking about this the wrong way, completely? Thanks.

Input Data: 3 tables Table 1: [People] where I storage information and classify levels of people to take care Table 2: [Task] where I create recurring task to notify me to take care for each levels people Table 3: [Interaction] 's junction table between [Task] & [People] which I create action for each person and linked to main task involve Workflow: 1/ When the Task in [Task] on time (Ex: CRM 6*) 2/ Lookup the people in [People] who have the same C

Hi there, I’m using Airtable for website orders and would like an automation where in one click two things happens: The field “Status” is changed to “Processed” for all items in that view A CSV immediately downloads all items in that view. I would appreciate the help. Many thanks! Blake

Trying to see if I can set something up as follows with automations: I schedule people into events. They may be scheduled into multiple events over the course of say a year. So I have Person A, who has a linked field to the scheduling calendar, and she is scheduled for events: X -1/1/21, Y - 2/2/21, and Z - 3-3-21. What I am trying to do is have a check in field with the options of “Checked In” or “No Show” that I could use day-of (and that would clear itself out after a day). So on 3-3-21, if Person A does not show up, I could mark their status as “No Show” and this would updated a second linked field (linked to the same tab as the entry for the event itself), called No Show, with the Z - 3-3-21 record. What I am having an issue with is being able to update only the most recent record and not having this automation assume that Person A is a no show to all three events. Is this possible? Any ideas on how I would achieve it?

Hello, everyone! I need some help with automations. Subject: there is a table with information on car insurance policies, in which, among other things, there are three columns with dates, as well as one column with the status of insurance. Three columns with dates - the dates on which you need to make contributions, i.e. make quarterly payments. The column with the status - everything is simple here: “active”, “inactive”, “will end soon” and “payment soon”. Accordingly, through automation, a certain number of days (21) before the onset of any of the three dates in the column, the status changes to “payment soon”. Then, I need to create a new record in a new table (called Insurance Tasks) through automation (only 1 new record, this is important!) In certain columns of which there would be several records (see screenshot). The problem is that when using the trigger “when the record meets the conditions” in the automation according to the insurance status condition (the tri

Is it possible to manage an inventory within Airtable and show a beginning and ending amount on a sales order form?

Hej all, I am currently trying to automate a flow from Webflows CMS to Airtable. What I have done is to automate a zap that send the collection data to airtable every hour. But now my problem is that all data is in one cell together but I want to have single records per collection item. Can somebody help me to automate so that out of this cell single cells with one item each are created? Thanks in advance! :slightly_smiling_face:

Hello everyone ! We are facing an issue with the facebook automation made with the social media calendar template. Triggers are set up ( when “statuts” and “go live” is today with the right time) + action to post on the connected account. When we test both of them, it runs successfully but when we want to post it with the time, nothing happens. Is someone facing that issue ? Thanks in advance !

Hello I have some currency fields which I use to send Slack messages. However I can’t seem to find a way to retain the currency formatting like I see in my table (ie, £100,000 : symbol and comma markers) Can anybody recommend an easy way to achieve this? Thanks Dan

Hello all! In our line of work, we interview and hire candidates for our clients. Each record is a potential candidate. If we change the status from “interested” to “hired”, I would like the automation to request that the field “date hired” and “negociated salary” be updated. Is there a way to create an automation where if a field in a specific record changes status, it triggers an “alert” to remind the user to update another field in that same record? However, the information in that field varies, therefore I cannot use the ‘update record’ automation. Thank you for your help!!

Hello community! I am using an automation that triggers when an Airtable field is updated. The action is to update attendees field in an Outlook calendar but testing returns an error of ‘Cannot read property “timeZone” of undefined’. See image for what this looks like. Am I about to fall down the rabbit hole that is time zones in Airtable? Or am I just missing something obvious? Thanks in advance :slightly_smiling_face:

Hello all Im setting up a euipment register off all the companies trucks, trailer, etc. the first table will be have all assests/equp with rego, next service etc the second table is used as form for staff to fill in every month or as isssues arise, with a comments field for staff to fill in any issues etc we wanted to display on the first table the latest comment entered by staff is this possible any help would be appreciated Cheers David

Hi Guys, im hiving somebody can help me if possible, im looking to add a date of birth to a form, I have done this however its quite clunky to be able to scroll backwards multiple years starting from the current date, im looking for a formal to be able to chose the year firstly then month and day. I hope that makes sense and any help would be hugely appreciated. Andy This is the form in question. Airtable

Hi, I have a issue: A form in my table provide: Name - Instruction 1 (from customer) - Instruction 2 … Instruction 10 => I Would like to create a new table from this entry (automatically), with one rom per Instruction. Line 1: Name - Instruction 1 Line 2: Name - Instruction 2 … etc Someone could help me please ? If a tool is easy to create such a process. Thank you so much.

I have a table with four columns: Email address, Thing 1, Thing 2, and Thing 3. The possible values for the “Thing” fields are “YES” and NULL (empty / no data). Is there a way to automate a periodic (say, weekly) scan of the table that looks for NULL values and generate an email to the corresponding email address on the row saying which things are NULL?

Hi Everyone, :wave: Maybe someone can shed a bit of light :flashlight: about how to do this, if possible. :speech_balloon: Actual Scenario: When a member of the team (there are 5 members) makes a question about a certain proyect (we have many at the same time, around 100) the related client receives the question automatically in its email. But in order to answer he has to go into our portal (we use miniextensions.com) log in, find the question and answer it. Which is quite a slow process. :star_struck: Desired Scensario: When a client receives a question he can directly reply the email, and his answer will be updated to the related record. Any Ideas where to start? I guess integromat would be needed for this, or webhook to trigger an airtable automation?

I have an automated email going out to notify people what day/time the Round of edits are due. The date and time look fine in my record but the email says “Please complete your edits by 2021-04-09T09:52:00.000Z”. This is not easily readable. I’ve learned about adding a formula to the table that corrects this but it’s specific to only one field. DATETIME_FORMAT({RD1 Comments Due}, ‘M/DD/YYYY \at h:mma’). That works in the body of the email when I select this formula record to get RD1 Comments Due. Now I want to have an automated email for RD2 Comments Due. Do I have to make a 2nd Time Formula for that field?

Hi, I’ve been using the “Find Records” aspect of automations and super helpful. It doesn’t seem to be well documented anywhere though, and where I am very confused is that often there will a value from a previous step that I want to use (dynamic), but it is not available, only <>length. Unhelpfully rather than being greyed out, or not visible, I always end up clicking through to find it’s not available! From what I can tell, you can not use any of the following as a dynamic variable in the Find Records automation: Formula value Linked record Roll-up Considering those make up a large percentage of my tables, it’s a little frustrating! Indeed it seems that the only values you can actually use dynamically, are ones that have been manually populated. But that means either having to actually populate those fields manually, or using an automation to print the value int he field (so it looks like it has been cre