Jan 30, 2023 09:21 AM
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:
Should become:
I've tried to use the "LEN" formula but haven't been able to produce anything working.
Many thanks,
Solved! Go to Solution.
Jan 30, 2023 11:20 PM
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
Jan 30, 2023 12:20 PM
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
Jan 30, 2023 11:20 PM
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
Jan 31, 2023 01:55 AM
Many thanks Adam!! Works just fine, time Saving indeed!
Jan 31, 2023 10:19 PM
Hah that's the goal! Glad I could help!