You can add four simple fields that help the management tracking of assets. These fields are:
Created By, Created On, Modified By, and Modified On. They track who created the record and when, and who the last user who modified it, and when.
Adding Created By Field:
- Find the dataset that you want to add the field to.
- Go to the schema editor and add a text field by clicking on the "Text" button.
- Give it a name such as "Created By" though you can choose the name you want.
- Choose the option, "Autopopulate with user email when created".
- Save the schema and the field will be added.
Additionally, you can choose "Autopopulate with user Custom ID when created". The custom ID is set in the user's settings and is used when an organization wants to keep their user tracking in line with a different user management system. For example using a Windows Login from Active Directory.
Another recommendation is that if there is no data in the table yet, you can mark it as required.
Add Created On Field:
- Find the dataset that you want to add the field to.
- Go to the schema editor and add a text field by clicking on the "Date" button.
- Give it a name such as "Created On".
- Choose the option, "Set date when created".
- Save the schema and the field will be added.
Add Modified By Field:
- Find the dataset that you want to add the field to.
- Go to the schema editor and add a text field by clicking on the "Text" button.
- Give it a name such as "Modified By" though you can choose the name you want.
- Choose the option, "Autopopulate with user email when modified".
- Save the schema and the field will be added.
Add Modified On Field:
- Find the dataset that you want to add the field to.
- Go to the schema editor and add a text field by clicking on the "Date" button.
- Give it a name such as "Modified On".
- Choose the option, "Set date when modified".
- Save the schema and the field will be added.
Comments
0 comments
Please sign in to leave a comment.