API and Calculated text field
Hi we have a table that has calcualated fields, we are importing data into the table via API but the calculated fields are not calculating? Does anyone have an easy fix
John McGarvey commented
I am not familiar with how the TrackVia API's work, but calculated fields should be calculating when data is added/updated.
I do know that Apps Scripts do not run during import and/or bulk updates, so perhaps this is the same scenario. For this, I've had to update each record separately to get the script to run.
You may want to load a default view (all records). The system is supposed to run any calculations each time a view is loaded, unless you are using Triggered Fields, in which case you are back to updating each record separately.
I'll be watching for replies on this as I am interested in this also.