Initial values for fields marked as KEY have stopped working

I just started getting errors about the key for records being required… and upon investigation I’m finding that the formulas (initial value formulas) are not working anymore.

Here’s the formula setting the initial value (notice it pulls the value from the name column):

Yet this is the behavior I get in the form:


  • At least on this app I’m seeing this issue, just checked another and it was working fine…
  • If I go into the field and actualy make a physical change, then the formula works - but if a value used in the formula (to derive the key value) is set via a formula, the initial value formula doesn’t catch that data

To clarify this bug:

I’ve got an initial value formula that set’s a fields value (which is marked as the key). This formula uses values entered from another field (the Name) in the same table.
The Name column has it’s own initial value formula that pulls some text using a de-reference.


  1. The reference column is set
  2. the name is derived
  3. the key is derived.

The key portion of this seems to be buggy now.

If I change the value that’s set by the initial value, THEN the key setting formula works:

1 Like