Understanding record formatting
Formatting, in terms of reports, enables you to highlight certain field values in an attempt to grab attention to that data or to make that data stand out for easy visibility amidst the abundance of information in the report. This formatting is based on predefined conditions. The field values that match the conditions will appear in the specified format. The font and colour are the contributing factors that make the field values or records distinguished. Learn more on how to format based on conditions.
List report
For instance, you have an Events Schedule report that has information such as name of the event, date, time, venue, and event manager. If the predefined condition states that the events that taking place on a particular place be formatted in yellow, you will find that the records that have Address field values matching the predefined condition are highligted. In this case, California is the criterion based on which the Event, Location, and Date fields are formatted.
Calendar report
For instance, you have an Project Status report that has information such as name of the Project Name, Manager, Start and End Date, and Status. If the predefined formatting conditions provide specific colors to records with specifc field values in the Status field, you will find that the records are highlighted in those predefined colors.
Timeline report
For instance, you have an Attendance report that has information on Employee in-time and out-time. If the predefined condition states that the records appear in different colors based on the Stift Time field values, you will find that the records that match the specific conditions are highlighted in the respective colors.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Conditions to filter records based on Creator fields
In a nutshell Learn about the criteria that you can set to filter records and run workflows within the Creator application. 1. Overview Conditions help in filtering records from a Zoho Creator report. Based on the criteria set in a condition, actions ...Understanding canvas layout designer
1. What does this page cover? Learn about how you can use Canvas layout builder in Creator to design the detailed view layout of your records, corresponding to your business requirements. 2. Availability This help page is for users in Creator 5 and ...Creating a custom layout
1. What does this page cover? Learn to design a custom layout corresponding to your business requirements for the detailed view of your records using the Canvas layout builder. Before moving ahead, you can learn more about canvas layout builder and ...Display different colors based on record value
Requirement Display different colors of the record in a report or page based on its value. Use Case In a sales management application, the business owner wants to track the purchases and the sales. As a new purchase is made, the corresponding ...Understanding gauge
In a nutshell Gauges are intuitive dials or meters that dynamically represent Creator form data as metrics, performance levels, and key performance indicators (KPIs) on pages. They enable users to assess progress, thresholds, and status against ...