Skip to main content

Using formula in automation fields


Hello,
The automation fields don’t currently allow calculations in fields.
For example, I want to create an automation that pulls the date from a selected record and adds or subtracts a number of days from that. It would be a very useful feature to automate some project tasks without having to manually enter the dates. I’m giving an example with dates but automation would be largely enhanced if we could use formulas in fields.
Thank you.

13 replies

ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8730 replies
  • January 21, 2022

Yes, this would be very helpful.

In the meantime, you can create the formula fields in your table, hide them so you don’t have to see them, and then refer to those formula fields in your automation.


  • New Participant
  • 3 replies
  • August 15, 2022
ScottWorld wrote:

Yes, this would be very helpful.

In the meantime, you can create the formula fields in your table, hide them so you don’t have to see them, and then refer to those formula fields in your automation.


Hi @ScottWorld – I’m attempting to copy a value from a formula field into a new field and it’s not pulling a value.

The goal is to create master filters in a different table, for example, Day of the week. Is this not supported?


ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8730 replies
  • August 15, 2022

I’m not sure what you mean? Do you have a video or a screenshot of what you’re trying to do?


  • New Participant
  • 3 replies
  • August 17, 2022
ScottWorld wrote:

I’m not sure what you mean? Do you have a video or a screenshot of what you’re trying to do?


Figured it out! I needed to convert the field to text with CONCAT or &“”.


Karlstens
  • Inspiring
  • 601 replies
  • January 5, 2023

Formula's within Automations are absolutely needed.

It's insanity to build Formula Field after Formula field, or, write a Script Action for what is often just a simple/tiny manipulation of data from a field - often incrementing or adding a number or two. Example screenshot below of what I image we could see.

Similarly to Script Actions not being available within a Pro Trial, Formulas within Automations could also be greyed out to prevent abuse. 

As much as MS PowerAutomate Flow grinds my gears, I do like the ability to write equations where I need to - and Airtable Automations would leave Flow in the dust if it had a similar Formula feature.


  • Known Participant
  • 67 replies
  • March 22, 2024

EssentiaL


  • Participating Frequently
  • 5 replies
  • May 19, 2024

Essential


  • New Participant
  • 1 reply
  • May 31, 2024

Essential !


DougL
  • New Participant
  • 3 replies
  • July 9, 2024

Totally Agree!
Creating formula fields on the table that are only used by automation seems silly and clutters up the table. Adding the likes of CONCATINATE, ARRAYJOIN, etc.... would be happy days!


  • New Participant
  • 1 reply
  • September 11, 2024

Agree. I'm about to write a script now, which could be a simple math calculation as in Karlstens' example.


  • New Participant
  • 3 replies
  • September 25, 2024

Would like to see this as well. 


ClarifyThis
  • Participating Frequently
  • 9 replies
  • January 30, 2025

Still currently inserting a script action and/or delegating to formula fields for this, which is less than ideal:

  • Certain environments and clients do not allow scripting
  • Business logic baked into code is less desirable from a client maintainability point of view
  • Formula fields bloat tables with 'always on, always available, all records' calculations that may only be required for a handful of records a few times a month.
  • Delegating to formula fields scatters traceability and promotes loose coupling. It is easier to accidentally change (and break) a formula than it is to find out what it impacts and how it impacts it. (Cue "DO NOT CHANGE" and "LINKS TO AUTOMATION XYZ" labels everywhere and links to (outdated) documentation outside of Airtable)

Sometimes we just want to add 7 days to a due date. Would be great if we didn't have to build a Rube Goldberg machine every time and explain why we need to do so to our clients.


  • New Participant
  • 1 reply
  • February 21, 2025

+1 , this feature it is a must have.


Reply