Help with deleting data entries based on value

Need help Database
1

Is it possible to delete an entire row based on the value in a field?

  1. I have two tables. One is connected to the other. https://bit.ly/3rQKOti
  2. When a user manually deletes a row in table (repeating group) one it updates a connected field in table two saying (deleted thing) https://bit.ly/3HV4lOR .
  3. I would like to automatically delete that row (deleted thing) with an if true workflow but it’s not working? I tried using if true variable name = is empty but it’s not triggering. https://bit.ly/3rT539N Is that because the field isn’t actually empty?

I realise a workaround is to add all the fields to one datatype but at its core, it seems wrong to do that?

Any advice here would be much appreciated :slight_smile: