OK, I've worked on this all afternoon and either I'm missing something or it can't be done. (My bet is I'm missing something.

I want to have an Icon show on a record layout based on a date field in a related portal. That portal is on the same layout within a tab.

Basically,

Case(

Interview_Date = Get ( CurrentDate);GetRepetition ( g_Interview Today Icon ; 1 );

GetRepetition ( g_Interview Today Icon; 2)

)

I set up a calc field and a container field. If I put the Calc field on the portal it works fine. But, if I put it on the contact record it does not.

Any suggestions will be greatly appreciated.

Al

Hi Al,

If you put it on the contact layout itself it will only be based off the first related record value. Can you explain your setup with more detail?

Right now I am guessing that you have a contact table and related interview table. I am also assuming that the calc field is a part of the interview table?

P.S. you can shorten up your case statment to be

Case(

Interview_Date = Get ( CurrentDate); g_Interview Today Icon; g_Interview Today Icon [2] )

)

The interview table has really turned in to more of a tasks table. So it is a one to many relationship with contacts. The calc is based off of an interview date. If the interview date in the interviews table is today show Icon.

The Interviews/tasks are in a portal on the contacts layout. What I want to accomplish is quickly show that I have a task or interview related to the contact for today.

P.S. Thanks for the shortening tip.

Al

Try a calculation in the Contacts table =

g_Interview Today Icon [ 1 + IsEmpty ( FilterValues ( List ( Interviews::Interview_Date ) ; Get(CurrentDate) ) ) ]

Comment:

As usual, spot on! Thanks to both you and Mr. Vodka.

Al