[✔️ DONE] Formula: numbers + text

I have found a need for combining text and int inside the a formula to create a string output.

My specific case is just a text version of “% complete”, but both numbers are of interest.
Orders.Filter(State.Final = true).Count() + " of " + Orders.Count()

For now I’ll have to separate them in to two different fields.

Hi, Martin!
That is smth not possible now, but we plan to add it soon, as this is a must for our planned feature “Generated Name field”.

Noted, and will text back after the implementation ^^

3 Likes

Now you can create such formulas, using ToText function

I need to do the opposite - create a number field out of the string “532.13” (taken from the content of an email subject). It doesn’t seem like this is possible yet?

It’s possible with an automation to update a number field when a text field is updated, but it requires a bit of JS (and the number field will not be read-only, whereas a formula would be)