Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 different types of data.

...

(B) Audit Fields

(C) 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.

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 searchUsing 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 can help you identify a record in the database. each Each record in the system has a unique id field assigned to it which is known as the record id. It is system generated and can not 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, insta__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 not.

// Instance represents a unique entity in the platform. instance field holds the prefix of the instanceWe 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 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.

Created By:

Created by field is a built-in (non-custom) audit field that is used to record which 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 This is the reference to the user who made the change.

last modified by is not updatable.

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 deletedmodified the record last time.

Last Modified On:

The last modified date refers to the last time a document or media file was modified. this This information is gathered from metadata within the document or from the website's servers.

Is Test Record:

The field 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 the field. the The restored limit for the erase on the field is of 30 days.

...

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 or custom objects. they may or may not be required.

...

When we create a custom or standard field, we can decide what different type it should be (such as number, text, date, or pick list, etc).

How to create a custom field:

  1. From Profile, go on “Setup”

  2. Click on “Schema” and select a “Objects” option

  3. Click on any Object where we have to add the fields

  4. 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.

...