Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Invert the check boxes in a long text field

Topic Labels: Formulas
Solved
Jump to Solution
1847 4
cancel
Showing results for 
Search instead for 
Did you mean: 
J_V
5 - Automation Enthusiast
5 - Automation Enthusiast

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,

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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 

Screen Recording 2023-01-31 at 3.19.12 PM.gif

See Solution in Thread

4 Replies 4
bruceconsulting
7 - App Architect
7 - App Architect

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
18 - Pluto
18 - Pluto

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 

Screen Recording 2023-01-31 at 3.19.12 PM.gif

J_V
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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