My goal is to have an automation that will run in a JSM project when a ticket is made that will look at current objects in Assets and either create an object if a field is not found or update an already existing object if the field is found.
I currently have an automation rule that:
- Creates an object with the following fields
- Assigns the object to someone
- Ties a serial number to the object
- Ties a branch to the object
Right now, that automation is very simple and just makes an object. What I'd like it to do is include a check against current objects by looking at the serial number field and if that serial number exists I want it to edit an object instead of creating an object. Finally, if the serial number does not exist, then it just creates the object.

This is my current create object automation, which is running on issue creation. I want to add the Lookup objects action and look at all current object's Serial Number's and if it matches, I update the object with the matching serial number otherwise i create a new object.