Automations

Hi all Is there any way of blocking a card from moving to the next stack until a field is filled? Thanks - ravi

Hello, I have a table A of 100’s lines with the name of different projects and their status. I am updating it on a daily basis, sometimes several times a day. I would like to create a table B which summarize the changes that happened in the table A during the past week. I did succeed to create a table B which create a line with the project name and its new status every time the status changes in the table A. However since I may change the status several times a day, I would like to create an automation which edit the previous line if the project name already exist in the table B. The goal is to avoid having 10’s entries and line for the same project. Could you help me out ? :slightly_smiling_face: Thanks a lot !

I have created an automation that runs a custom script after a record is updated. In the script I would like to perform different operations depending on the overwritten values. Is there any way to access those values from the script? (Similar to how one would use OLD in a SQL trigger).

I have my new members sign up for the clubcard and I want to have the ability to send sms/ call from my phone without having to re-enter the contact in my phone. So Airtable form will collect the data and convert it to vcard which I can import it later on. Pls advice

Is it possibe to send emails from more than one email address in airtable That is what i’m trying to achieve is i can send emails to people from either m@gmail.com or n@gmail.com Please i need help asap

Is there any explanation for why making changes to automations does not always reflect instantly in the table? I have one automation that builds a grid using data in a table and attaches it to a field within the same table (as a roundabout way of attaching this info to a pdf further down the line). When I need to troubleshoot/update this automation, It takes quite a while before I’m able to see the changes I’ve made in the grid I’m building. sometimes it will display as it did before I made the change, other times it will display as completely empty (the grid having headers but no data to display). Would really appreciate a way of ensuring that my change is in place immediately after clicking update automation, or at least a rough approximation of how long it normally takes to go into effect.

I was looking for best practices on how to automation a form and I was not sure if I should be looking a different plug-ins. I am leaving towards using Make help out with this process. The more I dig into this with AirTable, if looks overly complicated, I am wondering if there is a better tool to use. On the form I need the following: Ability to upload attachments (images or pdf) Digital Sign or email approve the form a way for the end user to be able to modify the form create a PDF of the form and include the attachments. Then, I want to email the form for approval to 4 different people via email. If a form is denied, then give the ability for the end user to be able to update the form.

I have built an automation that fires off an email to a key stake holder with information found in different fields. One of these fields contains a link. When the automation fires, the email is sent along with a slack notification. The slack notifaction contains the same information the email should, BUT the link in the email is altered by the automation and the link in the slack message seemingly works. The automation is grabbing the same URL from the same field. I am not sure why the URL is changes in the email but not the slack message. To add additional information, the email is removing the under-scores from the URL and the Slack message is not. Can anyone help?

I have a script to trigger a netlify build at midnight every day, but I would like to customize it further to only trigger if a new form was submitted that day. So the trigger would look something like: If form is submitted in either Table 1 or Table 2, then trigger script to run the build hook at midnight. Or if this trigger doesn’t exist, maybe I can house the build hook in an if statement within the script. Trigger every day at midnight: if a new form was submitted, run build hook? Thank you!

Hi! I’m building out a base where I have tables for different types of contacts (lets call them blue contacts, red contacts and green contacts), they all feed into a larger table where I can see all of them (rainbow contacts list) - I have set up automations to automatically create a new record in the rainbow contacts sheet when a new record is created in any of the other tables. So I put Joe Bloggs into green contacts and he automatically appears in the rainbow list. I want to setup an automation so that if I update the Joe Bloggs record in green contacts, it automatically updates in the rainbow list. Can anyone help. I have tried setting up an automation, it watches all the fields in the green contacts and then I tried update record in rainbow list - I’ve tried a few combinations of things and can’t get it to update in the rainbow list - does anyone have any advice? Do I need to find a record first?

Have been trying to get the subject line on the “At a scheduled time” trigger to say the end of the week in ‘Mmm DD, YYYY’ format but haven’t found any way to do that. Tried instead make a field that displays the end of the week, but the automation cannot add that field on to the subject line. If anyone else has suggestions, would love to know! On another note, here is the formula I made for the end of the week field, in case it helps anyone! SWITCH(WEEKDAY({Start Date.}), 1,DATETIME_FORMAT(DATEADD({Start Date.},6,‘day’),‘MMM DD, YYYY’), 2,DATETIME_FORMAT(DATEADD({Start Date.},5,‘day’),‘MMM DD, YYYY’), 3,DATETIME_FORMAT(DATEADD({Start Date.},4,‘day’),‘MMM DD, YYYY’), 4,DATETIME_FORMAT(DATEADD({Start Date.},3,‘day’),‘MMM DD, YYYY’), 5,DATETIME_FORMAT(DATEADD({Start Date.},2,‘day’),‘MMM DD, YYYY’), 6,DATETIME_FORMAT(DATEADD({Start Date.},1,‘day’),‘MMM DD, YYYY’), DATETIME_FORMAT({Start Date.},‘MMM DD, YYYY’))

