# \[✔️ DONE\] Formula: numbers + text **URL:** \ **Category:** Ideas & Features\ **Created:** [September 23, 2020, 9:55am UTC](https://community.fibery.io/t/done-formula-numbers-text/1006 "2020-09-23T09:55:03Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Haslien](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/haslien/32/493_2.png) [@Haslien](https://community.fibery.io/u/Haslien)\ **Post date:** [September 23, 2020, 9:55am UTC](https://community.fibery.io/t/done-formula-numbers-text/1006/1 "2020-09-23T09:55:03Z")
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. ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [September 25, 2020, 9:27am UTC](https://community.fibery.io/t/done-formula-numbers-text/1006/2 "2020-09-25T09:27:24Z")
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 ^^ ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [December 9, 2020, 12:57pm UTC](https://community.fibery.io/t/done-formula-numbers-text/1006/3 "2020-12-09T12:57:44Z")
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](https://community.fibery.io/t/changelog-december-9-automatically-generate-entity-name-convert-numbers-and-dates-to-text-braintree-and-discourse-integration/1224): > > 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… ---
**Author:** ![Carl\_Lange](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/carl_lange/32/5049_2.png) [@Carl\_Lange](https://community.fibery.io/u/Carl_Lange)\ **Post date:** [May 17, 2022, 7:01pm UTC](https://community.fibery.io/t/done-formula-numbers-text/1006/4 "2022-05-17T19:01:48Z")
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? ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [May 18, 2022, 6:13am UTC](https://community.fibery.io/t/done-formula-numbers-text/1006/5 "2022-05-18T06:13:05Z")
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) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 4, 2024, 6:48am UTC](https://community.fibery.io/t/done-formula-numbers-text/1006/6 "2024-10-04T06:48:13Z")