Kumu
  • Getting started
    • Welcome
    • Kumu 101
    • First steps
    • Quick tips
    • Webinars
  • Overview
    • Kumu's architecture
    • Accounts and workspaces
    • Kumu.io and Kumu Enterprise
    • Billing
    • User interfaces
      • Dashboard
      • Settings
      • Map editor
      • View editors
      • Quick Actions
    • Collaborating and sharing
    • Actions and permissions
    • Security
    • Advanced Editor hub
      • @settings reference
      • @controls reference
      • Color reference
      • Property reference
      • Selector reference
  • DISCIPLINES
    • SNA / Network Mapping
    • Systems mapping
    • Systems Practice workbook
  • Guides
    • Activity feed
    • Add-ons
      • Disqus
    • Bridge
    • Cluster
    • Controls
      • Cluster control
      • Color-legend control
      • Filter control
      • Focus control
      • Image control
      • Label control
      • Showcase control
      • SNA-dashboard control
      • Tagged-timeline control
      • Text Control
      • Title Control
      • View toggle control
    • Decorations
      • Direct decorations
      • Data-driven decorations
      • Flags
      • Icons
      • Images
      • Label templates
      • Popovers
    • Default view settings
    • Export
    • Fields
      • Computed fields
    • Filter
    • Focus
    • Forking
    • Grids & Guides
    • Import
      • Structure your data for Kumu
      • Excel / CSV
      • Google Sheets
      • JSON / Blueprints
    • Imported views
    • Layouts
      • Fixed
      • Force-directed
      • Remove overlap
      • Scatter
      • Snap-to
    • Legends
    • Licensing
    • Lightbox
    • Loops
    • Metrics
    • Two-factor authentication
    • Pro workspaces
      • Archiving projects
      • Discussions
    • Partial views
    • Presentations
    • Profiles
      • Markdown
    • Project admin
    • Selectors
    • Shapes
    • Share and embed maps
    • Shortcuts
    • Showcase
    • Slugs
    • Table
    • Templates
      • Geo template
    • URLs
    • Views
    • Widgets
  • About Kumu
    • What is Kumu?
    • How does it work?
    • Where can I get help?
  • Enterprise
    • About enterprise
    • Getting started with VMWare
    • Upgrading
    • Configuration
    • Creating user accounts
    • SSH Access
    • Single sign-on
    • Backing up enterprise data
    • Restoring enterprise data
    • Command line utilities
    • Changelog
  • Frequently Asked Questions
    • Does Kumu have a public API?
    • Does Kumu make use of AI?
    • How do I add annotations?
    • How do I add anchors to my map description?
    • How do I add arrows to my connections?
    • How do I add documents to profiles?
    • How do I add more than one element with the same label?
    • How do I add text dropdowns to my map overview?
    • How do I adjust arrow size?
    • How do I avoid duplicating data?
    • How do I change connection curvature?
    • How do I change font color?
    • How do I change font size?
    • How do I change the default for currency fields?
    • How do I change the length or strength of connections?
    • How do I change the order of control options?
    • How do I change the position of my element labels?
    • How do I cite Kumu?
    • How do I collapse duplicate connections?
    • How do I copy a map to another project?
    • How do I control label size while scaling element size?
    • How do I control text wrapping?
    • How do I convert a project from private to public?
    • How do I convert a project from public to private?
    • How do I create dynamic on/off toggles for my map?
    • How do I customize link text in popovers?
    • How do I customize the order of my legend?
    • How do I delete a project, map, or view?
    • How do I delete data from my project?
    • How do I downgrade my subscription?
    • How do I edit virtual elements?
    • How do I get rid of duplicates?
    • How do I hide elements without connections?
    • How do I hide images from the map but keep them in the profile?
    • How do I hide labels on my map?
    • How do I hide the settings button?
    • How do I keep elements from moving?
    • How do I list an element's connections in its profile?
    • How do I make elements transparent?
    • How do I make sense of my receipt?
    • How do I open a sub-system when clicking on an element?
    • How do I remove the Opposite entry from my legend?
    • How do I remove unneeded controls?
    • How do I remove unwanted legend entries?
    • How do I rename my map/view?
    • How do I restructure my adjacency matrix?
    • How do I save my changes in Kumu?
    • How do I select options by default in my control?
    • How do I set a minimum or maximum zoom level for my map?
    • How do I show the Settings button?
    • How do I size elements based on number of connections?
    • How do I transfer a project?
    • How do I update my credit card information?
    • How much data can my Kumu project handle?
    • How do my readers switch between maps and views?
    • My data won't import. What can I do?
    • My Kumu embed is not working. What can I do?
    • My map disappeared. How do I bring it back?
    • My PDF won't export. What can I do?
    • What pricing plans does Kumu have?
    • Where can I find my invoices?
    • Where can I find example Kumu projects?
