Skip to main content

Calculate mathematical expression in text form

  • February 1, 2022
  • 2 replies
  • 45 views

Hello!
Is there a way to calculate the value of a mathematical expression which is written on a long text field?
For example (long text field: 340+850 and formula field: 520)

2 replies

Dimitris_Goudis
Forum|alt.badge.img+20

Hey @Dionisis_Priftis,

welcome to Airtable community.

You your case you have to extract the numerical info from long text fields and then use the exports in formula calculation.
I hoe my response helped you and for any deeper support please feel free to text at any time.

Yours sincerely,
Dimitris Goudis


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • February 1, 2022

@Dionisis_Priftis Airtable doesn’t offer an “Evaluate” function like other programming languages do, so I don’t think there’s any way that you could do that natively with an Airtable formula, unless all of your mathematical expressions are always going to look similar to that one — with a single known operator in between 2 values.

Although perhaps you could do something with Regex or a custom script.