hi, i’m exploring how to use scripts.
i have properties table and transactions table.
properties have property ID, status, owner, address, photos fields.
i wish to have a script wherein when status is changed from ‘active’ to ‘closed’, a record will ...