How do I...?

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

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Alan shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • John McGarvey commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base