Fields you can create

Fields are what make up your data grid and are what can be shown on list layouts and detail layouts. Decide what field types and the names of the field you want to create and add or remove from layouts.

Add in new fields to your pages that are not yet created:

Add a *date field* for the *outstanding payments* table

You can hide fields on your list layouts or detail layouts by asking the agent to hide the field

Hide the *Status* field on the *Lease* layout.

This will hide the field, but not delete it from the data grid and can be used in other places.

The list of fields you can use in your app

Short Text show a single link of text

Long Text allow multiple lines of text

Rich Text allow multiple lines of text that can be formatted with headings, bullet points, lists, etc.

Currency a currency-formatted number

Number numeric values.

Percentage a percentage-formatted number.

Checkbox an on/off checkbox that can be shown in different ways.

Single Select select a single value from a list of options, set these options on the data grid and choose colors to go with the values.

Multiple Select allow for selecting multiple values from a list of options, set these options on the data grid and choose colors to go with the values.

Date set a date field

Date and Time set a date field with a time.

Link to Another Record link to one record

Link to Multiple records link to another table and allow for multiple records to be linked.

Lookup Related Value when you link tables together, then choose a lookup field to bring in information from the linked table.

Roll-up Related Records when you link tables together, you can roll up to a number field to count, sum, average, etc from a connected table.

Created Date this is a built in field that will automatically show the date a record is created.

Created By this is a built in field that will automatically show the user a record is created by.

Formula use a formula field to pull fields together or run calculations.

Attachments drag and drop PDF files or images to keep information in one place or add color to your app.

Record ID this is a built in field that will automatically generate a record ID that is associated with the record.

Autonumber this is a built in field that will automatically generate a number, in numerical order, for every new record created.

Last Updated Date this is a built in field that will automatically show the date a record is updated.

Last Updated By this is a built in field that will automatically show the user a record is updated by.

URL add a url and display as a Button on your detail pages.