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

Automations Activity

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!

  • 20 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...

  • 29 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...

  • 29 Views
  • 0 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...

  • 38 Views
  • 1 replies
  • 0 kudos

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

  • 76 Views
  • 5 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
  • 175 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...

  • 75 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
  • 63 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_...

  • 267 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...

  • 154 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 ...

  • 123 Views
  • 1 replies
  • 0 kudos

Create an algorithme with script automation

Hello, I am trying to create an algorithme in AIRTABLE using the script automation. I have 3 tables : Mission_Request, Cookers and Companies. My script compares all the pattern in both Mission_Request (wich is connected to Companies table) and Cooker...

  • 78 Views
  • 0 replies
  • 0 kudos

Automating from one sheet to another

Hello!I am just starting out with AirTable and I am trying to create an automation that when an item is moved to the status "Backorder" (this should happen when the field "B/O Qty" is greater than 0) in my "Open Orders" project, it is then duplicated...

  • 91 Views
  • 1 replies
  • 0 kudos

Automation Code help

I am trying to assign 4 different users records as the come in.  I found this code const collaborators = [ {name: "Person 1"}, {name: "Person 2"}, {name: "Person 3"}, {name: "Person 4"} ] const chosenOne = collaborators[Math.floor(Mat...

  • 115 Views
  • 1 replies
  • 0 kudos
Alg by 4 - Data Explorer