SeedCode Support Forum

SeedCode Calendar Pro build 5.6

The documentation for the calendar says "simply add fields from your event table-- that would be a field from Sample Events in the original calendar file.
Next, change the Refresh Window step at the end of the "Refresh Calendar..." script to use the Flush Cached Join Results option".

I have followed these instructions.

The first thing I notice is that the script step is already using the flush cache join results option.

The second thing I notice is that the data appears to be OK when I first add a new appointment but as soon as I move to another day the data has not moved. For example, if the 11am slot showed "XYZ" when I move to another day the 11am slot continues to show "XYZ".


Presuming that I had done something wrong I opened a brand new copy of the calendar and make the changes. In this case the fields do not display any data, despite having data there.

Hi Malcom,

I'll need to check the docs on that version, but it looks like they might not have been updated correctly. The Refresh script step in the stock version of 5.6 is set only to run for the Gantt chart and does not get called in day view. That's why the fields from SampleEvents aren't getting flushed. The If calculation there should be updated to run for the Gantt and for day view, i.e.

PatternCount ( $$sc_Mode ; "Gantt" )
or
PatternCount ( $$sc_Mode ; "Day" )

like this:


That should fix it, but let me know if it's still giving you trouble.
-Jason

That resolves the problem with the data hanging around. However, now there is nothing displayed at all.

The attached images show that there is a field from a related table place into the layout. I want to use fields rather than the z_c_alternate_summary because I want to have regular columns of data.



The next image is just a sanity check. The event is on the right day, the right time, the right person and we can see a bit of data in the event detail view.


The problem is that the extra data that I want to appear is not being displayed. I'd rather like to see that information here.

Hi Malcolm,

The relationship between CalendarRows and Sample Events is by

CalendarRows::CalendarEventUIDCalc_FirstValue = SampleEvents::_id

So we should make sure that CalendarRows::CalendarEventUIDCalc_FirstValue is correct and that the relationship to sample events is correct. I do this by putting the portal row into focus and and checking the following two fields in the data viewer.



If they're both populated/correct, then it's probably just a field alignment issue on the portal. Otherwise, we check either the calc field in CalendarRows is not right or the relationship. Can you tell me if both are populated like the above image?

Thanks!

CalendarRows::CalendarEventUIDCalc_FirstValue does contain a value.
SampleEvents::Summary is empty

There is an event which has that ID and the summary field has a value

Thanks Malcolm,

Then there's something wrong with the relationship between CalendarRows and SampleEvents which should look like this.



If you're still having trouble, I can take a look at your file and see if I can tell what's happening there. If you'd like to send to me, then please contact me at [email protected] and we'll set that up.

Thanks!

I'm seeing what you're seeing in the screen shot.
I'll flick through a link to the file under the subject line: Malcolm's Wonky Calendar