Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Need to populate a new field with data from another without having to edit the record

I have 116171 records so I don't want to do this manually. I have a formula field where I'm subtracting between 2 other fields. That works, but the result only shows in the new field if I open, ed...
App builders
Formulas and functions
Tips and tricks
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Stephanie.


If the formula calculates correctly on one record it will work in all 11,000 records.


Perhaps the other 10,999 Record have different data that you expect in those fields.


Do you have a form rule populating some fields which only kicks in when the record is being edited?


If so, what does the form rule do?
ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago
Yes, it works BUT ONLY if I Edit the record. I don't want to edit over 100k records.