Get (OpenRecordState) returns 3 values:
- 0 for a closes or committed record
- 1 for a new record that hasn't been committed
- 2 for a modified record that hasn't been committed
So unless the returned value is not 0, it's open and not saved.
... Get ( RecordOpenState ) but I cannot get it to work ...
I guess you used a script, can you show the script ?
When I create a record I do get a 1 result. When I edit a record by selecting a field along with a blinking cursor, should I get a 2?. I currently get a 0.
I should say I'm doing this with a Symbol.
What do you mean doing this with a symbol ?
I select Symbol from the Insert menu and select RecordOpenState. I did this so I can see the actual returned value. I am also using conditional value formula for a button. Get ( RecordOpenState )=2
1 of 1 people found this helpful
Just tried it. Thing is the Symbol value is not refreshed automatically when the value changes. If you wish to see the value change, then on each field you need set a script trigger on OnObjectModify that would refresh the window.
You get the same issue if you set conditional formatting on an object based on the value of Get(RecordOpenState).
Thank you very much!