anyway to test if.. another log user is in a record?

[RodM]

Is there a InUse_Record like command?

 

I have a CMR.. and multi agents are working the file...
I need a way to know if a operator already in use on the record,  

..if so to bypass to next record not in use

 

All i can think is write my own when in record to occupy a field, when leaving record clear a field,    then test is record is occupy before landing on it in my Nav code?

 

or another idea?

 

 

TIA   Rod

 

 

[Wim Decorte]

Typically you would use the "open record" script step and check the error.  If the record is in use by another user it will generate an error in the 300 range.

[RodM]

thanks

[RodM]

Trying your suggestions..

 

My Viewer monitoring    get (last error   and last error states not changing 

 

in main destop Filemaker machine...    if i am  FM lic or Go appi in a 2nd machine,  say David in record 3

When I Nav Next record next until i get to David record 3      or same record view in other user...  Doesn't cause a error ?

[Vaughan]

Confusion about what it means to be "in" a record... 

 

FMP uses record locking to prevent a record from being edited by more than one user at a time. FMP only locks a record if a user is editing a field value and the record is bot committed (ie as Wim said, the record is open). It is NOT locked if a user is just viewing a record. Multiple users can view records simultaneously, FMP is built to allow this explicitly.

 

AFAIK there is no way for FMP to tell if a user is just viewing a record. You'd have to create a user-record tracking system. Not sure how...

[Wim Decorte]

If you wanted to track who is viewing what you can use the "view" section of the privilege set and use a plugin to write that info somewhere.

It may significantly slow down your solution depending on how you do this.

[bcooney]

Perhaps assign records to users (ownerID) and use rla view calcs?

[RodM]

thanks all.. 

If I didn't say.. i anticipate several users using a CMR of records of leads, more than several marketing agents working the group, and don't want 2 operators using same records!  1) create field CMR -inUse..    set each time,   clear current field/ set X when Nav button next/previous/top/bot  occurs
inspecting where possible a record ID changes,
problem..  X out of FM... or not clear current record manage those possible ways? 2) sounds better.. instead, assign groups records per user ID..  as already suggested -bcooney Thnks...   I am aready marking agent to record... when agent leads are import, so i think continue on that schema, and script to mark group of records or more records belonging to Agent ids