Can a formula numeric field be converted to a text field and not affect how past data is displayed

Question

Hello, I have a numeric-formula [Result fixed] field that returns a null value based on whether another numeric [Result] field is greater or less than defined numeric values. Moving forward I would like to not have the formula return a null value, but instead actually display the less than or greater than sign and a value. For example if the [Result] is &lt;4.0 (i.e. 3.5) then the [Result fixed] would display "&lt;4.0".&nbsp;
Can I change the [Result fixed] from a numeric-formula field to a numeric-text field and if so will it change how past data is displayed (data entered prior to the change)?&nbsp;------------------------------lrowe------------------------------

markshnier__you · Answer

Yes, you can change a formula numeric field to be a formula text field, and it will recalcuate for all existing data. If this field is used in a lookup field to another (child) table, then you will need to make a new lookup field or else change the lookup field ot be a text field and then change it to a lookup field and hook it to the right relationship and set which field to pull down from the Parent.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Forum Discussion

Can a formula numeric field be converted to a text field and not affect how past data is displayed