Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 5486 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I am using the formula below to list the found set cities and email the results:

Substitute ( List ( City ) ; ¶ ; ¶ )

When the script runs it populates the email and lists the cities on seperate lines:

Boston

London

Tokyo

However when the email is received the format changes to:

Boston London Tokyo

How can I force it to add ¶ at the end of each value?

Posted

List (relationship::City) should give you a return-delim list. No need for substitute. Where are the cities? They're in a related table, correct?

Posted

Hi thanks for the reply.

Yes the cities are in a related table I am getting the same results... it looks good at send time however it does not arrive is list format!!

Any other ideas how I can solve this?

This topic is 5486 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.