13 Replies Latest reply on Nov 20, 2014 10:05 AM by TSGal

    Get ( ModifiedFields ) doesn't return a correct result in separation-model


      Get ( ModifiedFields ) doesn't return a correct result in separation-model


      FileMaker Pro


      Advanced 13.0.1

      Operating system version

      Windows 8.1

      Description of the issue

      This function never returns a result in separation-model.

      PMJ answered in another discussion: http://forums.filemaker.com/posts/a2dc3cd3bf
      that using a onexit-scripttrigger to show a dialog with the result of Get ( ModifiedFields ) would yield a list of modified field and calculated field as a result of changes of the current an uncommitted record.
      However the filemaker-help doesn't mention the calculation fields, instead that says: "Returns a list of fields that have been modified in the current record of the current table."

      This function shows in my (data-/interface-separated) solution only a lot of ¶ as result in any script that's called before a record is commited.

      Steps to reproduce the problem

      A solution where data and interface are separated

      Use Get ( ModifiedFields ) in any script or scripttrigger whilst the current record has been changed ( Get(RecordOpenState) in the same script results in 1 or 2).

      Expected result

      get a ¶ delimited list of fieldnames that have (or are going to have) changed content in the current layout's tableoccurrence

      Actual result

      A lot of ¶ (it looks like depending on the amount of actually affected non local fields) but no fieldname at all

      ("Non local fields" mean: field from the tableoccurrence that the layout is based on, that is actually situated in another file. So it is the local table and not a related table.)

      Exact text of any error message(s) that appear


      Configuration information

      This solution runs with data and interface separated. So the table is not local, however it works as a local table in any other aspect.


      un-(data/interface)seperate my solution, which is not an option of course. This function would be the only one to require that in order to work, which is a bit odd.

      For now I use my old script that makes a kind of snapshot of the content of the current record, which I check against changes before committing it.