Calc change, but where is it?

Support for our integrated Contact Manager, Calendar, and Project Tracker.
Posts: 7
Joined: Mon Dec 01, 2008 11:26 am
PostPosted: Mon Dec 07, 2009 2:17 am
Hi All and John

Im trying to modify what is shown on the actual "booking bar" in the schedule horizontal view.

It refers to:z_ResourceTimeAppointmentDisplayCalc
But that in turn refers to:ApptContactDisplayCalc

But I cant seem to find it... I'm still learning this solution so I do hope that you can assist me, in finding it.
Specifically, I'd like to change it so that The appointment title (and assigned users) are displayed on the "booking bar" and NOT the project name or client name. Plan is to also change the layout slightly to accomodate two lines for more info. The amount of text that fits right now is not enough for us.
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Sat Dec 12, 2009 8:02 am
You'll see one instance of this...

Extend ( ResourceChartAppts01::ApptContactDisplayCalc ) & " " & Extend ( ResourceChartAppts01::ApptTitle ) ;


...for each column on the chart. Feel free to replace all of that with something like:

Extend ( ResourceChartAppts01::ApptTitle ) & " " & Extend ( ResourceChartAppts01::z_ApptUserDisplayCalc ) ;

Or if you think your titles are too long try:

Left ( Extend ( ResourceChartAppts01::ApptTitle ) ; 6 ) & "..." & Extend ( ResourceChartAppts01::z_ApptUserDisplayCalc ) ;

Hope that helps,

John
John Sindelar
SeedCode
Posts: 7
Joined: Mon Dec 01, 2008 11:26 am
PostPosted: Wed Dec 16, 2009 4:02 am
Ok I know its been a long time since I did any proper FMP developing (FMP7 actually, and right now it feels like I've forgotten most of it...).

You wrote:
You'll see one instance of this...

Extend ( ResourceChartAppts01::ApptContactDisplayCalc ) & " " & Extend ( ResourceChartAppts01::ApptTitle ) ;
...for each column on the chart.

But When I look at the layout I have ONE repeating field in the horizontal schedule view. Not one for each column. And if I just dbl click to edit I get this:
Image
This is where it refer to the table "ResourceChart".
But if I go to the tables:
Image
There is no "Resourcechart" table to be found.


But I can see it in the relations view... I know this all is juist a showing of my shortcomings in FMP but I would like to fix some of these things so that we can actually start using Seedcode calendar for real.

So I humbly ask you to explain step by step where To actually find and change this in our fmp file. I know its me not really understanding fmp enough (and could do with a bit o learning) but since I dont have time for it right now I still ask, even though you shouldnt need to be bothered with stuff like this... :-)

Humbly yours

Erik
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Dec 16, 2009 7:45 am
Hi Erik,

My instructions above were for editing the field "z_ResourceTimeAppointmentDisplayCalc" in the Resources table.

You'll see a comment toward the end of that calc definition like this:

"Edit below here to change what shows up on the horizontal scheduling screen for each appointment."

You'll make the changes I suggested above after that comment.

By the way, there is no ResourceChart table, because that is a "table occurrence" or an instances of a table on the relationship graph. You can tell which table a table occurrence comes from by hovering your mouse over the little arrow beside the table occurrence name on the relationship graph. You'll also notice that are fields are prefixed with the table name or an abbreviation of the table name, so "z_ResourceTimeAppointmentDisplayCalc" is in the Resources table.

Hope that helps,

John
John Sindelar
SeedCode

Return to SeedCode Calendar

Who is online

Users browsing this forum: No registered users and 3 guests

(855) SEEDCODE
[email protected]
Follow us: