Common Errors & Fixes for Amazing Fields Formulas

This article covers the most common issues users encounter when working with formulas in Amazing Fields, and how to resolve them.

Formula is not updating after I edited it

Unlike a spreadsheet, Amazing Fields does not evaluate formulas in real time while you're editing them.

Fix: After saving your formula changes, make a small edit to any field on the card to trigger a recalculation. The formula will then evaluate with the updated logic.

Equality comparisons are not working

In Amazing Fields, you must use double equals ==    when comparing two values, not a single equals sign =   . A single =     means "set this value", while ==     means "check if these two values match."

Fix: Go through your formula and replace any single =     used for comparisons with ==   .

Random values keep changing unexpectedly

RAND()    or RANDBETWEEN()    this means the value changes every time any field on the card is touched.

Fix: Avoid using random functions if you need a stable output. There is no built-in way to 'lock' a random value once it has been generated.

Empty date fields are behaving unexpectedly

Since the default value of an empty date field is1/1/1970 00:00:00   , this can produce unexpected results when checking whether a date has been set.

Fix: Use YEAR(DateField) > 1970    to check if a date field actually has a value.

You can't see the +Card Field or +List Field buttons

These options only appear when the field has been configured as a Single Card Field. Without that setting, Amazing Fields treats the field as shared across all cards, and cross-card references are not available.

Fix: Go to the field settings, open Card Display options, and set the Single Card Field option to the specific card this field should belong to. The cross-card reference buttons will then appear in the formula editor.