I’ve got an interesting problem and it has to do with dealing with rich text and custom meta data.
I have several variants of an AppleScript that collect custom meta data from certain records — the records list is volatile from day to day and has to do with the status of a project whether it is in the places this Script works on.
The goal is to collect relevant metadata, annotations, and custom meta data and dump them into a table — it’s a customized “Create metadata overview” however it does some work in addition to what that script does besides filtering. Plus, I was never able to figure out how to run the “create metadata overview” by way of a script, so I just did it.
At the end of one section of the script, it has build an AppleScript list of records, one of the list items is a rich text object copied from a custom meta data setting with the type Rich Text.
I dump the list of records into the cells property of a sheet I created in the script.
So the script does this:
set DTCells to myGiantListOfRecords
Set mySheetName to “any name you want “
create record with {name:MySheetName columns:colDescriptions cells:DTCells type:sheet}
It works other than placing the rich text object. Is there a way to do this and get the rich text in the cell of the sheet?