I think what I’m about to ask is a known and straightforward procedure. But it’s not known (or recalled) by me at the moment. Thus this asking-in-public question.
Goal: I want to export selected fields from a TB file, to a spreadsheet-compatible file, to share it with some colleagues who usually work with spreadsheets.
Specs:
-
In the relevant TB file, each note has about 12 Key Attributes.
-
I want to export (a) each note’s $Name, which will be the first column of each derived spreadsheet item; (b) five or six of the KA’s, one of which is Boolean and the rest of which are Set-type ($CityName; $SourceName; etc), so that these form columns in the spreadsheet; and then ( c) each item’s $Text, which can range in length from a few words to several paragraphs. This will also constitute a field in the spreadsheet, presumably the right-most column on the screen, though some long $Text entries may be truncated.
-
I can think of some clumsy workarounds for the exporting I want. (For instance, I could create an attribute $ExportText, and could have a rule setting that to each note’s
$Name + (all the relevant KA's) + $Text, with appropriate dividers among each attribute.) Or, I could create a duplicate of the file; could remove all the attributes that I don’t want to export; and work from there. -
But I think there must be a more straightforward way to export a group of notes, with the relevant KAs and $Text, in a form appropriate to import, drag-drop, or copy/paste into a spread sheet.
Is there such a way? Could someone explain it? Thanks!