Solved: Log book for all actions in app - Page 2

sharad_gupta · 04-27-2020 12:19 PM

Hello everyone,

I have a table of project list and another of project log. In which any changes occur to project list goes to project log. Like, status “add” username “xyz” other details of project list. I am doing it with the combination of action and workflow. The problem is when it comes to update in workflow, it sends the new values to the project log with status “update”. But i want the compare value in the log table. And also the red color in the change cell. So that i can easily get that ok! This person changes this value.

WillowMobileSys

Based on discussion in your other thread, I have realized that the expression above needs amended to this instead:

AND( ISNOTBLANK([Prior Row].[Column X]), 
     [Prior Row].[Column X] <> [Column X]
)

I believe this will cover both the case if [Prior Row] is blank as well as if [Prior Row].[Column X] is blank.

Revisiting showing the highlighted column ONLY for your table view the full expression would then be:

AND( CONTEXT("View") = "My Table View",
     ISNOTBLANK([Prior Row].[Column X]), 
     [Prior Row].[Column X] <> [Column X]
)

View solution in original post