Discussions

Expand all | Collapse all

Highlight Duplicate entry on Report

  • 1.  Highlight Duplicate entry on Report

     
    Posted 10-24-2018 15:08
    Looking for a formula that will highlight if a Name Populates twice on a report.  We are having employees log into projects to track time.  Sometimes our employees forget to log out and start a new project.   ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1758546/RackMultipart20181024-88524-mm8ezw-Livework_view_inline.JPG?1540393682">

    Appreciate any help on this.  

    Thanks,


  • 2.  RE: Highlight Duplicate entry on Report

    Posted 10-24-2018 17:25
    I am not well versed with the formula - so I hope someone can help you there.

    But, to avoid this situation of not entering the log out time, can you insert a dynamic rule in the form to say when the user is modifying the record, make the end field a required field to enter the date to close
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1758565/RackMultipart20181024-67935-1eos93r-Log__out_rule_inline.jpg?1540401946">