Hi. That’s a bit more to unpack.
“With this would I be able to limit John to only Add and Jane to full access? I pressed the little flask icon. Am I right to assume that Add means that previous content already written is locked and only additional information can be added into that same field ? And Update refers to changing the content of the field when content is already present?”
This is all generally correct.
“I found the Audit Log - Is there a way to have this emailed like a daily report of what was edited by user based on the row?”
I think the answer here is no, from the POV of a particular app - this is really a platform management feature. However, if this is important to you, you could create a new action to copy a row to another “audit” table that you would manage, here’s that action choice:
On your last question, there’s probably a few ways to do this; one way is to set the initial value of a field to a “select” statement, e.g.:
The above says “get the max value of a column called DecimalExample from the table called data”. You can learn about expressions, selects, filters, et al from our help pages.
Hope this helps!