FAQ
FAQ
When using Formulas in Ragic, you might encounter questions like:
“Why did the formula work at first but stop updating after I modified it?”
“Why didn’t the formula trigger after importing data, using Update Value on Another Sheet, or Convert Record?”
This is due to a key rule in Ragic: Formulas only trigger where the data is entered. By default, a formula is triggered only when you manually enter or edit data directly on the same sheet (interface) where the formula is defined.
If you add or modify a formula after a record is created, the field won’t automatically recalculate based on the new formula.
That’s because formulas only trigger at the time of data entry. In other words, if the formula is added or modified after data has been entered, it won’t apply to existing records unless they are manually edited again.
This behavior helps optimize system performance and prevent unintended changes to existing data.
To apply the updated formula to all existing records, you can either manually edit each record to trigger recalculation or execute a formula recalculation to trigger it in the backend without manual input.
For more information, refer to the formula documentation.
A formula will not trigger unless the change occurs directly on the sheet where the formula is applied.
For example, if a formula is set on the "Order" sheet, editing related data—such as pricing—on another sheet (e.g., the "Product" sheet) will not trigger it. The formula will only recalculate when you edit data directly on the "Order" sheet (e.g., changing item quantity).
Also, if data in the "Order" sheet is updated through other features rather than manual input, formulas may not trigger automatically.
In such cases, additional configuration is required, which will be explained below.
When updating fields in another sheet using an Action Button (such as Update Value on Another Sheet or Convert Records) or through Import, formulas will not trigger unless "Recalculate all formulas" is checked in the Advanced Settings.
In Ragic, the Form Page and Listing Page are considered separate interfaces. Formulas set on one will not trigger when editing data on the other. For example, if a formula is set only on the Form Page, editing the same field on the Listing Page will not trigger it—and vice versa.
If you often edit data on the Listing Page, it is recommended to add the relevant fields and set the same formulas in its design mode. This ensures formulas work correctly regardless of where the data is entered.
Each version in a Multiple Versions sheet has its own independent formula settings. Formulas must be configured separately for each version if needed.
If the same field uses different formulas across versions, ensure the calculated results remain consistent; otherwise, values may be overwritten when switching versions.
You can use Field Info to check the formula configuration for the field across all versions.
For New Sheet from Subtable or Referenced Subtables (Show References From Existing Sheets), navigate to Form Settings in the left sidebar under Form Page Design Mode, and enable "Recalculate all formulas on parent or related sheets". For more details, please refer to this documentation.
(1) Formula Syntax Errors
Ensure the formula is written correctly. For Conditional Formulas (IF Function), note the following:
(a) Refer to this section to check if .RAW is required in your formula.
(b) TODAY() and NOW() cannot currently be used directly inside IF(). Instead, create a separate field to calculate TODAY() or NOW(), and reference that field in your Conditional Formula. See examples here.
(2) Field Type and Formula Mismatch
Some formulas only work with specific Field Types. For example, arithmetic or comparison operations apply only to Numeric, Money, or Date fields.
(3) Formula Recalculation Errors from Auto Generated Fields
The final saved value of an Auto Generate field may differ from what is shown during data entry, especially when multiple users create records at the same time. Two users might see the same auto-generated number, but once the first record is saved, the second user’s value will update to avoid duplication.
If a formula references this Auto Generate field, the result may appear correct before saving but become incorrect afterward.
To prevent this, use a post workflow to trigger a backend formula recalculation upon saving when your sheet includes formulas that reference Auto Generate fields.
(4) Daily Recalculation Issues with the TODAY Formula
Refer to this guide for troubleshooting steps.
To update formulas for existing records, you can either enter Design Mode and run a Formula Recalculation on the sheet or create an Apply All Formulas to This Record Action Button.
If you need the system to recalculate formulas automatically on a daily basis, for example when using TODAYTZ() to check the current date, you can set up a Daily Formula Recalculation workflow.
