Formula to lookup field in all children records

Thanks for the reply. I did that but it only shows the first record and not 25.

Thanks again

That does not seem possible. I have already used that new feature many times and it works.

Can you confirm that you set up a Summary field on the relationship between Events and Subscribers and that you have not applied any filters to the summary field setup.

That is correct. I did that and its not showing all records only the first one.

My only other though is that you may have some consusion over which field is being summarized. Other than that, it will take someone to look at your app, so you should put in a support ticket.

I put in a support ticket. Let's see the outcome.

Thanks

Yes, please post back what they say.  I'm very curious.

This is crazy.... I simply didn't relate the second subscriber to the event. I was to fast and didn't fill out the entire form and forgot that I need to relate it to the event in order to test........

So sorry for the confusion.

Thanks for your help. 

np

One more question, what would be the best way to take out the ; which is placed between values when converting to text.

Thanks

You can use this formula;

var text value = ToText([my combine summary field]);

List(", ")
Trim(Part($value,1,";")),
Trim(Part($value,2,";")),
Trim(Part($value,3,";")),
Trim(Part($value,4,";")),
Trim(Part($value,5,";")),
Trim(Part($value,6,";")),
Trim(Part($value,7,";")),
Trim(Part($value,8,";")),
Trim(Part($value,9,";")),
Trim(Part($value,10,";")),
Trim(Part($value,11,";")),
Trim(Part($value,12,";")),
Trim(Part($value,13,";")),
Trim(Part($value,14,";")),
Trim(Part($value,15,";")),
Trim(Part($value,16,";")),
Trim(Part($value,17,";")),
Trim(Part($value,18,";")),
Trim(Part($value,19,";")),
Trim(Part($value,20,";"))
)


That will provide a comma (space) separated list of the first 20 values.  To be safe you should probably go up to 25 which is the maximum of the summary field, I believe.

If you wanted to just have a separator of a space then it would be

List(" ",
etc