Welcome to the community, Haydn! :grinning_face_with_big_eyes: This can’t be done natively inside of Airtable, but it’s possible using an integration service like Zapier or Integromat. Zapier may be slightly easier, as it has a “New record in view” trigger that you could use.
Set up a view on your table that only shows those records where {Column B} is set to “NO”. In Zapier, start a zap with the “New record in view” trigger, targeting your base, table, and the specific view that you just made. The second step in the zap would be making a new record based on the values in the first one. However, the creation of this record will likely re-trigger the zap if {Column B} in the new record is set to “NO”. To get around this, just don’t set that value for the copied record. If you need that value to be the same, then we’ll have to come up with an alternate trigger to avoid an endless loop of new records created.
Can you describe your use case in a bit more detail? Perhaps there’s another way to accomplish what you want without running the risk of an endless loop in Zapier.
