What is the best way to have a lookup that supports creating a new record if one isn't found?

Hi Jack, maybe you have tried this and could point me in right direction.

I needed to implement same as your idea but this time on a table. So instead of using a Template field I used same idea , but used a Row Action

But now the issue i’m facing is that it updates all the rows , not only the Row I Selected action from.

Any idea?