Jump to content
Salesforce and other SMB Solutions are coming soon. ×

colour coding marks


Recommended Posts

I want to set up a database to record students marks. I want marks > 90 to appear in a box or container that is red in colour, marks in the 80's to have a blue container.... the mark would dictate the background colour behind the grade. Any suggestions. I had a solution a number of years ago but have not been able to find the source. I know it involved container field with set with several repitions...then I'm lost

Thanks in advance for any advice

Link to comment
Share on other sites

First make a single record prefernces table with container fields containing the colour swatches for the field backgrounds. Create a relationship from the student marks table to this prefs table. Then create a calculation field along the lines of:



mark > 90 ; prefs::red ;

mark > 80 ; prefs::blue ;



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use