Default value is not working

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered
In field properties, I have set a default value in a numeric field.  However the value is not populating in the field.
Photo of Lynne8817

Lynne8817

  • 530 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,792 Points 50k badge 2x thumb
It will only default ion for new records created going forward.  If you need to also update all the historical records, you can use grid edit or else run a list all report and use the more button to Find and Replace.  Let me know if that Answered the question and I will change this to an Answer and not just a Comment.
Photo of Lynne8817

Lynne8817

  • 530 Points 500 badge 2x thumb
Answered. Thank you.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,792 Points 50k badge 2x thumb
btw, If you want to mass update records but no dirty them with updating the date updated and the name of who last modified, you can change the new field to a formula field and enter a formula of the default value, such as true in the case of a checkbox field.

Then change it back to be a data entry field and it will retain its previous formula value, but it will not show you as the [Last Modified by]. often you want to preserve who actually was the [Last Modified by] and [date modified]