Hi
Am trying to make a script to trigger on record load.
I have set the script in the trigger. But it keep looping the script..
If i start the script manually it works fine. So am guessing there is something wrong with the trigger it self ?
Or is there another way to make a script run every time a new record is entered ?
Am running Filemaker 14 Client on windows OS.
I've implemented a very simple log, a bit like you do as the client didn't want a full log file.
Here is how I log the deletion of a portal row for example:
And this is the corresponding TOs in the database graph:
The "Allow creation of records..." is ticked for the log TO, so when I set a field in this table in the script, it creates a new record and set log_create to the auto-enter creation timestamp of the log record (it kind of does the relationship itself).
That's how you can log specific things without changing layout.
Hope this helps