Hi we have a table that has calculated fields, we are importing data into the table via API but the calculated fields are not calculating? Does anyone have an easy fix
Alan shared this idea · Jan 31, 2018
API and Calculated text field
Hi we have a table that has calculated fields, we are importing data into the table via API but the calculated fields are not calculating? Does anyone have an easy fix
Alan shared this idea · Jan 31, 2018
Comments
1 comment
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.
Please sign in to leave a comment.