Forum Discussion

LynhRowe1's avatar
LynhRowe1
Qrew Member
2 years ago

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

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 l...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

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
------------------------------