Jump to content
Sign in to follow this  
Steven Cappiello

Need help with multi-user modification timestamp comparison

Recommended Posts

Hi there,

I have a solution in which a handful of users perform actions on the same record frequently. I'd like to create a way to report on the modifications that have been made to a record since the current user's last review of that record.

I started to create a prototype of how I'd like to compare record modification and record review timestamps in order to show ONLY those modifications that have occurred since the logged-in user's last review of that particular record.

Please see the attached file.. I've started but am not sure how to get to the last step... which is, displaying a portal on the right-most tab on the Records layout.

Any advice would be greatly appreciated.

Thanks.

p.s. I tried posting this already but wasn't able to access the post so am posting it again.. it seems the previous one had some sort of error

multiuser_modification_tracking.fp7.zip

Share this post


Link to post
Share on other sites

p.s. I would like to eventually list these records in some form of list view, and indicate which records have updates by using some little visual.. so that it is almost like an Email Inbox, with Unread records in boldface, popping to the top of the list. So, out of 1000 or so records in the database, the logged-in user will know they have to deal with only those that have had modifications made to them.

Share this post


Link to post
Share on other sites

I was able to build a way to indicate IF there is updated material since the logged-in user's review of the record they're viewing.. however, (see attached).. simply by creating a field that compares the max of the user's review records to the max of modifications made by other users to that record .. however, I'm still not sure how to display WHICH modifications have taken place since the user's most recent review of that record...

multiuser_modification_tracking_2.fp7.zip

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
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.

Sign in to follow this  

×
×
  • Create New...

Important Information

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