Calendar Title Field Options

I’m making a calendar based on a current table I have, where one column is JobCode and another is ProjectName. I’d like the Title of the events that appear on the calendar to be JobCode-ProjectName, but I’m having trouble getting this to work. I’ve tried coding this in the onLoad event

{JobCode} = {JobCode}.' - '.{ProjectName};

and setting the Title field of the calendar to JobCode, but that didn’t seem to work. I’ve also tried creating a brand new field and having a select statement for this, but that made the Title of the calendar events completely blank.

Any ideas on how to accomplish this?

Try it this way:

{JobCode} = {JobCode} ." - ".{ProjectName};

but in onValidate to save title …

The only way to do so is save the title you want in a table field and link this in the calendar/title.

This means you will have double information in your table (Jobcode & Projectname in their own db-fields and in the title db field).

Actually this should be solved by SC!!!

@rik I tried adding that in the onValidate event area, but it didn’t change the title. It only shows the JobCode.

You have to make additional field in database (eg titile) and write the value of {JobCode} ." - " . {ProjectName} to this field. Link the calendar title to this database field