Hi,
I’m having issues with calculating profit for an invoice line.
What i do, is create and order on one sheet via API, order contains a subtable linked to another sheet with sold items.
Then, create sold items via API, theese are linked to the correct order. Many fields in the ordered item sheet are populated via link and load from another sheets, which happens with a bit of a delay.
At the end, i want to calculate gross profit for a sold item based both on fields populated via API, and fields populated via Link and Load, but the formula doesnt recalculate after link and load populates the fields, leaving me with a value of 0.
I’m looking for a way to trigger formula recalculation after all data is available in a given record.
So far, i’ve tried setting up a daily workflow, to trigger formula recalculation on this sheet, but it doesnt’ do anything (code: db.recalculateAll(“rejestr-sprzeday/3”;).
Will thank for help 
Hi there,
It looks like the issue is just a missing forward slash in your formula recalculation script before the tab path. Please try updating it by adding the slash, and that should allow the daily formula recalculation to work correctly.
If you still run into issues with the daily formula recalculations afterwards, please write to us at support@ragic.com and include the complete URL to the Ragic sheet in question so we can take a closer look.
Source: Daily Formula Recalculation
1 Like
Thank You! that solved the problem 
1 Like