Skip to main content
Question

Formula to convert text line to number string

  • Mar 24, 2020 4:24 PM UTC
  • 0 replies
  • 325 views
Hello All,

Looking to convert up to 60 character text fields to a number that is unique to that specific text.

Has anyone solved for this before?  Basically for each response would like a unique number or if the same response happened it could share that number also. 

Hope this makes sense.




------------------------------
letsmakeitbetter letsmakeitbetter
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • Mar 24, 2020 4:48 PM UTC
Hi,

So would the number being output by this 60 character text field also be a 60 character number?

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
MarkShnierYou
Forum|alt.badge.img+24
How many digits does the number need to be limited to?  Can it be a text string using 0-9 only?  Actual Quick Base numeric fields cannot have more than about 13 digits before they loose accuracy.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement