I'd like to build a ticketing system where requestor and administrator can communicate using comment to trace the conversation.
- Requestor uses a form to create a ticket to administrator but doesn't access the sheet itself.
- As new entry is created by the form, Administrator then provide comment for the requestor. This new comment triggers update request which is sent to the Requestor (indicated by field of 'created by' - a system generated column).
- Requestor replies to Administrator by adding comment using Update request form.
The issue that I have here is that because Update Request is triggered by any new comment, requestor's own comment also triggers Update Request back to him/her - which is confusing.
Is there a way to trigger an update request based on new comment, but not when the requestor is the one placing the comment?
Thank you