High GuiGuy,
normaly!!!, if you write something in the “Title” and “Description” Field.
if nothing is displayed, something is wrong.
If that works, then you will soon realize that this is not usable, because when you have to deal with customers, you have to enter the name of the customer over and over again, if you need to record appointments with customers and that completely responds the computer science. As a driving instructor, I need in these fields various information such as category, name, vehicle, meeting point.
So far I have solved this as follows.
In the form with fields like categories (driving hours, simulation, test), customer name, meeting place, vehicle and store this information. With “onAfterInsert” I have dan the CalendarID in the field “Title” written.
In the form the field “Title” configured as data type “Select” and in the lookup created a script, which searches me all data.
This worked satisfactorily up to version 9.0.18. Since 9.0.19 / 20, the charging time has increased from 2 seconds to more than 1 minute, thus unusable. At the moment I do not know what to do. help from scriptcase is not to be expected. I have already thought of buying a ticket subscription. but it is not my fault, why should I pay for it.
script
SELECT
CD.CalendarDataID,
CONCAT(CDC.CalendarDataCategory,’: ',
CASE WHEN DS.Alias > '0'
THEN CONCAT(DS.Alias,' = ',EP.EmployeeShortName,'
‘)
ELSE
CASE WHEN C.Firstname IS NOT NULL OR C.Lastname IS NOT NULL
THEN CONCAT(C.Firstname,’ ‘,C.Lastname,’ = ‘,EP.EmployeeShortName,’
‘)
ELSE CONCAT(EP.EmployeeShortName,’ = ',P.ProductName) END
END,
CASE WHEN Category > '0'
THEN CONCAT('[Category]',':',' ',Category,', ')
ELSE ''
END,'',
CASE DSL.Transmission
WHEN 'M' THEN CONCAT('[Manual]',"
“)
WHEN ‘A’ THEN CONCAT(’[Automatic]’,”
")
ELSE ‘’
END,’ ',
CASE WHEN CD.VehicleID > '0'
THEN CONCAT('[Vehicle]',':',' ',V.Alias,"
")
ELSE ‘’
END,’’,
CASE WHEN CU.CourseLocationID IS NOT NULL THEN CONCAT(B.Address,CHAR(10),Cities.ZIP,' ',Cities.City)
ELSE ''
END,'',
CASE WHEN DLSLoc.Location IS NOT NULL THEN CONCAT('[MeetingPoint]',': ',DLSLoc.Location)
ELSE ''
END) AS CalendarView
FROM CalendarData AS CD
LEFT JOIN Company AS Comp ON (CD.CalendarDataGroupID = Comp.DrivingLessonCalendarDataGroupID)
LEFT JOIN Contacts AS C ON (CD.ContactID = C.ContactID)
LEFT JOIN CalendarDataGroups AS CDG ON (CD.CalendarDataGroupID = CDG.CalendarDataGroupID)
LEFT JOIN CalendarDataCategories AS CDC ON (CDG.CalendarDataGroupID = CDC.CalendarDataGroupID)
INNER JOIN EmployeeProfiles AS EP ON (CD.EmployeeProfileID = EP.EmployeeProfileID)
LEFT JOIN DrivingStudents AS DS ON (CD.DrivingStudentID = DS.DrivingStudentID)
LEFT JOIN CourseUnits AS CU ON (CD.CourseUnitID = CU.CourseUnitID)
LEFT JOIN Products AS P ON (CU.CourseUnitProductID = P.ProductID)
LEFT JOIN Branches AS B ON (CU.CourseLocationID = B.BranchID)
LEFT JOIN Cities AS Cities ON (B.CityID = Cities.CityID)
LEFT JOIN Vehicles AS V ON (CD.VehicleID = V.VehicleID)
LEFT JOIN
(
SELECT
DSLd.DrivingStudentLicenseID,
DSLd.DrivingStudentID,
DSLd.DrivingLicenseID,
DSLd.Transmission,
DL.Category AS Category
FROM DrivingStudentLicenses AS DSLd
INNER JOIN DrivingLicenses AS DL ON (DSLd.DrivingLicenseID = DL.DrivingLicenseID)
)
AS DSL
ON CD.DrivingStudentLicenseID = DSL.DrivingStudentLicenseID
LEFT JOIN DrivingLessonStartLocations AS DLSLoc ON (CD.DrivingLessonStartLocationID = DLSLoc.DrivingLessonStartLocationID)
WHERE CD.CalendarDataGroupID = CDG.CalendarDataGroupID AND CD.CalendarDataCategoryID = CDC.CalendarDataCategoryID
