Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8549 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Is it possible to have a Date field, but behind have a coloured calculation field. So when the date becomes so many days old, the coloured field would show through and the date would appear, say red. I know this is very vague but it's hard to explain?

Posted

Make a global container field called "Red", and paste a red rectangle into it. Then create a calculation field BkgndColor with the following formula:

case(Status(CurrentDate)-DateField>5,Red,"")

The result of this calculation should be set to Container.

Then place this field behind your date field. Make sure that the date field is transparent. Now, if the date is more than 5 days old, the background will change to red.

Posted

Thanks for your reply, I have already got the colour to change when the date is overdure by 5 days and Difined the fields as you stated, but the trouble I can't get the date field to be transparent. They just Block each other out. ie: you can only have either the date showing or the red?

Posted

I have now solved the problem. In table view, there is no way to put fields behind each other, they always display next to each other.

Thanks for all your help.

This topic is 8549 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.