AnsweredAssumed Answered

Refreshing a calculation field with SQL

Question asked by NicholasWelander on Mar 31, 2015
Latest reply on Apr 2, 2015 by NicholasWelander

Title

Refreshing a calculation field with SQL

Post

I have a calculation field that uses ExecuteSQL to determine its value. The SQL finds a specific field and the calculation field is the result. I've tested the SQL in data viewer and it works. Also, when I set or change the calculation and save the change, it reflects the correct value. However, when I change the referenced field from 1 to "" or back, the change does not show. The calculation is unstored and the result is a number.

Would an auto-enter work better? Is there another solution? Worst case, I can script the checkbox to manually change the field and any other fields, but I'd rather not.

Outcomes