You have created a field with a formula in onOffice (e.g. a link field containing the form URL including the Estate ID), but the formula does not calculate automatically in the existing records — the field remains empty even though the formula is correct.
Formulas in onOffice fields are only calculated when the respective record is saved. If you create or change the formula afterwards, the existing records remain unaffected — the formula only takes effect when someone opens and saves the record.
However, with 500+ records, it is unrealistic to open and save each one individually.
onOffice has a function that saves all records once without actually changing anything — thereby recalculating all formula fields:
→ onOffice processes all records once. With 50 records, this takes a few seconds; with 1,000, several minutes.
To ensure the formula is actually calculated, two checkboxes must be ticked in the field’s administration:
Without these checkmarks, onOffice will skip some records.
An onOffice limitation in formula fields: you cannot access the UUID of a linked address from the property form (and vice versa).
propform solution: Instead of creating the address link in a formula field within the property, use the “Automatically load related records” function in propform — see Link records → Auto-load.