I created a field A of type Formula, and the formula includes the ID field (which is auto-incremented).
When I add a new record and submit it, field A remains empty.
Only after I click Edit and Submit again does field A get updated.
I assume this happens because the ID field isn’t available at the time the formula is first calculated, so the formula field A cannot be updated immediately.
How can I fix this issue?
Yes, your understanding is correct — the issue happens because the id field doesn’t exist yet when the formula is first calculated upon record creation.
As a workaround, you can use a workflow triggered “after record creation” to update the formula field once the id is available.
This issue has been noted, and we’ve recorded it for further evaluation by the development team.
1 Like
Workflow can fix. Many Thanks.