Page 1 of 1

Day Schedule Summary

PostPosted: Mon Sep 10, 2018 3:00 pm
by Jim2001
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.

Re: Day Schedule Summary

PostPosted: Tue Sep 11, 2018 8:36 am
by kcembrey
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

Re: Day Schedule Summary

PostPosted: Tue Sep 11, 2018 8:53 am
by Jim2001
Yep! That was it. :roll: Thanks for your help.