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

Automations Activity

Automations using a number of days ago record conditions

I have email automations that are sent out when a record matches conditions. When a date is one day ago an email is sent. Overnight this has not worked, emails have sent even though the field date that triggers the email was not one day ago. What cou...

  • 13 Views
  • 0 replies
  • 0 kudos

Putting a range of addresses into a precinct category

I have around 40,000 addresses that need to be assigned to a precinct. I was curious to find out if there was a way to give airtable a range of addresses, so it knows what precinct to put them in, and assign the addresses a precinct automatically. Th...

  • 87 Views
  • 0 replies
  • 0 kudos

Updating Project Status and Milestone Automatically

Hi there,New to AirTable and Automations but was hoping to get some help with setting up my first workspace. I currently have 3 tables: Project PortfolioProject WorkplansProject StatusesIn the first table, I would like to display the Next Milestone a...

Screenshot 2023-11-28 at 2.35.45 PM.png Screenshot 2023-11-28 at 2.40.24 PM.png Screenshot 2023-11-28 at 2.41.05 PM.png
  • 55 Views
  • 0 replies
  • 0 kudos

Copying Automations when Copying a Table?

I have a base where I have a template table - let's call it Table A - that I copy to create new tables with the identical structure (i.e. all fields are the same). Is there any way to have the automations associated with Table A be automatically crea...

  • 57 Views
  • 2 replies
  • 0 kudos
Anna by 6 - Interface Innovator

Scripting: Link Two Records into Record Field at Once

Title.I am still getting the hang of scripting, Airtable, and scripting for Airtable. Goal of script:User chooses up to two options in multi-select field.Those multi-select options are 1:1 with the names of the records that are being linked. (IDs are...

  • 99 Views
  • 3 replies
  • 0 kudos

Consulting?

Hi Airtable community,Does anybody here utilize any third-party consultants to help set up automations and integrations? If so, are you able to recommend any quality consultants that our company can reach out to? Thanks!

  • 64 Views
  • 2 replies
  • 0 kudos

Guidance on Securely Storing API Key in Airtable Automation

Hi Folks,I hope this post finds you well. I'm working on setting up automation in Airtable where a script runs upon creating a record. The script involves an API key, and I'm looking for a secure way to handle it without hard coding.Ideally, I'd like...

  • 57 Views
  • 2 replies
  • 0 kudos
RSk by 6 - Interface Innovator

Airtable export to Google Sheets using Automations

OK someone please help! About 2 months ago the automation I had set up from Airtable to Google sheets simply stopped working. I have reconnected everything but get the follwing error message.Error message "This automation is no longer authorized to u...

  • 69 Views
  • 1 replies
  • 0 kudos

Last email date from Outlook

HiIs there a way to pull a last contact / email traffic date for a selected email address / domain?E.g. I'm emailing with joe@company.com  and I want to have a cell that pulls a date of a last email from Outlook (regardless if its an email sent by my...

  • 56 Views
  • 1 replies
  • 0 kudos

Resolved! Run a script then delete data in a particular column

Hey community, Aundre here. I hope you're all doing well!I found this script on YouTube that works once you're on any table view where applicable. I need to automate it to work without being on a specific view. When I run it from automations, it does...

  • 102 Views
  • 8 replies
  • 0 kudos

Grouped View not Displaying as expected in Email

Hey everyoneHoping someone can point me in the right direction.I have a table where I created a custom view and grouped the records based on a "Service type" field. In the table view I get a few different groups with several records in each group. Th...

mbrinkley_0-1701127091434.png mbrinkley_1-1701127223101.png
  • 188 Views
  • 0 replies
  • 0 kudos

When a record is updated - send an email

Hi all!I'm out of ideas and I need help. I have an automation which sends an email to a specific staff member (it fetches the email of that staff member in my table) when a date field is updated in a record. When I create a record and update the date...

  • 89 Views
  • 3 replies
  • 0 kudos

Resolved! Conditional logic bugged?

Hi,I receive information from a webhook trigger at the beginning of my automation. I want to apply conditional logic based on the values of certain variables in the webhook data (in this case, I'm using Stripe to trigger this Airtable webhook). If yo...

Capture d’écran 2023-11-27 à 04.24.00.png Capture d’écran 2023-11-27 à 04.25.11.png
  • 83 Views
  • 5 replies
  • 0 kudos

Resolved! No JSON data?

  console.log(`Starting...`); let table = base.getTable("Imported table"); let inputConfig = input.config(); let last_name_array = inputConfig.last_name.split(' '); let formatted_first_name = last_name_array.shift(); let formatted_last_name = last_...

  • 274 Views
  • 2 replies
  • 0 kudos

Resolved! How to Find records within a dynamic date range

HiI have two tables: Table A that has a period_start_date and a period_end_date and Table B has a bunch of rows with a date columnIn an automation that's triggered by a particular row on table A (which means I know the period_start_date and period_en...

  • 167 Views
  • 4 replies
  • 0 kudos

Connection between Airtabl and Zapier issue

We have connected our event registration from Wordpress to an Airtable table through Zapier and it was working for a while until it started glitching.. After a while we only started seeing part of the registrants, while the other part is not showing ...

  • 131 Views
  • 1 replies
  • 0 kudos