I have an interface to track overtime opportunities for my team. There is a button to click if you'd like to express interest in working an event with an automation set up to:
1) send an e-mail with your name and the event you're interested in to management
2) automatically clear your checked box and clear your name from "last edited by" so other people aren't discouraged from expressing interest if they think someone has already claimed that day or time.
This works for those with base access, because we can see who updated the field in the activity history. The problem is I am trying to kick everyone out of the base except me, and other team members that need that information won't have access to the activity history.
My questions are:
1) is there a way to show activity history in an interface? I see the area to add comments, but not activity to an interface view
2) is there a way to track the names of everyone who has clicked that button and keep track on it in a separate column so the other team members can see the list of people who expressed interest? For example, anyone who has clicked the "interested" button will have their name take down and added to a list even if their name is cleared by the automation
Thanks!