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 |