Solved: Reference a table without Ref_Rows - Page 2

cronx-smash · 04-11-2023 11:06 AM

Here's an overview via Loom video
https://www.loom.com/share/d43158e1ac234d00aff44a3309e79e2a

Correction at 2:00 - I want to show all columns of the Abilities table.

Summary

Each row in Table Figures has a list of references to Table Abilities. They are formatted as Enum List. When in the Figures view and viewing a specific Figure (row), I want to see all rows of the Abilities table that I have reference to in Figures.

Tables

Figures
Stats
Abilities

Table Relationships

Figures (one) -> Stats (many)
Figures (one) -> Abilities (many)

Abilities TableStats TableFiltering the Abilities table to display with the respective figure.Figures Table

Joseph_Seddik

Welcome to the Community!

Add a new physical column to the Figures tables, name it abilityDetails for example with the following properties:
- Type: EnumList
- Base type: Ref pointing to the Abilities table
- App Formula:
  FILTER("Abilities",
  IN([Name],
  [_ThisRow].[Damage Ability] + [_ThisRow].[Speed Ability] +
  [_ThisRow].[Attack Ability] + [_ThisRow].[Defense Ability]
  )
  )
Your Ability Description virtual column should have the following formula: [abilityDetails]
Go to the settings of the Inline view of your Abilities table, and choose which columns you want to display and in what order. The user will get a clickable, expandable view of the abilities related to this figure.

View solution in original post