[✔️ DONE] Formula: numbers + text

[Haslien]

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.

[Polina_Zenevich]

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 ^^

[mdubakov]

Now you can create such formulas, using ToText function

CHANGELOG: December 9 / Automatically generate entity Name, Convert Numbers and Dates to Text, Braintree and Discourse integration

Finally, a decent release. Automatically generate entity Name using a text formula Sometimes you don’t want to set entity Name manually, but assemble it from several other fields. For example, for an Interview, you want to have a Name that consists of Contact Name and Interview Date. There is a special action for an entity “Generate Name using Formula”. Click … in entity view and find it. Here is the flow: [2020-12-09 15.35.08] Note: When you create a formula for Name, it will update all en…

[Carl_Lange]

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?

[Chr1sG]

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)