Highlight record when new record added to related table | Discussions

Expand all | Collapse all

Highlight record when new record added to related table

  • 1.  Highlight record when new record added to related table

    Posted 08-23-2017 22:06
    I am not great at writing original code and I can't find this anywhere. 

    I am trying to automatically highlight a record on a table when a new record is added to a related table. 

    In this case I have a "Claims" table and "Request" table. The relationship is many requests to one claim. I would like the claim to be highlighted when a request is added. The requests are coming from a separate application that is open to all on the internet. I have an action setup that when a new request is entered, it copies that request to the request table in my closed application and is then linked through the table to table relationship to the corresponding claim. 

    So in summary - someone on the internet enters a request. The request is copied into a table in a different application and is then linked to a claim. When that happens, I would like the claim to highlight red to alert me that a request has been added.

    I hope this makes sense. Any help is greatly appreciated.


  • 2.  RE: Highlight record when new record added to related table

    Top
    Contributor
    Posted 08-23-2017 22:20
    You can accomplish this a few different ways with some summary fields.  

    My questions;
     How would those records become 'un-highlited'?  Over time, or do you do something to the request that would indicate you have acknowledged it?

    Once that is determined you will want to make sure you count for that in the logic of the summary field.
    But you could just summarize the '# of new requests' that are not acknowledged.

    Then your highlighting criteria would be 

    If([# of new requests]>0, "#color", "")


  • 3.  RE: Highlight record when new record added to related table

    Posted 08-23-2017 23:01
    I would like it to stay highlighted until the status field changes to closed on the request.

    Thank you for your help!


  • 4.  RE: Highlight record when new record added to related table

    Top
    Contributor
    Posted 08-24-2017 01:34
    What you will want to do is create a summary field for the # of requests, where the status is NOT equal to 'closed'.  

    Then it will show a count for your highlighting formula that i mentioned above.