Powered by GitBook
On this page
  • Use Google Sheets to generate list widget code for all elements
  • Sample usages
  • Syntax

Was this helpful?

Edit on GitHub
  1. Frequently Asked Questions

How do I list an element's connections in its profile?

PreviousHow do I keep elements from moving?NextHow do I make elements transparent?

Last updated 2 months ago

Was this helpful?

In the profile of each element in your map, it's possible to list that element's connections, using three tools:

  • Kumu's

  • A field with its Type set to Text (e.g. the Description field)

In your custom Text field or in the Description field, add the following:

[[list ":from([label = 'My Element Label']),:to([label = 'My Element Label'])"]]

Replace both instances of My Element Label with the actual label of the element whose profile you're editing. After you click Done to save the field's content, you'll see a list of all connections leading to or from that element.

If you just want the connections leading your element, you can omit the second half of the selector. Here's what it would look like:

[[list ":from([label = 'My Element Label'])"]]

And if you just wanted the connections to the element, just omit the first half:

[[list ":to([label = 'My Element Label'])"]]

Again, replace My Element Label in all of these examples with the actual label of the element whose profile you're editing.

If your map has multiple elements with the same label, your list widget will list all connections to or from any of the elements with that label. To avoid that, you would need to replace [label = 'My Element Label'] with a more specific selector.

Use Google Sheets to generate list widget code for all elements

If you have a lot of elements, it's pretty tedious to go through each element's profile and add the list widget code.

If you're using either Label or ID as the unique identifier for elements, you can quickly generate list widget code using a custom Google Sheets formula we created.

Delete the example tabs in the Google Sheet, then create a new tab and copy/paste your list of elements into it, starting from cell A1. Make sure that Label is in Column A, or that you have an ID column in the sheet, filled with unique IDs for your elements.

In your dataset, start editing the cell directly below the column header for the field where your list of connections should go. For example, if you want to put the connection list in the Description field, and your Descrition field is in Column B of your spreadsheet, start editing cell B2 underneath the Description column header.

In that cell, type =KUMU_LIST_WIDGET_ELEMENT_CONNECTIONS( to get started.

Sample usages

KUMU_LIST_WIDGET_ELEMENT_CONNECTIONS(A2, "both")

KUMU_LIST_WIDGET_ELEMENT_CONNECTIONS(A2, "from", FALSE)

Syntax

KUMU_LIST_WIDGET_ELEMENT_CONNECTIONS(element_identifier, connection_direction, identify_by_label)

Parameter
Description

element_identifier

The cell that contains the unique identifier for the element.

connection_direction

Enter "both" to list all connections from and to the element. Enter "from" to list only the connections from the element, and enter "to" to list only the connections to the element. This parameter is not case sensitive.

identify_by_label

Enter TRUE if the element's unique identifier is coming from the Label column. Enter FALSE if the element's unique identifier is coming from the ID column.

If you don't specify this parameter, it defaults to TRUE.

Given those parameters, KUMU_LIST_WIDGET_ELEMENT_CONNECTIONS returns Kumu list widget code to list all the connections that are connected from or to the specified element.

Then, you can simply import that data back into Kumu, and when you open any element profile, its connections will be listed!

To get started, open one of your element profiles. If you want the connection list to be in a custom field, create that field, and . Alternatively, you can use the Description field, since its type is Text by default.

or to learn how to write a more specific selector for your use case.

To get access to the custom formula, you can open our , then click "File" > "Make a copy" to create your own editable copy of the sheet.

If you don't have your list of elements on hand, you can use Kumu to .

In most projects, this will be the element Label, but to identify elements.

set its type to Text
Visit the full guide on selectors
contact support
"With custom Kumu formulas" Google Sheet
export it to Excel
you can also use an ID column
list widget
:from and :to pseudo-selectors
List of element's connections in its profile