i have a requirement where in an input form i need to populate updatedBy field with the current operator name. So whenever a new record is inserted or an existing record is updated by an user using input form, i want that username to be populated in the updatedBy field. I tried using the default="CurrentUser()" in the schema on updatedBy field but it gives only the PK/ID of the current operator, not the name.
Is the any specific function which i can use to get the current operator name in schema? Or is there any other way to populate the current operator name to a field in input form? Please let me know.
Thanks,
Annie Femena.