Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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

johnch by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Resolved! Automated Slack message - Chronological list?

I have an automation which sends a slack message at a scheduled time with a list of tasks due that week, sent in formatted single messages for display purposes.It's a repeating action which runs through a list found, but it never runs in chronologica...

Alix by 5 - Automation Enthusiast
  • 1 replies
  • 1 kudos

Daily Email - Monthly and Weekly Sales Report

Hi, I have a sales team that inserts every sale into a DB on to Air TableI would like 2 do an automation that sends me a daily report with1 - Sales on current month (how much)2 - Sales on current month (how many) 3 - Sales on current week (how much)4...

Resolved! lookup field grabs records not already linked in another linked field

Hello!I have a base with 3 tables:a Contacts table,an Organization table, anda Membership table. In the Organization table, I have a linked field to the Contacts table called "All organization contacts" where I link all Contacts records associated wi...

jadeadele by 5 - Automation Enthusiast
  • 8 replies
  • 1 kudos

Syncing a SUM to another table in a different base

I have a table that I use to calculate expenses for a specific project. I would like the SUM of one of the columns to automate/sync/roll up/whatever?? to another record/field that is located in a different BASE (for invoicing purposes). Can this be d...

Is it possible to see what's changed?

Hello Everyone,I would like to use Airtable to share order status with my teammates. Because the finished date or customers' requests often change, I need all members to follow up on the newest changed content.Though I can know when each project is c...

Resolved! Calculating difference between Dates from the same field

Hi all,The data from the table below is from another table using Automation:Once the status of a request ID is updated, then the update time of each status will be automatically recorded in this table.Is there any way to calculate the time difference...

Dorrie_0-1678330638624.png Dorrie_1-1678331307887.png
Dorrie by 5 - Automation Enthusiast
  • 6 replies
  • 2 kudos

Automation question regarding Inventory Tracking

Hello,Was curious if it was possible to set an automation to basically trigger an email if inventory is based on a % of x being low, rather than an exact number?QTY = < %So if I have 1000 labels, and I'm running low, and already utilized 50% of that,...

krtphr by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Find records with similar text field data

When record text field is not empty, find records with similar text fields and link records? Is this possible? The similarity could be a partial match.

Alix by 5 - Automation Enthusiast
  • 0 replies
  • 0 kudos

Adding +1 in Table/Tab 1 when a record match Table/Tab 1 and 2

Hi, I would like to add +1 to a #Number column to a dedicated Name line in one table as soon as a record is created in another table including the same name. Is it possible?Thank you very much Example:Table/tab 1Name.      Surname NumberYohan       L...

YohanLafon by 4 - Data Explorer
  • 12 replies
  • 1 kudos

Resolved! Send automated e-mail to a group of people meeting criterias

Hello everyone I work for a school and some workshops are made in groups of students.For instance, I need the 6 people from the Thursday, 11am slot to receive the same e-mail, visible e-mails in the "To:" field, and to Cc their trainer.Is there a way...

bichette by 4 - Data Explorer
  • 1 replies
  • 1 kudos

create automation to auto update workback schedule

Hello! I have an event workback schedule set up with a formula column to auto-generate a due date based on what date I specify in my date column (see ex. formula below). However, I would like to have the formula column auto-generate a list of due dat...

meg1 by 4 - Data Explorer
  • 0 replies
  • 0 kudos