Skip to main content

How to batch add texts into field?

  • July 26, 2023
  • 6 replies
  • 34 views

Forum|alt.badge.img+8
  • Known Participant
  • 30 replies

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

6 replies

BillH
Forum|alt.badge.img+24
  • Brainy
  • 180 replies
  • July 26, 2023

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.

 


Forum|alt.badge.img+8
  • Author
  • Known Participant
  • 30 replies
  • July 26, 2023

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.

 


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


Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1261 replies
  • July 27, 2023

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

 
 

Forum|alt.badge.img+8
  • Author
  • Known Participant
  • 30 replies
  • July 27, 2023

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?


Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1261 replies
  • July 28, 2023

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


 

Forum|alt.badge.img+8
  • Author
  • Known Participant
  • 30 replies
  • July 31, 2023

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)?