Tomo1 Posted June 11, 2001 Posted June 11, 2001 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?
BobWeaver Posted June 11, 2001 Posted June 11, 2001 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.
Tomo1 Posted June 11, 2001 Author Posted June 11, 2001 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?
LiveOak Posted June 11, 2001 Posted June 11, 2001 Two things: Make sure the date field has a fill of transparent and make sure the date field is in front (arrange, bring to front). -bd
Tomo1 Posted June 13, 2001 Author Posted June 13, 2001 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.
Tomo1 Posted June 13, 2001 Author Posted June 13, 2001 Is there anyway for the colours to work ok when the file is hosted over the web.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now