Display subform's report in parent form's report
Requirement
When the user views a particular record in
a
report that has
subform, the values in the corresponding records are also shown.
Use Case
An order management application contains two forms: Customers
and
Orders. The
Customer
s
form is used to store the details of the customers. The
Orders
form is used
by a cashier or
an accountant to
place an order. Every order is linked to a customer, whose
details are entered from a lookup field in the
Orders
form. The
Products
form holds the inventory. When a record is clicked, the detailed view of the record will show the customer's other details, such as their
phone
number or
address.
Steps to follow
|
Form
|
Form Link Name
|
Field Type
|
Field Name
|
Field Link Name
|
|
Customers
|
Customers
|
Name
|
Customer Name
|
Customer_Name
|
|
Email
|
Email
|
Email
|
||
|
Phone
|
Phone
|
Phone_Number
|
||
|
Orders
|
Orders
|
Lookup (Customers)
|
Customer
Name
|
Customer
|
|
Date
|
Delivery Date
|
Delivery_Date
|
||
|
Subform
|
Order Details
|
Order_Details
|
3. Under the
Configure Fields
slider, click
Add Related Block. This will list all the relationships and subforms of/in the
Order
form. From the list, select the
Order Details
subform.
This will display the subform's report in the corresponding detailed view
of the parent form's report.
See how it works
Points to note
-
Lookup forms are automatically added in the detailed view of the report. If lookups are added inside a subform, those records are automatically added in the detailed view of the report. Subforms can be added manually. Please note that by default, two lookup and/or subform blocks are added. Further customization can be achieved using this feature.
-
The detailed view of the related form can be configured according to user requirements. Click on the added block and select the required layout from the options displayed at the top.
-
Additionally, the fields view can also be configured. For example, instead of address, geo - coordinates can also be displayed and this can be configured to be click able. Clicking these will open the map with the corresponding address, enabling calculation for routes, distance, etc. Read more about customizing the detail view here.
Related Links
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:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Auto-calculating values on a subform's field
Requirement Perform statistical operations on the numerical fields in subforms for analysis. Use Case In an order management application, there are two forms, Order and Product. The Product form lists all the products in the inventory and the Order ...How to display images dynamically on a subform row based on the lookup field selection
The images stored in a form can be retrieved and displayed dynamically within subforms. When users select a record from a lookup field in a subform row, relevant images associated with that record can appear in a designated rich text field within the ...Understanding form workflows
In a nutshell Form workflows are automated actions triggered by user activities on a form, such as creating, editing, or deleting records, collectively referred to as record events. These workflows are further fine-tuned by form events, which specify ...Showing only logged in user's records in a filtered report
Requirement Display only the relevant records for the logged in user, based on the customer email, to ensure the security and privacy of the data from other users in the application. Use Case An order management application has the Order form ...How to copy subform data to another subform using a report action
The values in a subform of a record can be copied to another form's subform using Deluge within the report actions. This allows seamless transfer of subform data between forms, ensuring consistency. For example, consider a Zoho Creator resource ...
New to Zoho LandingPage?
Zoho LandingPage Resources