Got it to work. Clunky, but it does it!!
Here:
set theScriptSource to "tell application id \"DNtp\"
set thisList to {}
set thisRecord2 to get record with uuid \"%@\"
set thisRecordProperty to %@ of thisRecord2
copy thisRecordProperty to the end of thisList
copy thisRecord2 to the end of thisList
return thisList
end tell"
set theScriptSourceWithProperties to current application's NSString's stringWithFormat_(theScriptSource, theRecordHere, myproperty)
-- log theScriptSourceWithProperties as text
set theScript to (current application's NSAppleScript's alloc()'s initWithSource:theScriptSourceWithProperties)
set theNSAppleEventDescriptor to (theScript's executeAndReturnError:theScriptSourceWithProperties)
set theScriptResult to ((current application's NSArray's arrayWithArray:{theNSAppleEventDescriptor}) as list)'s item 1
try
set theValue to item 1 of theScriptResult
on error
set theValue to missing value
end try
It is getting properties one by one based on the label of the current list item in a giant repeat loop. That’s perfect.
Sending it the uuid and the property label does it — it finds the record, gets the value, and returns it in the two item list
At some point, I’ll clean up the list returned - no need for the second item to be there, but I wanted to get the result as fast without figuring out how to parse the single item NSAppleEventDescriptor. Just need the value for now and that worked perfectly!
Now, if I could only get the actual rich text into the final sheet! The plain text can work but would prefer to carry the formatting