Help on generating a particular report

There are three tables.

a) Persons b) Events c) A table to link them, one in each row (Meaning one person is linked to one event in a row)

I want to run a report, which would show the list of persons in an event.

I have another sheet for that, namely a ‘report trigger’ sheet with columns Key, Type (Event, Group etc), Name (name of event, group), set to trigger a worflow upon add, and with additional condition checking, if Type is equal to ‘Event’, which is added to by an action of the events table.

Now I want a report to display the list of persons in an event, along with their information, in a table.

That requires to retrieve the key values of persons from the table, first.

I’m not being able to locate a starting point for this.

Does this TableA have Ref columns for Persons and Events table?

If you mean the linking table, then yes.

It has reference for both persons and events.

Then you can trigger that Workflow from “Events” table. You can read the data with a formula like…

<<START: SELECT(TableA[KeyColumn],[Event ID]=[_THISROW].[ID])>>
<<[Person ID].[Person Name]>>
<<[Person ID].[Phone]>>
<< End >>

4 Likes

Just a quick question please

I have added an enumlist reference type column in the person sheet that is linked to the event name table, and have found a way to correctly populate all the cells in that column that already had records.

This has eased the report thing a lot.

But I would like to be able to see all events under a person at a glance, much like the inline row table.

The person table records events like a list, so there’s now way to show them in rows I suppose.

What can be a workaround to this?

If you manually create a VC with SELECT expression to populate those records, you can show those records as inline in the Detail View. For that, you need to explicitly set your column order in that particular Detail View.

1 Like

I want an inline table view within a deck view. There is an option to attach the inline table. Can that be a way?

Yes Deck views can display referenced rows however - totally from my point of view - it’s not advisable as it looks weird and you can’t unfortunately click on any referenced row to see the detail. When clicked it always goto the RowSelected view of the Deck View itself, not the referenced row’s.

1 Like

Well it’s not upon me completely too to decide.

Can the virtual column using select, like you described, add an inline row view to the decks?

And there is an option to set the limit on the number of rows shown. I would be grateful if you point me to the place.

Yes

If you expand your Detail View, right under the column order, you will notice the Max. nested rows property where you can set it.

As of now, it limits to 7. Is this the usual way ?

Okay, but as I know any workflow fires when a change is imminent.

How can I change things in the events table (which holds just the details of events) so that it might bring about the workflow to trigger?

A way is to have a double action set, one changing a column from no to yes, another changing it to no from yes again. And have the same workflow fire on each change.

Its something I have done and it works, but I assume that there should be better ways.

Check this out:

Ouuu, this is in line with something we had a discussion about very recently.

Thank you again.

You’re welcome

This comes through during testing of the action

Let me clarify a bit more.

  1. Table 1 contains person data. Say a key, name and detail

  2. Table 2 contains events. Say a key, event name.

  3. Table 3 links the two. It has one key, one reference to person (Person key), one reference to event.

I want an action from table 2, i.e. event, to generate the list of persons who are linked to that event.

And this is my start expression :

<<Start: select(Events[Person Key], [Event]=[_THISROW].[Event Name])>><<[Person Key].[Photo]>>

I have solved it.

The start expression :

<<Start: select(Events[Event Key], [Event]=[_THISROW].[Event Name])>><<[Person Key].[Photo]>>

Derived solely from his suggestion:

1 Like