Help

Getting Grouped Data into one Cell

771 2
cancel
Showing results for 
Search instead for 
Did you mean: 
arne_nori
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

im currently trying to understand how to get data that is grouped in one table into a single cell in another table.

I have a date field where the same date appears multiple times. the view is grouped by this field. then there is a corresponding field in each line with names.

now i would like to get all names in one cell with the date only to appear once.

Table 1:
12.3.2019 - Paul
12.3.2019 - Hannes
12.3.2019 - Alex

=>

Table 2:
12.3.2019 - Paul, Hannes, Alex

is that possible. i´m just not getting it right …

thanks a lot, cheers, arne

2 Replies 2
AlliAlosa
10 - Mercury
10 - Mercury

Using your example, assuming that each of the records for Paul, Hannes and Alex are all linked to the same record on Table 2, you can use Rollup Fields to get the results you’re looking for. This example base might help - I wasn’t sure of your specific use case so I left the record names pretty vague. The Field Descriptions will show you the formulas on Table 2.

arne_nori
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Neads!

thanks so much for the ultra fast response. this opened the knot in my head. i had to implement a conditional IF to get what i wanted though … problem was more complex than i descxribed - but the solution helped a lot!

thanks, cheers
have an “airy” day

arne