Check out this interesting write-up from Temmy to know how with the help of Azure SQL Server + Dataverse Custom API, you can implement a simple architecture solution to handle concurrency in Dataverse.
We can implement calculated columns using Dataverse formula columns (using Power Fx), and that should be the first choice. But that won’t work in offline mode. Using the Power Apps Grid customizer control, Diana made it work offline too.
Microsoft is continuously working on providing a richer and seamless experience while setting up the security model. With this new feature, you can add security roles from other business units to a user besides the user’s standard business unit.