arnoldkegebein

Get( RecordOpenState ) returns 3?

Discussion created by arnoldkegebein on Nov 27, 2017
Latest reply on Dec 1, 2017 by arnoldkegebein

FileMaker Pro 16 help page for the function Get( RecordOpenState ) [https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/get-recordopenstate.html] says about possible return values:

Returns:

  • 0 for a closed (committed) record
  • 1 for a new record that hasn’t been committed
  • 2 for a modified record that hasn’t been committed
  • 3 for a deleted record that hasn’t been committed

In previous FileMaker versions only the return values 0…2 are mentioned.

 

I have a hard time to create a scenario where Get( RecordOpenState ) will return 3.

First I tried an OnRecordCommit trigger script, but unfortunately, the trigger will not fire when the record is deleted.

 

Does anybody ever had or can create a situation where the return value is 3?

 

~Arnold

 

That reminds me of all the product ideas around triggers:

onRecordCreate, onRecordDelete and onRecordModify script triggers

More triggers, with BEFORE and AFTER; new AfterScriptError trigger

Trigger OnMouseClick and function Get( TriggerMouseClickInfo )

onRecordExit script trigger

onIdle Script Trigger

Buttons AND Script Triggers in Preview Mode

and so much more

Outcomes