Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 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
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago
 I have the following fields
  • Total Count of Holes prev 2w - Numeric Field
  • Total Count of Holes prev 2w Text - Text Field
  • Total Count of Holes prev 4w - Numeric Field
  • Total Count of Holes prev 4w Text - Text Field
  • 4w-2w Total OOS - Formula-Numeric - ToNumber([Total Count of Holes prev 4w Text])-ToNumber([Total Count of Holes prev 2w Text])
I have form rules that write from the Numeric Fields to the Text Fields set up so that I can do the formula that is in the Formula-Numeric Field.