is there a way to add a row to either a google sheet (preferred), an external spreadsheet (2nd preference) or a dt3 spreadsheet every time i add a document to my dt3? in other words a regularly updated list of all the documents i have in here?
No idea, I don’t use spreadsheets.
This script gets all filenames, might be a good starting point.
-- Get list of all filenames
property theDatabaseName : "_temp"
tell application id "DNtp"
try
set theDatabase to database theDatabaseName
set theFilenames to filename of content of theDatabase
#set theFilenames_string to my tid(theFilenames, linefeed)
on error error_message number error_number
if the error_number is not -128 then display alert "DEVONthink" message error_message as warning
return
end try
end tell
on tid(theInput, theDelimiter)
set d to AppleScript's text item delimiters
set AppleScript's text item delimiters to theDelimiter
if class of theInput = text then
set theOutput to text items of theInput
else if class of theInput = list then
set theOutput to theInput as text
end if
set AppleScript's text item delimiters to d
return theOutput
end tid
Does it have to be a spreadsheet - Why not use a smart group that lists all the documents
fwiw I can copy/paste the list into a spreadsheet
I would keep it simple and have the script write the filenames to a .csv file.
It’s easy to import the .csv file into a spreadsheet