AnsweredAssumed Answered

Perform Script only if user modifies existing record

Question asked by msei on Jul 15, 2018
Latest reply on Jul 18, 2018 by ThierryGuemboura

Hi,

I'm using FMP 17 Advanced.  I have a child table with looked up values from a parent table.  When data from the parent table changes, I want to relookup the data and update the corresponding child data.  I have written a script to execute this successfully.  My problem is, the script is triggered by "OnObjectSave" for the field in question.  This causes my script to trigger even when the user is entering a new record versus editing an existing record (with associated data in the child table)...

 

I changed the trigger to "OnObjectEnter" to allow me to test for whether the record is a new or existing record, but I don't know how to do that and still allow the user to update the field value.  Any ideas would be most helpful.

Thanks,

Mike

Outcomes