Add Row Button Results Deleted Row?

I have a button on table A that adds a row to table B. I have an automation that clicks the the button every hour. I have a results column, and generally the results is the row that is created.

The issue is that (very often) the results column will actually be a deleted row. something like #r2304 or something. This is a huge issue because the button on table A is still disabled because the results column isn’t empty, but there’s not actually a record on table B. The doc is an attendance system, so usually it’s ~120 buttons being clicked at once or so.

Has anyone run into this issue?