How to prevent multiple users to edit one record at a time?

I created a database connection using Chronoconnectivity, and multiple users edit it using the form created in Chronoforms. How to make so that if a user edits a record, another user will not be able to edit the same record. And remove it from the list Chronoconnectivity or blocked while editing? Thanks!

PS On the same model as is done with Articles editing in Backside of Joomla
PPS Sorry for my English😟

Hi Smelkoff,

This isn't built in to ChronoForms or ChronoConnectivity :-( You'd need to hand-code the feature.

I think it would work if you add a 'checkout' column in the table; add Custom Code actions in the form On Load & On Submit events to check the record out; and add a check in the WHERE box of the CC Listing to ignore checked out records (or perhaps better to show them but disable the edit link).

Bob

[list][/list]

Hi Smelkoff,

This isn't built in to ChronoForms or ChronoConnectivity :-( You'd need to hand-code the feature.

I think it would work if you add a 'checkout' column in the table; add Custom Code actions in the form On Load & On Submit events to check the record out; and add a check in the WHERE box of the CC Listing to ignore checked out records (or perhaps better to show them but disable the edit link).

Bob

Ok, I like it and I do, but
How can I disable the edit link for these records?

And what if the user started editing a record and press the back button in your browser, a record to a change of its status will not happen and it will become available. Is there any solution?

Hi Smelkoff,

I would probably do it with a Custom Listing, if you have the checkout value in the $Row data you can use PHP to check and only show the link if it s OK.

Bob

Hi Smelkoff,

I would probably do it with a Custom Listing, if you have the checkout value in the $Row data you can use PHP to check and only show the link if it s OK.

Bob

Can any example for this?

Hi Smelkoff,

Not easily, I've never tried to do this. I suggest that you take a look at the Joomla! Checkout locking code. That will probably do more or less what you need.

Bob