Mark record as opened

[cspuser46]

I have one table that is used by many users.

And my question is :

If one record is opened by user1 and If user2 opens the same record, too I want to show user2 somehow that someone else is already working on that record.

Is there any way to do that?

Thank you.

[ShWolf]

Hi,

Seems that this is impossible to implement with JS.

[KTMedia]

I asked the same question several months ago.

The official reply was, "This requires custom programming. Contact Caspio for price quotes."

It would appear that record locking is not implimented without additional cost.

The method I used was to have an "admin" assign records to specific "agents."

There are tutorials that cover this in the help section.

[bahar_vm]

Correct, if you want certain records to be accessible to specific user then use Record Level Security explained at http://howto.caspio.com/authentication/ ... -security/

Best,

Bahar M.

[robelliott]

That doesn't help if you don't know which record a user will need to work on. For an enterprise database it seems an astonishing lack of forethought by the developers that allows one user to open a record and start to enter data, then a second user opens the same record with no warning. The first user saves his data then the second user saves his data - and immediately overwrites the data entered by the first user which is then lost! It has happened to us today. There should be some way built in to prevent the record opening again or at least warn the user, not as a piece of custom programming we have to pay extra for.

[elizeb]

It is difficult, but not impossible. I am not an expert but one with sound knowledge can do that. I recommend searching on the Google can do the trick.

_________________________________________________________

free joomla 1.5, 1.6, 1.7, 2.5 templates | free wordpress themes

[telly]

Hi @cspuser46,

It seems that it is possible, but you need to add a logs table and auto submit and update  record.
 

Upon login of the user there will be a autosubmit on the user log then if the user logout it will update the logs table, basically, it will show the logs of the user.