AnsweredAssumed Answered

Update Calculations in Script doesn't update all previous records

Question asked by mchopra94 on Feb 19, 2019
Latest reply on Feb 20, 2019 by user19752

Hi All,


I am new to FileMaker and trying to update a rounding calculation in a script from 2 decimal point to 6, but it didn't update the calculation for all the previous records.


FTE = round ( x+y *2;2) to FTE = round (x+y*2;6)


FTE is a number type but the calculation is done through a script rather than Auto-Enter Calculation. How can I update all the previous records?


I read somewhere that Replace Field Contents can't be used for calculations. So what are my options?