Hi, How I can store only number field in Free-Form...
# suitescriptl
Lucas
09/03/2018, 11:27 AMHi, How I can store only number field in Free-Form-Text field of custom record? My User event is storing in '2.0' always and I want to avoid that and only want to store number field value like '2', Can I set formula field? If yes then how?(I don't want to use Integer field for some reason) Anyone can help me?
s
samyt
09/03/2018, 11:30 AMDo you want the field to be free form ? If you make it as interger type only the number will be saved
l
Lucas
09/03/2018, 11:33 AMNo, I want to free form, no Integer
s
samyt
09/03/2018, 11:36 AMYou mean you want to store only interger ? in the free form ?
l
Lucas
09/03/2018, 11:37 AMYes, correct
Lucas
09/03/2018, 11:37 AMno any decimal
s
samyt
09/03/2018, 11:38 AMYou can use a native javascript to do that !!
l
Lucas
09/03/2018, 11:38 AMNo man, Its not allowing in free form text field, I tried almost all JS.
s
samyt
09/03/2018, 11:39 AMWhere are you getting the value for free form?
l
Lucas
09/03/2018, 11:39 AMin Suitescript if you uses Free form text field and try to store integer it will always store as 1.0 no 1
Lucas
09/03/2018, 11:40 AMI am getting value in one of my user event.
s
samyt
09/03/2018, 11:43 AMShare your code
k
karlenigma
09/03/2018, 11:47 AMAre you storing as a string?
l
Lucas
09/03/2018, 11:49 AMNo, I am converting it to number using parseInt
k
karlenigma
09/03/2018, 11:53 AMThat is probably why. As freeform is just a string.
l
Lucas
09/03/2018, 11:54 AMhmm, true but still any option?
k
karlenigma
09/03/2018, 11:54 AMCan you post your code where you are setting the value?
c
chriswebb
09/03/2018, 12:18 PMI think I have had this issue before. I was calling the toString method on the number before setting it in the field. If you just pass the number in, it should work.
k
karlenigma
09/03/2018, 12:19 PMMy thoughts exactly!
c
chriswebb
09/03/2018, 12:21 PMI am not sure why, but in the debugger it shows 5.0 as a result of parseInt("5")🤔
l
Lucas
09/03/2018, 12:38 PM@chriswebb let me check this..
Lucas
09/03/2018, 12:40 PMvar mynumber = '1.02';
var a = parseInt(mynumber);
Math.round(a);
Output: 1.0
Lucas
09/03/2018, 12:40 PMAbove code will always give you result in 1.0 formart
k
karlenigma
09/03/2018, 12:41 PMAccording to console it will give 1. But not sure on a script.
karlenigma
09/03/2018, 12:43 PMi think you need to change
al
Lucas
09/03/2018, 12:44 PMHmm, This works.. 😀
👍 1
Lucas
09/03/2018, 12:50 PMThanks you.
j
jkabot
09/04/2018, 2:27 PMcontributing late, but numbers in javascript are always floats
if you want to represent a number with a certain amount of decimal places use the
toFixedjkabot
09/04/2018, 2:28 PMe.g.
Copy code
var x = 1;
console.log(x.toFixed(0)); // 1
console.log(x.toFixed(2)); // 1.00👍 1