A custom "activity log"

Platform discussions
,
1

Hi,

Apologies for the basic-ness of my question.

I have a board of employees, which (among other data) shows their current office location.
I want to have a dedicated view/board of location changes. That is: a table that shows when (date + time) an office location was changed for an employee, what the original location was, and what the new location is.

Would appreciate any help, thanks!

2

Hi @urir - one option would be to have a separate board that logs each time a change is made to the location. Let’s call the main board “Employees” and the new board “Employee Location Changes”. Employee Location Changes can be a duplicate of the Employees board, but also add a Creation Log column (this will manage the date/time it was changed).

To further functionality, I would also add a Connect Board column (two-way) between the two board, this way you can easily see a running history of changes

Then setup an automation on the Employees board:

image
image1125Ă—561 33.6 KB

You then just need to complete the mapping of the new item being created in the location change board.

image
image682Ă—553 46.6 KB

image
image712Ă—501 28.4 KB

This will log each change to a separate board for audit purposes. This could be further extended as needed.

Hope this helps, and reach out anytime if you have further questions.
Mark

3

Hi Llamas,

Thanks for the reply. After writing my original message I realized that the “Office location” itself is a mirrored column from another connected board, and as such cannot be added into the new item in the automation process. I installed an app to create a copy of the mirrored column and used that to add into the item, and that now works.

BTW - why do you suggest to use a two-way connection here? Doesn’t that add a risk of inadvertently making a change from the log to the main board?

1 Like
4

Hi @urir - glad you got it working and are satisfied with the solution. The reason I mention creating a two-way connection is connect board settings cannot be adjusted once set. If down the road you prefer a two-way, you cannot adjust it and would have to recreate the columns and connections.

If you start with a two-way and determine you only want a one-way, you just delete the connect board column from the board you do not want/need the connection.

Additionally, you can lock down the column on the other board with edit/view permissions.

Thanks!
Mark

1 Like