Hello,
We created a simple Helpdesk database, where our users can creates Tickets.
The form for a Ticket has a “Process” field, where the users and support guys can enter any information. The problem is that everyone can edit and delete there everything.
I’d like to protect the information entered each time the Ticket is saved.
How can I do that?
Can I create a second “History” field which would copy the info from the first field and then empty this first field each time the document is being saved? Possibly even with the time, date and name of the user edited the document?
Something similar to the calculated “Edited by” field:
@If(@IsNewDoc; EditHistory;
@If(@IsDocBeingSaved;
@Explode(@Implode(EditHistory; “~”) + “~” + "Edited by " + @ProperCase(@Name([CN];@UserName)) + " on "+ @Text(@Now); “~”); EditHistory))
Many thanks in advance,
Leo