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:
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
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 ...Style-based URLs for embedded forms and reports
In this topic we list out the parameters used in customizing the look and feel of Zoho Creator forms and reports. These parameters can be applied to the Forms and Reports embedded in your Pages. Form properties Description Parameter/Value Display ...Functionality-based URLs
Overview In the topic Zoho Creator URL Patterns we learned about the default URLs to access a Zoho Creator application and its forms, reports and pages. In this topic, we will learn about the functionality based URLs to set default values for form ...