![]() It is true that, opposite to TapForms, it features real formulas (the visual editor is buggy but the text editor works well), triggers, conditional display, constrained drop down lists and tabs in forms. What a disappointment! There was no trial version so I bought the Mac and iPhone version to test synchronization and features. Copy the link from DEVONthink, paste it to TapForms – it’s not always necessary to write software to solve workflow issues. KeyboardMaestro (or, in different ways, TextExpander and Typinator) are powerful allies of DEVONthink when you need to interact with other applications.Īlternate: another way to do this is to use Split View with TapForms on one side and DEVONthink on the other, open to a group list such as Three Pane View. With a shortcut assigned to your macro, you’re on your way. If the goal is to pause on a field in the database, open the group selector to choose a group in the database, get the reference URL for that group, then paste it back to the database – you can do all that with a KeyboardMaestro macro that either manipulates DEVONthink’s menus to get the item link, or a macro that has a version your script embedded to get the reference URL (item link and reference URL are the same thing different terms used by DEVONthink). You’re already working with the top candidates.īut consider if you really need to have your script control both the database program (FileMaker or TapForms) and DEVONthink. ![]() Unfortunately, short of going full bore into SQL, there’s not much available on OS X for relational database management. Actually it is possible to use the web field type to hold the DT link but it requires a manual copy/paste, and missing AppleScript support means no way to implement features such as real calculated fields (currently no if/then/else statements or comparison operators in calculated fields).Īny idea? Is there any equivalent application to Tap Forms that supports n:n relationships and AppleScript? Unless I haphazardly try to emulate the keyboard, I don’t see how I will be able to create the same link as I could do with FileMaker. So, if I accept to lose the advanced features of FileMaker Pro Advanced such as the local web server, Tap Forms offers exactly what I would need… except it has no Applescript support. Also, with no more than checking a checkbox, you can see the corresponding linked entries table in the other table (other direction of the relationship). In no more than 10 seconds, you can ask the program to search and pick an existing entry, or create a new one using the standard form. Linked entries, even in many-to-many relations, work perfectly. Then I tried Tap Forms, and appreciated it, considering I value the ease of configuring new fields. Searching and linking to an entry from a linked table should be the bread and butter of personal database software. Of course I will manage after some more time, but this is clearly unacceptable considering the price of this piece of software (€600) and the fact that computers and software are supposed to do for us repetitive tasks. Even by copying what is shown in the program’s sample solutions, I couldn’t get to a working result after several hours. However, FileMaker is a real pain and required advanced scripting and UI hacking when it comes to a feature as elementary as linking the current entry to a new or existing entry in a many-to-many linked table (n:n relationship). Set dtRecord to (get record with uuid dtLink) Set dtLink to cell "DEVONthink Group" of current record I could also create a “Open DT Group” button that opens the linked group in DEVONthink. If the errorNumber is not -128 then display alert "DEVONthink script" message errorMessage as warning Set cell "DEVONthink Group" of current record to dtLink Tell application "FileMaker Pro Advanced" Set dtLink to ((uuid of thePickedGroup) as string) Set toDatabase to the name of the database of thePickedGroup Set toPath to the location of thePickedGroup If thePickedGroup is then error "No group was picked." Set thePickedGroup to (display group selector "Pick a group to link to FileMaker's current record.") The group’s UUID is then stored in a field I called “DEVONthink Group”. Therefore I have been able to create a proof of concept with a “Link to DT Group” button in a FileMaker form that opens the DEVONthink browser and allows the user to pick a group that holds all documents related to the current entry. It is powerful enough to write proprietary scripts that can launch an Applescript. Two years after having dropped it, I’ve tried again FileMaker Pro Advanced (I have version 13).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |