To only generate a random number when some sort of conditions are met, you should select an Airtable view with the appropriate filters applied. The filtering view can be set in the automation's Run settings.