Skip to main content
ericc087568
March 6, 2025
Question

Custom record field aggregate sum 'Test' shows in Field editor, but not in 'Data Preview' editor

  • March 6, 2025
  • 4 replies
  • 0 views

Hi all,

I'm a bit new with custom record fields, so I'm probably doing something wrong.

I have header and detail records (with a one-to-many relationship connected with a detail reference to the header key), and that data flows throughout the system just fine. 

But I added a real-time aggregation / sum custom field (for totaling amounts in the detail record for presentation) and am having trouble getting data into the new fields.

When pressing the 'Test' button in the Edit Custom Record Field screen, I see data grouped and summed as needed which is great!

After saving the new custom field, the 'Data Preview' test button does NOT return any data in the new field, and that is also the case with an interface that references this.

I've done resync on both records.  The new custom field exists on the detail side of the relationship and when defining the field, I use the format: headerRec.detailRec.amountToBeSummed.

I've also tried coming at it from the header side (starting with related detailRec), but still have the same issue.  I'm testing this out as admin, so I can't think that it's a security thing.

Any ideas?

Here is good data test when considering only the field:

And here is data preview that cannot populate the new field:

    4 replies

    March 6, 2025

    According to the documentation about real time evaluations, "The custom record field values ​​are calculated whenever the field is actively referenced in your applications." Refer this link: Custom Record Fields

    ericc087568
    March 7, 2025

    Hi, my editable grid on my interface is actively referencing this custom record field, but no data.  Other fields that are on the same record show fine (the ones that are not custom aggregated fields).  I must be missing something about the construction of these custom fields.

    March 10, 2025

    Hi [mention:67b551afda1a425baefbb1f6acea1a59:e9ed411860ed4f2ba0265705b8793d05] 

    Can you provide the interface code snippet where this custom field is referenced