I hope everybody is doing great. I’ve got a unique scenario that I believe that Grist supports but before I dig in to resolve the issue I’d like proof of the concept.
I’d like to implement a system where each record can be individually locked by a unique password, providing exclusive access to that specific entry.
For instance, consider a scenario involving an anonymous team of operatives working in a foreign country. They’re listed in a table with their UUID number and a nickname, serving as proof of their association but withholding details about other team members.
Each row is secured with a password known only to the individual operator, granting them access solely to their own record while keeping other operators’ data confidential.
Additionally, the system should allow unlocking these rows even without being logged in, and it should handle the seamless addition of several thousand records, one at a time.
Is this possible? I can imagine the permissions getting messy as volume goes up but if it’s still manageable that would not be a problem.