Get Container Field to show ICON?

[aldipalo]

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

[mr_vodka]

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] )

)

[aldipalo]

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

[comment]

Try a calculation in the Contacts table =

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

[aldipalo]

Comment:

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

Al