Vladi Gubler
Vladi Gubler
September 04, 2011
Stay in the know
Get helpful videos

Hello,

As you might already know, our Associated Tasks Field helps you create relationships between items located in different lists. So you can assign tasks to events, add documents to projects and basically create any type of relationships to turn SharePoint lists into a real life application infrastructure.

Now, we offer you an additional treat - you can now use the bindled Associated Items Summary columns to count or summarize your related items. For instance, imagine that you use the product to create and manage customer invoices. You do it using two lists:

  • Invoices - where the actual invoices are managed, with such columns as Customer, Bill To and Ship To
  • Invoice Lines - here you enter the items for each invoice, by entering item title, unit price, quantity and line total (use Calculated field for that)

Using Associated Tasks field you can show the lines withing the context of each invoice and you can even create new lines for new or existing invoices straight from the invoice's Edit form.

But what if you wanted to calculate the grand total or simply show the number of item lines in the Invoices list view. This is where the Associated Items Summary column helps.

  • Create a new summary column in the Invoices list
  • Point it to the Associated Tasks column you created to show the invoice lines
  • Select the Line Total column to perform calculations on that column
  • Select Sum operation
  • You can even optionally add filters, so that only specific related items are included in the summary

Invoice

That's it. Now each time an invoice item is added, modified or deleted, the parent invoice has its summary value re-calculated.

By the way, check out the new Smart Print Pro to print our your invoices or convert them to PDF.

Loading...

Add your comment

Comments are not meant for support. If you experiencing an issue, please open a support request.
Products
In this post I'm going to go over the Signature component of our Ultimate Forms. I will explain how it can help your SharePoint system meet federal regulations, like FDA 21 CFR Part 11.SharePoint is a great tool for managing all kinds of data: documents, business processes, you name it. Coupled with a Single Sign-on, entering data is a breeze,...
Products
When we started to develop Ultimate Forms, we did not position it to be an InfoPath competitor or replacement. We aimed to create a platform that helps our customers use SharePoint better. We wanted to close the gap between their needs and what SharePoint can do. This way, they wouldn't have to spend money on expensive custom development. We did...
Products
Vladi Gubler | April 30, 2025
If you’ve ever used Survey lists in SharePoint, you’re likely familiar with a powerful and often underappreciated feature: the Rating Scale column. This special column type presents a matrix of statements or questions alongside a numeric scale, typically used for gathering structured feedback. The idea is simple but incredibly effective - allow...
Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution
It’s never been easier to create, innovate, and share. All you need is your web browser!
Cost-Effective
Address business process pain points immediately. Save time and money.
Fantastic Support Team
In addition to our responsive support team, a wide variety of resources, documentations, tutorials, blogs and webinars is available to you
Microsoft partner logo
© 2005-2025 Infowise Solutions Ltd. All rights reserved.
Privacy | Cookie Policy | Accessibility | Cloud SLA