I have a column with text that I send out as tweets.
Sometimes this column has more then 256 characters and cannot post to Twitter.
In those situations, I’m hoping to split the column into two so that I can send out two separate tweets.
I was using SPLIT(text) however that splits based on character count and sometimes it breaks the words in half.
I’m hoping to split the text without breaking the words.
Unsure how to use it with Airtable Scripting block. Can anyone help me use this within Airtable?