Trigger on record deletion

[Frankywinky]

Hi,

I want to be sure: it is not look possible to put a script trigger on record deletion, isn't it?

Frank

[bcooney]

A script trigger or a script?

[Lee Smith]

Script Triggers are a version 10 only feature. Prior to v10, you could use a plugin to do what Script Triggers in v10 does.

However, your question needs a little more about what you are trying to accomplish, not just the words trigger, and Script.

Lee

[mvRobert]

The answer is no.

You can take care of a delete with a button connected to a script that the user must click or by changing the menu and connect delete record to a script. You need FileMaker Pro Advanced to change menus.

[michael3785]

You can get what you want here by using a plugin like ZippScript and editing the delete privileges for the records in the table.

If you put an expression in the delete privileges calculation and this expression calls a ZippScript "PerformScript" function then the script will run when the user tries to delete the record as the expression must be evaluated before Filemaker knows if it can go ahead and delete the record.

You can also then use the result of the function you have called as part of the expression to return 1 or 0 to determine if the delete gets a allowed or not.

[Lee Smith]

Hi Michael,

I would think that since Frankywinky hasn't been back since 07/12/09 that they have found a solution to their question.

Unfortunately, I don't think that ZippScript is available anymore. I'm not sure of its current status, but I did a Google Search and found this article Link where it states in part

The plug-in, and the site which offered it, was officially discontinued in mid 2008 and disappeared. The circumstances regarding the shutdown were unknown until we were contacted by Alamark. At their request, the plug-in was removed from this site and it is suggested that you no longer use this plug-in for triggering scripts.

If you have more current information about this, please share with us.

TIA

Lee

Edited January 15, 2010 by Guest

[Chris Dragon]

ZippScript may be gone, but you can use other free script running plug-ins like 2empowerFM Script Scheduler (script.dracoventions.com).

To make this work, go to:

File > Manage > Permissions > Privilege Sets > New... > Records > Custom privileges...

Pick a table (this has to be done one table at a time, unfortunately, and can't be applied to [Any New Table]) and click the Delete pulldown menu at the bottom. Choose "Limited...".

In the calculation window that appears, put something like this:

epScriptQueue("Delete Record Trigger") + 1

The "+ 1" tells the calculation to allow the record to be deleted. If you don't include + 1, FileMaker shows an error dialog like "This operation could not be performed because you do not have the requested access privileges for one or more records". If you're willing to show the user that error, then you could have the "Delete Record Trigger" script decide whether or not to actually delete the record. As long as the script has "Run script with full access privileges" checked at the bottom of the Edit Script dialog, it won't call your delete record permissions check again.

Also, in the "Edit Privilege Set" dialog, be sure to change "Available menu commands:" to "All" or the user you assign the privilege set to won't have permission to choose the Delete Record command at all.