Problem: can’t put in all cities in the world as a database, as that will be too large and slow when picking in a form.
So I’ve set up a location field, and then it makes the city entity if it doesn’t exist, and links the right city if it does exist. The bug is that sometimes it creates a new city even though the city already exists.
Not sure I fully understand what is going on, nor how it is supposed to work, but by guess is that your formula field (which is asynchronously updated) is not giving the correct city name at the time the first automation runs, meaning that your automation formula is trying to find a city in the database with the name ‘Invalid City’. This then means the last automation is running, and new city is being added.
Just a hunch.
