I'm having trouble on how to start this one, displaying multiple records as one?

[Chris_Hall]

I have a weekly report that I must submit and all the data is in coda.

In this report I need to select a date, and 3 records will be returned for that date.

Background: every day I 4 fields the same data for 3 different teams, team 1, team 2, team 3
The fields are field 1, field 2, field 3, field 4

The problem is I need to display them as one record.

For example, if I select the date 10/14/2024

The report must return the following

field 1
team 1
team 2
team 3

field 2
team 1
team 2
team 3

field 3
team 1
team 2
team 3

field 4
team 1
team 2
team 3

[joost_mineur]

Hello @Chris_Hall ,
That would be done with a canvas formula, a filter and a foreach(). It is kind of hard to help you without you sharing a sample doc to show what your table(s) look like.

Greetings,
Joost

[Chris_Hall]

A sample would be very helpful!

After reviewing this post Im not sure if I clarified anything at all

Table name: Team Meetings

fields used:
Date
Team
Top Priorities
Accomplishments
Daily Activities
Blockers

Each day will have 1 record entered for each team (Windows, Unix, DBA).

So for any given day the report (canvas) should look like this:

Date

Team
team field (will be one of the three teams)
Top Priority
top priority field
Accomplishments
accomplishment field
Daily Activities
daily activities field
Blockers
blockers field

Team
team field (will be another of the three teams)
Top Priority
top priority field
Accomplishments
accomplishment field
Daily Activities
daily activities field
Blockers
blockers field

Team
team field (will be the last of the three teams)
Top Priority
top priority field
Accomplishments
accomplishment field
Daily Activities
daily activities field
Blockers
blockers field

[Chris_Hall]

I’m sure there is a much better way but I was able to get what I needed using code like this [Team Meetings].filter(CurrentValue.Team = "Database Engineers" AND CurrentValue.Date.ToDate() = WPDate.ToDate()).Team

[joost_mineur]

Hey @Chris_Hall ,
Since you decided to not share a doc, should we consider this case as closed?
Greetings, Joost

[Chris_Hall]

Oops!

But yes, please do.