Automation to update a long text field with the va...

[J_V]

Over time our long text field with bullet points has evolved into 100+ lines and we're looking for a way to no longer add new bullets at the bottom of the field, but rather at the top. Hence the very logical question: on existing long text fields how could one "invert" the bullet points. As an example:

• Item 1
• Item 2
• Item 3

Should become:

• Item 3
• Item 2
• Item 1

I've tried to use the "LEN" formula but haven't been able to produce anything working. 

Many thanks,

[bruceconsulting]

Hi,

Unfortunately, I don't know of a method to sort from within one long text field.  To insert a new bullet at the top, you can use ctrl+home and then enter to give you a bullet at the top of the field.  Another option is to use a multi-select field, but there isn't a quick way to do this.  You would have to convert 100 bullets to 100 options but in the end it won't turn out as "pretty" as a bulleted list, although it would be able to be sorted.

If you'd like to schedule some time with me to discuss this or have other questions, here's a link to my Calendly:  https://calendly.com/bruce_consulting/30min

[TheTimeSavingCo · Accepted solution]

I've put something together here for you within a script extension that I think does what you're looking for

Do me a favour and make a backup of your data before using it on your production base heh 

[J_V]

Many thanks Adam!! Works just fine, time Saving indeed!

[TheTimeSavingCo]

Hah that's the goal!  Glad I could help!