Get your bottom line with Summary columns

Vladi Gubler
Vladi Gubler
September 04, 2011 | Products

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 designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

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

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics

Infowise logo
© 2021 - Infowise Solutions Ltd
Microsoft partner logo
GSA Schedule

What is right for you?

Sandbox

Get acquainted with UltimateForms from the end user perspective
  • No installation or registration required
  • Experience 14 pre-built business solutions
  • End-user access only, cannot modify settings
Let's go!

Online Trial

Create a trial site in our environment and explore features of UltimateForms
  • Full control of the site
  • Full access to all settings
  • Optionally pre-install one of our business solutions
  • Site provisioned automatically
  • Register for 30 day trial
Register Now

Installation

Get UltimateForms in your own environment
  • Start working with your real users and data
  • Install either on SharePoint Online or on premises
  • Register for 30 day trial
  • Trial can be converted to paid license
Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.