Help
Automations
cancel
Showing results for 
Search instead for 
Did you mean: 

Automations Activity

Date Past Automation

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. 

screencapture-airtable-apptbiKrv9KU2WNTS-tblK4kwTcELw2jPeO-viwDP8xhxaw8QEZQj-2023-03-30-19_04_26.png screencapture-airtable-apptbiKrv9KU2WNTS-tblK4kwTcELw2jPeO-viwB8j2LmHgu9IxV2-2023-03-30-19_05_16.png
  • 35 Views
  • 1 replies
  • 1 kudos

Airtable and ETapestry or Blackbaud

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 cre...

  • 25 Views
  • 1 replies
  • 0 kudos

Add Task and Assignee from one table in another

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 Tim...

Screenshot 2023-03-30 at 18.28.06.png Screenshot 2023-03-30 at 18.27.05.png Screenshot 2023-03-30 at 18.29.01.png Screenshot 2023-03-30 at 18.29.16.png
  • 28 Views
  • 1 replies
  • 0 kudos

Resolved! Trigger formula field update with automation

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 curren...

  • 30 Views
  • 1 replies
  • 0 kudos

Resolved! Automation: Update record from a different table

I'm trying to create an automation to update a record. I want to change the status of all tasks associated with a sprint to have an "archived" when that sprint is "done".The trigger is based a table called "Sprints Lists" with a condition of "Status:...

Screenshot 2023-03-29 at 20.07.54.png Screenshot 2023-03-29 at 20.08.09.png Screenshot 2023-03-29 at 20.08.17.png
  • 49 Views
  • 4 replies
  • 0 kudos

Error when creating event in google calendar

Hello everyone,I come again to ask for your help on the automation for integrating Airtable records into a Google Calendar. This automation only works when I duplicate my event in Airtable. I attach the capture of my automation. Do you have a trick t...

  • 50 Views
  • 1 replies
  • 1 kudos

connecting two columns on different tables

HiI have Table 1 with two columns (A and B).On my Table 2, I want to ask airtable to take the Table 2 column A and "read" or match any words to Table 1 Column B and automatically tell me where the matches are instead of linking then having to manuall...

  • 32 Views
  • 0 replies
  • 0 kudos

Automated Emails with Records Ordered by Date of Each Event

Hello! I am hoping to send weekly staff wide emails detailing a list of upcoming programs and events at my Foundation. I set up the Automation and it works well. However, the dates are ordered by when a record was created and not based on the actual ...

Screenshot (37).png
  • 32 Views
  • 1 replies
  • 0 kudos

Woocommerce API in script automation

Hello,First, sorry for my english.I'm new in javascript development and i'm trying to update some product on my woocommerce website from airtable.In the automation, i have a script where i try to retrieve a product, i use this code :   const reponse ...

  • 34 Views
  • 0 replies
  • 0 kudos

Slack integration not working

Hi everyone!I'm trying to create a simple automation to send notifications on a specific Slack channel once action X occurs. PROBLEM: when I try to connect my work Slack account, Airtable tells me that "the selected account is not valid or no longer ...

  • 98 Views
  • 2 replies
  • 3 kudos

Resolved! Scripting for a dummy: remove a single linked record

I need an automation to remove a linked record from a linked record field, without removing all linked records from that field.For instance, if a student is in enrolled in the courses 'knitting for war, animal husbandry and marriage, ice cream + pies...

  • 75 Views
  • 5 replies
  • 0 kudos

Sending stripe invoice from Airtable

Hi everyone,I am following along a tutorial and creating a CRM where I can send stripe invoices from: Send stripe invoices from Airtable | AATT#17 (30:00)I am in the process of catching a webhook from the 'send invoice' button in the 'invoices table'...

Screen Shot 2023-03-28 at 1.10.04 PM.png Screen Shot 2023-03-28 at 1.11.50 PM.png Screen Shot 2023-03-28 at 1.13.06 PM.png Screen Shot 2023-03-28 at 3.40.39 PM.png
  • 43 Views
  • 1 replies
  • 0 kudos

Outlook received email trigger - Unsupported input expression key

Hello,I am unable to set up the trigger for an outlook email received. It looks like the api is not able to get access to the "folders" data.The error message returned is : "Unsupported input expression key" (see screenshot below).Does this has to be...

alphrb_0-1680022060128.png
  • 46 Views
  • 1 replies
  • 0 kudos

Resolved! How to input workflow data into a JSON body through Script

So, with my limited scripting and Java skills I've been trying to set up a script that will call a webhook so I can later trigger something there. I managed to set up the basic ping but I came across the ideal of sending some record ID's I need which...

  • 64 Views
  • 3 replies
  • 0 kudos