Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 19, 2024 10:37 AM
Apr 19, 2024 07:52 PM
I think we'd need a little more information to help you figure out if it's possible to create an automation for this. Can you explain the process more in-depth with each step of the ticketing process?
Apr 19, 2024 11:34 PM
clients email our helpdesk email
- email is broken into a spreadsheet in make.com
- Airtable listens to a new record in the spreadsheet and imports it
- our Customer Support team reviews the tickets, finds a solution and emails back to client view another integration with Make.com
- the above works well. As I stated in the original question - what we would prefer is that when the client replies to the response from out team, that the response gets appended to their original email.
Apr 20, 2024 12:37 AM
Yeap, you could trigger an automation to look for another record with that same email address and update that record. You could then add a "Run a script" action at the end to delete the triggering record if you wanted to, and if you look on the forums you'll find examples of said script
Here's Airtable's guide on how to find and update a record: https://support.airtable.com/docs/use-automations-to-timestamp-status-updates
Apr 22, 2024 12:12 AM
Thank you for your response. My question about searching for an email record would be a match that is an email address but is not a connection to a previous ticket, it could be a separate idea/issue. I think I would have to match to the subject or possibly the 2, email and subject?
Apr 22, 2024 12:15 AM
Yeap, that sounds right!
Apr 22, 2024 12:23 AM
Apr 22, 2024 01:31 AM
That's not possible I'm afraid. You'll need to use a "Find Record" action for that
Apr 23, 2024 10:58 PM
OK, I see the find record feature. How do I match it against the message and the user email?
Apr 24, 2024 03:05 AM
You'd use the 'Find Record' action to look for records with those values? Sorry, I feel like I'm not understanding something here. What difficulties have you faced attempting to set up the Find Record action? Here's an Airtable guide that might help: https://support.airtable.com/docs/linking-existing-records-using-automations