Fields in PWR apps Apps represent what the columns represent in relational databases. It can store data values that are required for a particular object in a record. Fields can store many different types of data.
There are 3 types of fields:
(A) Standard Fields
(B) Custom Audit Fields
(C) Audit Custom Fields
The above-mentioned fields explain are as follows:
Standard Field:
Name:
The name Name is a standard field in every an object and the field this gets created at the time of the creation of the object. This is cannot be deleted or edited.
For standard objects, the fields which are present by default in them, cannot be deleted from standard objects.
Tags:
Using this field the user can give a tag to the record of an object from the list of values. Users can create new tags at run time as well.
Standard and Audit fields cannot be edited or deleted.
Audit Field:
Record Id:
A Record ID record id can help you identify a record in the database. Each record in the system has a unique ID field assigned to it id which is known as Record IDthe record id. It is system generated and cannot be edited or deleted. It is generated every time a new record is inserted into the application.
Object Type:
It is used for dynamic references to retrieve information about an object through Object Type.
For example, inst0526__manualTesting: here the records under categorized into Manual testing objects, and the object under categorized into Instance.
Instance:
If you do something at someone's instance, you do it because they have ordered or requested you to do it. The instance of the operator is used to check whether an object is an instance of a particular class or notWe have a common collection (or object) for all the records created under the custom object. Object type contains the object name (custom object name) for which the particular record is created.
Instance:
This field contains the instance for which the record is created.
Owner:
Objects have an owner Id field that is a reference to the user who owns that objectrecord. Ownership is an important concept that affects the security model and has other implications throughout the system. Any user can query the owner field for any record they can access.
Tags:
A Tag field on a content-Type allows Content Contributors to label the content with keywords (tags) as it the content is contributed. Each Content Type can only have one Tag field. You can tag any field-value pair directly from the results of a search.
Created By:
Created by field is a built-in (non-custom) audit field that is used to record which syncing user created a record. You can not update that field once the record is createdThis is the reference to the user who created that record.
Created On:
Created on is a field where date refers to the last time a document or media file was created. You can not update that field once This field has a date and time at which the record is created.
Last Modified by:
The date and timestamp for changes made to an individual record, including the User who made the change. Unfortunately, you won't be able to change the "last modified by" field, as this is a system field that is read-only.
Deleted By:
Deleted by field is a built-in (non-custom) audit field used to record which syncing user deleted a record.
Deleted On:
Deleted by is a field where date refers to the last time a document or file was deletedThis is the reference to the user who modified the record last time.
Last Modified On:
The "Last Modified On" last modified date refers to the last time a document or media file was modified. This information is gathered from metadata within the document or from the website's servers.
Is Test Record:
The field “Is Test Record” is used by the developer to maintain the test record.
Is Deleted:
Is deleted field is used to keep the record of deleted records. If the user deletes any record from the account then with the help of the “Is Deleted” field we can keep the track of deleted records in the database.
The deleted records do not get permanently deleted from the database unless TTL (Time To Leave) field is applied.
Deleted By:
Deleted by field is a built-in (non-custom) audit field used to record which syncing user deleted a record.
Deleted On:
Deleted on is a field where date refers to the last time a document or file was deleted.
Is Test Record:
The field test record is used by the developer to maintain the test record.
Erase On:
When any of the records have been deleted from the org it gets reflected in the Erase On erase on the field. The restore restored limit for the erase on the Erase On field is of 30 days.
Is Published:
...
Is Manageable:
Is Manageable is a boolean Boolean field of metadata object that is used to make an object is managed or
un-managed.
Custom Field:
Custom fields can be created on Standard standard or Custom custom objects. They they may or may not be required.
The Custom custom fields are added by the administrator or developer to meet the business requirements of your organization.
When we create a custom or standard field, we can decide where it appears, and what different type it should be (such as number, text, date, or pick list, etc).
How to create a custom field:
From Profile, go on “Setup”
Click on “Schema” and select a “Objects” option
Click on any Object where we have to add the fields
Click on a “New” and select the appropriate data type to create a field
...
Allows users to enter a date or pick a date from a popup. Use the functions DAY( date ), MONTH( date ), and YEAR( date ) to return their numerical values. This field will store the text version of the Date date Field in dd/mm/yyyy format.
A Date date value stores a year, month, and day. A date field is great for showing the birth date.
The date field also has feature accessibility like may or may not be Requiredrequired, Selectselect-able, Readread-only or Sortsort-able, Createcreate-able or Editableeditable
Date/Time:
A Date/Time value stores a year, month, day, and time. The time is stored as GMT, but displays in the time zone of the user viewing it. It’s important to keep time zone conflicts in the back of your mind as you work with Date/Time values in formulas.
This field comes along with multiple dates and time formats. We can pr-defined date as minimum and maximum by applying validation.The date/time field also has feature accessibility like may or may not be Required, Select-able, Read-only or Sort-able, Create-able or Editable
Duration:
The duration field type is a numeric field type intended for use with time duration measured in hours, minutes, seconds, or milliseconds. Depending on the format of the duration field, the values are either stored as an integer or decimal representing a number of seconds.
...
This is a separate field to record email details from a user, called the E-mail field data type field. This field can validate if the given email ID Id is valid or not.
This field allows users to enter an email address, which is validated to ensure proper format.
...
The default value must be between the minimum and the maximum value.
Double: (bug: Unable to apply validation; Min n Max limit validation is not applicable)
Double is a field where we can make number entries with decimal places.
...
Tags:
A Tag field on a content -Type allows Content Contributors type allows content contributors to label the content with keywords (tags) as it the content is contributed. Each Content Type can only have one Tag field. You can tag any field-value pair directly from the results of a search.
...
The formula field is used to calculate custom fields, validation rules, Flow flow logic, etc.
Formula fields are read-only fields that automatically calculate a value based on other fields or a formula. Any any change in expression or formula will automatically update the value of the formula field.
...