I've been editing the DBk_EventSummaryCalc in the events table but I noticed that on teh actual calendar webviewer some lines are empty and leaving a gap. I want to make conditional returns so that I can close these gaps up. For instance I have the follwing order:
Time
Contact
Summary
Description
what I'm seeing is:
1:00pm - 1:30pm
Go to Lunch.
Meet at the Olive Garden.
... where Contact is empty.
Day Schedule Summary
3 posts
• Page 1 of 1
Posts: 109
Joined: Fri Jul 17, 2009 7:44 am |
|
Hi Jim,
The "DBk_EventSummaryCalc" field returns a list that is sent to the calendar for display. If a list item in that list is null or an empty string (returns true when using the IsEmpty() function), that item will be skipped and you won't see an empty line in the summary. If, however, there is a valid string there that just looks empty, for example a space character (" "), it will show as a blank line in schedule views, or an extra separator (|) in other views. Check your Contact field and verify that it is actually an empty value. You could also use the Trim or TrimAll functions to return your Contact field value without any extra spaces. I hope that helps! Let us know if you have any further questions. Regards, KC |
|
Posts: 109
Joined: Fri Jul 17, 2009 7:44 am |
Yep! That was it. Thanks for your help.
|
3 posts
• Page 1 of 1
Return to DayBack Calendar for FileMaker
Who is online
Users browsing this forum: No registered users and 2 guests