Hi - I have set up a new template that creates a .tsv with the following headers: Record#string Status#string Comments#string URL#url
Are there #types other than those listed here that we can use? i.e. for my Status field i would love it if i could specify a lookup list using the likes of #list(done,to do, not started) etc. Another one i would like is #item that would let me find / add an item in the database. I couldn’t find anything in the docs/help about this.
Edit: I know #date is another one that we can use.
As I see it, TSV is nothing but a variant of CSV – a quite dumb table format. And as that does not support anything but simple text (in the guise of text, date, number, url), I don’t believe that you can do what you want.
Thanks for your reply. I know it can’t as a standalone plain text file but Devonthink does support the likes of #date and #url when appended to the column name so was wondering whether there was some additional things it could be made to do.
You could use Data > New > Sheet… to create the template and then export it via File > Export > As Template…
2 Likes
Interestingly, I didn’t see anything about these “#thingies” in the documentation. I now found some TSV files in the template folder. If you check out the Email Accounts template, you’ll see this (in the German sub-folder):
"Typ#set{values:IMAP|POP3}"
So there does seem to be a way to provide a list of values. Your #list(done, to do, not started) might be possible as "Tasks#set{values:done|to do|not started}".
That will still only add the strings to the underlying table, though. And all the #url type seems to do is convert the entry to a clickable something – there’s no check at all that the entry is a valid URL, AFAICT.
@bluefrog: Perhaps these features could be documented some time? The whole “Template” section is quite terse 
1 Like
Should have thought of that! Works great. And i can see in the output that the type specifiers i was looking for are:
#crosslink#set{values:Found|Not found|Unsure}
I’ll have a think about this.