Creating relationships between SharePoint lists is now much easier
Vladi Gubler
Vladi Gubler
March 16, 2022 | Products

Hi,

All data we work with in the real world is relational, most commonly in a single-to-multiple relationship. For instance, each department employs multiple people, each product category contains multiple products, and so on. Our SharePoint lists are supposed to represent this real world data in the truest and most convenient form. Unfortunately, SharePoint handles relationships in quite a rudimentary fashion. That's why years ago we developed our Associated Items column type, that allows creating relationships between lists that are handled seamlessly within regular SharePoint forms. Creating repeating items within a parent item became easy for everyone!

Since then we have introduced a vast number of improvements and features, to better suit the wide variety of our customers' needs. Be it sorting, paging, summaries, grid entry mode, the list just goes on.

The only issue that many new user would be stumbling upon was the initial configuration. We establish the relationship in two possible ways:

  1. Using our special content types ("Infowise Associated Item", "Infowise Associated Document", "Infowise Associated Task")
  2. Using a regular lookup column in the child list pointing to the parent

I won't be discussing pros and cons of each approach here, we have existing training documents that delve into this in great detail. I will just say that both approaches require quite a few manual steps to get things going and unexperienced users might find it a bit challenging at first.

We are now introducing a few feature that will make it so much simpler and streamlined. Now we can optionally perform all the manual tasks for you, when you create a new column, including creating the child list (or document library), replacing the content type and adding a lookup.

  1. Go into Associated Item column settings page in the main page of Ultimate Forms (you can also add columns directly in Form Designer, whatever is more convenient)
  2. Click on Add new column
  3. Enter the column title
  4. Under Data source, you can switch to New to create a new list.
  5. Choose from list type, we support Custom list, Document library or Tasks list.
  6. Provide a title for your list (in most cases, you want it to be the same as the column title, but it doesn't have to be). If you already have an existing list with the same title, you will be prompted to enter a different one.
  7. Optionally choose to use a lookup and provide a title for it. There are specific recommendations on what approach to use for the relationship, but in general, use a lookup when you want to export you data to Excel or other 3rd party applications and do not use it when you want to add child items in the New form of the parent (for instance, when creating an invoice, it is advisable to allow adding line items before you save the invoice, so don't use a lookup there).
  8. Under Optional settings tab, you can configure a number of settings related to styling and functionality

    Generally, you don't have to change anything here, but I'd like to mention a couple of significant ones:
    • Display in form format - instead of displaying child items in a table view, repeat them in their own form layout, stacked within the parent form.
    • Allow adding new items - allow users adding new child items from the parent.
    • Enter data using grid - new items are added in the grid itself, instead of using a pop-up form. Makes sense when your child list only contains a handful of simple columns.
    • Open forms in a dialog - opens child items in a pop-up window instead of navigating to them.
  9. Once you save the column settings, it will generate the new list and then create the column to link it to the parent.
  10. Now you need to add the column to the form (I'm showing it in Form Designer for modern forms, which is the recommended approach for all new forms, but you can use classic forms as well, they are still fully supported)
  11. Once you open Form Designer, your new column will appear in the List Columns gallery on the left, ready to be dragged onto the form design canvas. You can now just click on Publish, next steps are for information purposes only.
  12. Click on the column to see the configuration settings on the right.
  13. You can change settings of any existing column directly from here.
  14. This is the exact same page we used earlier (of course, the New option is hidden as we are configuring an existing column here). See the option Design data entry form. It allows you to create a special form for the child list to be used with this column only. There are scenarios where you want to use a simpler shorter form when entering data into the child list from the parent, this is how you design such a form.
  15. Once you publish in Form Designer, you form is ready to be used. Here you can see the parent form item "Dairy" with the new Subcategories column and a number of child subcategories. We are in the middle of adding a new subcategory using a pop-up form.

As you can see, it's now so much easier to create a new relationship. I'm sure it's going to save you a lot of your precious time and allow you to focus on other tasks instead. Enjoy!

 

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

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!

Error!

There was an error processing your request.
Please contact us for further details.

Installation

Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions

Success!

Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.

Error!

There was an error processing your request.
Please contact us for further details.
Technical details:

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.