Help

How to batch add texts into field?

Topic Labels: Data
1904 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Xing
6 - Interface Innovator
6 - Interface Innovator

Hi, 

How Can I batch add texts into a text field? Please see attached, how Can I add text "outdoor" into "Note" field under the exist texts?

thanks

Screenshot 2023-07-26 at 4.56.02 PM.png

6 Replies 6

Assuming it's a one time thing.

1.  Create a formula field as "Outdoor "&{Notes}   (brackets are not necessary for a one word field, just included for clarity)

2. Change the field type or the new field to Long text.

3. Delete the existing Notes field.

4. Rename the new field to Notes.

 

Xing
6 - Interface Innovator
6 - Interface Innovator

It's not a one time thing, I would need this function to regularly update the field

Then just hold your formula field, make it hidden, to avoid 'double outdoors' transform to something like 
IF(FIND('Outdoor',Notes),Notes,'Outdoor '&Notes)
And when you need to update, copypaste whole formula column to your Notes

 
 

I'm sorry I didn't understand.

Your suggested solution seems only require me everytime copy and paste, no?

Yes.
Of course, you can write a script to add 'outdoors ' to all values, where it absent, and run it by pressing the 'Run' button in extensions. But I don't think it so much better and faster than just copy-paste column


 

Thank you, however, how could I possibly continuously add some texts? for example: now I want to add "outdoor" to all the records, but maybe i would like to add another "BYOB" text in record 1 and 2 (not all the records)?