Displaying multi line events

Support for our integrated Contact Manager, Calendar, and Project Tracker.
Posts: 35
Joined: Tue Nov 25, 2008 11:49 am
PostPosted: Fri Dec 07, 2012 11:55 am
I've created a calc field with the List() of the fields as mentioned in the section on multi line events and I have mapped it in Source No 1. The calc looks good in Source No1 in browse mode so that seems fine, but the catch is that in the calendar layout the multiple lines don't appear. See attached.

I've run the Upon Open script, exited out FMP and back in.

Getting this to work in previous version of the calendar was easy so I'm confused why I'm having a problem in this version. I'm sure I'm doing something wrong. Any idea what it might be?

Thanks
Will
Attachments
seedcode.jpg
seedcode.jpg (95.08 KiB) Viewed 13540 times
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Fri Dec 07, 2012 12:12 pm
Hi,

We've changed this in 12 so you need to substitute out the carriage returns with \n. Your calc should look something like this:

Calc.png
Calc.png (86.23 KiB) Viewed 13538 times


and the field in Source No 1 should look something like this:

Source No 1.png
Source No 1.png (26.83 KiB) Viewed 13538 times


That should take care of it.

-Cheers!
Posts: 35
Joined: Tue Nov 25, 2008 11:49 am
PostPosted: Fri Dec 07, 2012 12:35 pm
Yes! Thanks!
Posts: 35
Joined: Tue Nov 25, 2008 11:49 am
PostPosted: Fri Dec 07, 2012 12:51 pm
ONE MORE QUESTION>>>
Seems like I'm losing the formatting. Anyway to keep it?
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Fri Dec 07, 2012 12:59 pm
Right, this is the downside of using ExecuteSQL. You can't keep the formatting, but you can reapply it in the script:

Format Event Summary --- Edit the Style of the Event Text Here ---

hope that helps!
Posts: 35
Joined: Tue Nov 25, 2008 11:49 am
PostPosted: Fri Dec 07, 2012 1:09 pm
You and Jason are too good. Thanks
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Fri Dec 07, 2012 1:13 pm
Thanks!...flattery will get you everywhere with us 8)

Have a great Weekend!

Return to SeedCode Calendar

Who is online

Users browsing this forum: No registered users and 2 guests

(855) SEEDCODE
[email protected]
Follow us: