Hello Everyone!

I've got very much trouble with a report. I whant to list all linkt users (co-workers) of an Appointment? I found no way to do this. I've tried to list all linked contacts there a no other Daylite users listed.
IS THERE ANY POSSIBILITY?

Thanks
Thomas

Hi Thomas,

Since the relationship between the appointment is one to many, One appointment -> many contacts, you need to use a table to populate the contacts.

I'm guessing you have a table that displays the appointments. Convert a cell in the row to a box, and then drag in a table. Set the standard filter on this table, kind contacts. This table will now be populated with the contact names linked to the appointment.

You might have to readjust the box so you can see the able properly.

Hi, Oscar
thanks for the fast answer,

i've tried fellowing
i have a table with Appointments,
in on cell, the names with linked Daylite Users should be displayed (not Contacts etc.) i've tried with f-script, but the array returns only contacts and not linked users.

Is there any F-Script solution for this problem?

Thanks a lot
Thomas

Try the following path extention:

meetingInvitees.name

This should give you an array of names.

Hi Oscar,
i'm quite new to F-Script, could you explain me, how to make that there is a string returned. The count of the resulted Array is 0.

Thanks for the great help

Well depending on the format of the report the path of this item will vary.

Let's say we're creating a report to display a list of appointments. We drag a table into the strip and then we set the data source of the table to Appointments. Next go to the columns tab and click Configure Columns . Add the items you would like to display. Once you've done that click OK.

If you now click in one of the table cells that contain a token/dynamic text another window will appear. Click on the token you should see a Path field below, the pall might me something like this: enclosingTableRow.data.object.subject

swap the "subject" with "meetingInvitees.name"

Now if you run the report an array of linked user names will appear. This issue now is that it's an array and it doesn't look professional.

You can either use fscript to add all this names into one string or you can insert a table into the current table to list the names. The reason for this is because users linked to the appoint are a list or array and tables are used to basically display lists of objects.