Forum Discussion
MarkShnier__You
3 years agoQrew Legend
not tested but try this
var text TextConvertedToNumericAndBack = ToText(ToNumber(Trim([My Text field field])));
IF($TextConvertedToNumericAndBack = Trim([My Text field field])
and
Length($TextConvertedToNumericAndBack) = Trim([My Text field field]), "Y", "N")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text TextConvertedToNumericAndBack = ToText(ToNumber(Trim([My Text field field])));
IF($TextConvertedToNumericAndBack = Trim([My Text field field])
and
Length($TextConvertedToNumericAndBack) = Trim([My Text field field]), "Y", "N")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------