Skip to main content
Known Participant
Nov 7, 2024 6:20 PM UTC
Solved

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

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?

stefanhelzle0001
Brainy
Nov 7, 2024 6:27 PM UTC
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
Brainy
Nov 7, 2024 6:27 PM UTC
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?

Known Participant
Nov 7, 2024 7:07 PM UTC

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
Brainy
Nov 7, 2024 7:42 PM UTC

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.