Dear Community Member, We have a simple form in Airtable. We want to send the form input to third party app using POST API with basic authentication. Is it possible to do this operation? Can someone has dummy code to pass basic authorisation then please share or suggest how to pass the authorisation details.

Hi all :slightly_smiling_face: Would appreciate an assistance if anyone knows how to do the following: To send an email, only once, X hourse after a new record has created (not to be sent every X hours/minutes/days). Thanks :slightly_smiling_face:

Hi Community! I need some help. Trigger Conditions: When Date Field (“Date Last Used”) is after 12/31/2019 Action Conditions: Update existing checkbox field (“Reviewed 2020”) to Checked Trigger seems to work fine, I just can’t get the action to go. I think it’s because I’m not exactly sure what to input for Record ID. Thanks in advance!

Hi there, i have a problem with my automation in airtable. I’m trying to send this email to two diferents fields but something is wrong.

Hi All, I’m looking for a way to add an automation alert that sends a slack message for a specific condition. I want to specifically track only when a record has an update to a specific field from one specific status to another status from a specified list. I’m not looking to get an alert any time a specific field is updated (in general), but rather, when it is updated from one (or more) specific states, and changed to (an)other specific state(s). e.g. from “Pending” to “not working” → trigger alert or from “Pending” to “needs review” → trigger alert or from “Pending” to “action needed” → trigger alert (Where in this example, the field would be labeled = “status” and the o0ptions in a single select field could be any of “pending”, “not working”, “needs review”, “action needed” etc.)

Hello, I’m trying to use “Mark Duplicate” script in my table but I didn’t get how to use it. I want to check for 2 specific field for duplicate not the complete record. How should I do that? I can’t find accessible guidelines for dummies… Thanks!

Hi All, I am using Airtable as a scheduling system and want to automate (as much as possible) adding world wide public holidays in the calendar view. Are there any suggestions of how to do this? Thanks :slightly_smiling_face:

Hi There! I managed to send an e-mail with a button to myself upon a condition. The button runs nicely updating a record. But in the e-mail, when I click the button, it only opens the whole record, which I don’t need. I would like to have my button run, when I press it in the e-mail. Thanks

I’m using Airtable to schedule work orders for maintenance. I have an automation set up that selects information from a record including the date and time and emails it to those who need to be made aware. The way the date and time is displayed in the automation email is not friendly for other users, is there a way to change this?

Hi there, I use Zapier extensively with Airtable. I have a base that contains one linked table, the rest are all native to that base. I use Zapier to add new records into a native table which works fine. However, when trying to update the newly added record to add content to the linked field that is linked to the synced table I get an error message: “You are not permitted to perform this operation because the table (Table Details) has been configured to limit who can perform this operation.” I am not trying to add a new record into the synced table, rather I’m simply trying to link to an already existing one. Here’s an overview of the flow. Table 1 = Native Table 2 = Synced Add record to Table 1 Find record in Table 2 Edit record from step 1 by adding record from step 2 into linked field. Error. Thanks in advance for any help!

Hi i am looking to set up an automation and having some issues. Basically, for a giving row item, we would like to change the “status” button in the column to “need to order”, if the number in the “stock” column is equal or smaller than the number in “threshold” column. Please let me know how we can do this. Thank you!

I have an automation set to send an email (via gmail) when a record is created (when a purchase is completed - this is one of the tables). This pulls from a number of fields across different tables, via look ups. All the fields populate fine in the preview, or when generating a test, but when an actual purchase is made and the automation is triggered for real, none of them populate in the actual email. I had to re-run the automation (and then it worked fine). The email is sent ok (and to the correct address), but in the body none of the variable fields are populated, and just appear empty. Is the email being triggered too soon? Ie, the fields haven’t actually populated in the record itself before the email is sent? Should I add some kind of delay step before the email is triggered (can’t see a way of doing that)? What else could be going on?

I’m looking to print a record from Page Designer when it comes in to a new view. Any idea how to do that? I was able to do something using Zapier & Google Cloud Print, but it takes too long and Google is killing CP soon.

Hi, i want to manage my WordPress website content efficiently. What is the best way to integrate WordPress with Airtable. I want to keep track of my email campaings i will run and want to keep track of my emails. Thanks