Forum Discussion

MackenziePhilli's avatar
MackenziePhilli
Qrew Trainee
5 years ago

Action not working on Summary Field

I have a quickbase action that is set up to copy over changed fields when a record is added on the parent table. In the list of fields I'm copying are two summary fields (totals) from two child tables. The action is not copying the two summary fields when the action is triggered. Any reason why this is or how to fix it?

------------------------------
Mackenzie Phillips
------------------------------
Quickbase Automations

1 Reply

  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Since your action is based on the Parent record being added, the Summary fields do not yet have any value. Even if your Child records already exist and are automatically connected to the Parent once the Parent is saved, the Summary field won't have a value until after the Save action. The Quickbase Actions use the value of a field from 2 points in history: 1) Before the record interaction began and 2) When the record interaction was completed. In this case the 1st point would be before the record was started and the 2nd point would be when the user selected the Save button.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------