Combining data types in a list

#1

I’m creating a “dashboard” of sorts to track beta users that have recently joined across multiple products. I’m using the following formula right now for a basic list of users:
If(Filter([Beta Users],CurrentValue.Created()>=Today()-7).Count()>0, BulletedList(Filter([Beta Users],CurrentValue.Created()>=Today()-7).Company),"")

What I’d like to do is list both the company name and the product name as a list, so it would look like this:

  • [Beta Users].Company has joined the [Beta Users].Product beta
  • [Beta Users].Company has joined the [Beta Users].Product beta
  • [Beta Users].Company has joined the [Beta Users].Product beta

Is this something that exists right now in the BulletedList functionality?

#2

@Drew_Watkins I recommend you use https://coda.io/formulas#Concatenate first and then do bulleted list.

#3

Thanks @Krunal_Sheth. Do you have an example? I already tried the following:
If(Filter([Beta Users],CurrentValue.Created()>=Today()-7).Count()>0, BulletedList(concatenate(Filter([Beta Users],CurrentValue.Created()>=Today()-7).Company,Filter([Beta Users],CurrentValue.Created()>=Today()-7).Product)),"")

creates a single bullet that looks like the following:

#4

@Drew_Watkins

[Beta Users].Filter([Created On] > Today()-7).FormulaMap(Concatenate(Name, " joined from ", Company)).BulletedList()

2 Likes
#5

Gotcha, thanks @Krunal_Sheth!