User inputted math formula

[victsei]

I guess the answer is no, but is there a way for allowing the user to input a simple math formula, such as 1+1 that would be recorded as 2?

For context, I have an app for inputting financial statements and there are fields (e.g current assets) that would be a sum of multiple lines from the actual financial statement.

[AleksiAlkio]

Well.. answer is no.. and yes. You could calculate the result with the Event action when the form is saved.

[victsei]

Interesting...and would I go about parsing it so I could calculate the result? Any simple way?

[AleksiAlkio]

If it's always a "+", then something like..
NUMBER(INDEX(SPLIT([Text],"+"),1))+NUMBER(INDEX(SPLIT([Text],"+"),2))

[gregdiana1]

If you need a - just add as a negative number

[AleksiAlkio]

Or.. reading it from the string 🙂