Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Batch Update values using existing field value

Topic Labels: Extensions
681 1
Showing results for 
Search instead for 
Did you mean: 

Hello, all. I’m tinkering with the Batch Update block, in order to update values in a single-line text field. I’m looking to append text either to the front or end of the field’s existing values.

Is there a way to reference a field’s existing value in the “New Value” box? So if the field I’m updating is “Name”, I would write something like [Name] & "_AddThisText"

…or does the Update Value process only update to literal text strings?

1 Reply 1

The Batch Update block currently cannot reference a text field’s existing value.

If this is a one-time change, you can create a temporary formula field for the value you want. Then copy/paste the new value to the original field.

If this is an ongoing change, you can create a script in Scripting block to make the batch updates.