Hi all

I have created an employee vacation scheduler that is basically gantt charts using a combination of repeating fields.

On the employee record I can add related records (timeOff), set the dates, approval status, approved by and a note.

This repeating field (cChart) is then recalculated into a summary field (sChart, also repeating) that shows the given date range (31 repetitions) for the employee. Numerical values complete the repeating fields. 0 is no data, 1 is approved, 2 is rejected and 3 is pending.

On another layout I have the Employee table in List view and each employee has the sChart repeating field shown in a matrix so the user can see the specified date range and when and where vacation time might overlap or coincide with other employees that might have vacation scheduled.

This works fine but I would like to add some additional functionality for an "at a glance" option. I would like to allow the user to hover their cursor over the vacation blocks displayed and in the tool tip show the status, who approved, and the short note the approver entered, if any.

I have it semi-working, however if the employee has multiple vacation day(s) on the matrix, the tooltip only seems to show the note from the first related record. Conditional formatting or calculations based off of the numerical data (i.e., approved, rejected) all displays properly.

Any tips or advice?

Edited September 8, 20241 yr by madman411

I wasn't able to follow your description.

If (as it seems) you want the tool tip of a repeating calculation field to show data from the Nth related record, where N is the repetition number, then use something like:

GetNthRecord ( Related::Field ; Get ( CalculationRepetitionNumber ) )

as the tool tip calculation formula.
 

This should also work for a summary field defined to summarize repetitions individually.

 

Edited September 8, 20241 yr by comment

Hi @comment

I believe you actually helped me way back figure the initial structure of a similar project. Your calculation suggestion just returns a ? so I'm assuming the record number and repetition number isn't matching properly.

In the context of the linked thread, the asset (in present case) is then displayed in a list view and the summary field is next to it. Any note in the asset booking record should be shown in a tooltip when hovering over the summary field's respective repetitions.

If you're getting a ? with the above formula then there isn't a related record at the Nth position.

 

I'm confused. There is a related record as it's getting the date block from it that's displaying on the repeating field. Perhaps a relationship issue?

I don't know. Here is a simple file showing the principle at work. You'll have to see what's different in your file.

 

ToolTipsR.fmp12