Skip to main content

Airtable Automation - Update Record

  • September 15, 2020
  • 2 replies
  • 19 views

Forum|alt.badge.img+3

Is there a way via Automations-Update Record to set the Field value to a formula? I’m able to correctly set the trigger (tests successfully) and have set the Update Record Action to Record ID of the record(s) captured in the trigger.

I can set my field output to a specific value (i.e. string for example), but I’m not seeing a way I can set the field update value to anything leveraging a formula. Is this currently supported does anyone know?

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • September 15, 2020

Create a formula field with the formula that you want. Then update the actual field with the value of the formula field at the time of the automation.


Forum|alt.badge.img+3
  • Author
  • Participating Frequently
  • September 15, 2020

Create a formula field with the formula that you want. Then update the actual field with the value of the formula field at the time of the automation.


Thanks for the help on this, that works great!