Re: Batch Update values using existing field value

538 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.