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

Hi Stephanie,
Could you please post your formula here with the type of all 3 fields so I can try to assist you?

The formula works. This issue is populating the field.

Hi Stephanie,

Sorry it is not clear to me. Where are you subtracting 2 fields? Where does [2 HR Notification] come into it?

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?

I put in the wrong comment before. Please ignore that one.

The formula works but it only calculates/populates the field when i open, edit and save the record. With over 100k records I don't want to do that.

I'd like to find a way to get the new field to update without me having to edit the records.

Do you have form rules in that form which are populating fields? Based on your question, you must.

What is the form rule doing?

 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.

If you have numeric fields, make the formula on the numeric fields.

ie, do the formula on the fields which do not rely on form rules.  Form, Rules are only intended when real like human users edit a single record.

The Numeric fields are Numeric Lookup fields. I had to bring them in from another table because they are Summary fields in that table

I'm still not understanding why you need the form rules and why you need to be using a formula which depends on data created by a form rule.