Need to have only "currency/intergers " in a string.
But sometimes the customer writes charecters int the mapped field.
Anybody know how to check for tha ?.
I have tried replaceALL and matches - but the designer does not allow that.
I simply need to show another text, it the current field does not match only a currency.
My script - Line 3 fails with the currencyNoSymbol when text are in the string.
var result = “”;
var Total = record.fields[“ValueCustoms”];
var Total = formatter.currencyNoSymbol(record.fields[“ValueCustoms”]);
if (Total !== “”) result += ‘’ + Total;
else result = ‘0,00’;