AnsweredAssumed Answered

PACS Integration with FileMaker Solution

Question asked by steven.mete on Oct 24, 2018
Latest reply on Oct 25, 2018 by Johan Hedman

Hi All,

I am a newbie.


I am running a FileMaker Server that is hosting my solution and am integrating (ODBC) with PACS Server. I have already configured DSN and added two PACS tables using relationship graph. I have added a relationship between to the two external tables and a relationship between filemaker table and external table.


On my related table layout (in filemaker) i have created two buttons: import & view. Import button will get data from fm table field (text) and import related data from external table field into another fm table field (container). View button will get imported data in fm table field (container) and open with web browser.


Import Script:

     set variable [$$filmno]

     set field [Table::FieldName; $$filmno]

     execute sql - select fieldname2 from table where fieldname1 = $$filmno

     import records [dsn: dsnname; calculated sql text: exttablename::field; add; Windows ANSI]


View Script:

     set variable [$$film]

     set field [Table::Field; $$film]

     open url ["urladdress"]


I am confused with the above scripting and need help.