Why Didn’t the Field Apply the Default Value?

Default Values work similarly to Formulas, Auto Generate fields, and Link and Load. They are generally triggered only when new records are created, as they are intended to provide initial values during record creation. In most cases, Default Values do not apply when editing existing records unless specifically configured.

For example, if you set a Default Value for a field in Sheet A, the system will automatically apply it when you manually add a new record or create one via Convert Records.

However, if you set the Default Value after the record has already been created, it will not apply when editing existing data. Similarly, Default Values may not apply when records are created or updated using other methods.

If you notice that some fields are not showing the expected Default Values and want to apply them, refer to the scenarios below to check and adjust your setup.

Apply Default Values to Empty Fields in Existing Records

If a field previously had no Default Value and existing records contain empty values for that field, newly added Default Values will not be applied automatically. In this case, you need to click Populate empty values to apply the Default Values to the existing data.

Apply Default Values via Advanced Settings

If your sheet has Default Values configured but records are created or updated through other methods (for example, Import or Action Buttons), you need to enable additional settings to apply Default Values on the sheet:

1. When Importing data, check the option "Fill in default field values" in the Import Advanced Settings.

2. When configuring an Update Value on Another Sheet Action Button, check "Load all default values on target sheet" or "Load all default values on this sheet" in the Advanced Settings.

Other Issues

Some Default Values only work under specific conditions. For example, the $SEQ auto-numbering Default Value works only in Subtable fields, not in independent fields (use an Auto Generate field instead).