Skip to main content
K
kellyq2641
November 7, 2024
Solved

new custom record field for a record type - not getting refreshed fast enough

  • November 7, 2024
  • 4 replies
  • 0 views

Hi All,

I have created a new custom record field for a record type - this new record field depends on a relationship with another table .

So when I'm writing to the child table(relationship table) how long does it take the main table with the new custom record field to get updated?

I'm asking this because first I write to the child table then I want to write to the main table using this new custom record field for a calculation. The issue I'm facing is that the main table record field is not getting updated quick enough before it writes - its considering as if the new custom record field is empty , I tried adding a sync node before writing to the main table but is still not working.

Any recommendations here?

Best answer by stefanhelzle0001
The issue I'm facing is that the main table record field is not getting updated quick enough before it writes - its considering as if the new custom record field is empty , I tried adding a sync node before writing to the main table but is still not working.

How did you test this?

What king of custom field is this?

4 replies

stefanhelzle0001
stefanhelzle0001Answer
November 7, 2024
The issue I'm facing is that the main table record field is not getting updated quick enough before it writes - its considering as if the new custom record field is empty , I tried adding a sync node before writing to the main table but is still not working.

How did you test this?

What king of custom field is this?

    K
    kellyq2641Author
    November 7, 2024

    Process model - I have a node that writes to the child table and then the sync node and then  the write records to the main table - the custom field is a sum of values from the child table. I need that sum to divide it with another number and save it in the main table.

    I even added a timer before the final write to records to see if the record will update in one minute or less but no luck.

    stefanhelzle0001
    stefanhelzle0001
    November 7, 2024

    Please help me, you write something to table B, then to A. You did not describe where you read that sum!?!

    So, writing to records is a transaction, and the node returns only AFTER all data is written and updated. So ... in my understanding, there is nothing like a waiting time.

    Terms & ConditionsAccessibility statement