Default Value doesn’t auto-fill when another column is edited after creating a new row

1

Hi everyone,

I’m trying to set up a table with two number columns:

  • Fixed Base Price

  • Sale Price (should automatically copy Fixed Base Price, but still remain editable)

In the Sale Price column, I set a Default Value formula:

thisRow.[Fixed Base Price]

My expectation:
When I create a new row and then type a value into Fixed Base Price, the Sale Price column should automatically fill with the same value — while still allowing me to manually override it if needed.

But here’s the issue:
When a new row is created, Sale Price does not auto-fill.
It only fills after I manually click “Apply default to blank rows” in the column options.
I want this to happen automatically, without manually applying it.

So my question is:

How can I make a column auto-fill based on another column after typing the value, while still allowing the user to override the auto-filled value?

Notes:

  • A formula-based column won’t work because it becomes read-only.

  • I want Sale Price to behave like a normal editable field, but pre-filled from Fixed Base Price.

  • Automations work, but they feel too heavy for such a simple use case — I’m hoping there’s a cleaner solution.

Any advice would be appreciated!

1 Like
2

Hi @gasimmammadov1,

The default value is only applied when the row is created. Since at that moment Fixed Base Price is blank, Sale Price is also blank.

The most straightforward solution would be an automation, like you mention.

Another solution could be a button, that checks which items don’t have a Sale Price and then copies the value from Fixed Base Price. You would introduce some items and when you are done press it. Something like this:

[DB items].filter([Sale Price].isBlank()).forEach(
  currentValue.modifyRows(
    [Sale Price],
    currentValue.[Fixed Base Price]
  )
)

Hope this helps,

Pablo

4 Likes