looking for trigger & automation guide

is there any guide about < trigger & automation >?
just like Airtable, i would like to make automated tasks when a record row is generated -> create new row in another table
ex. when a new record is generated in a table, then create another record in a different table based on the values.

what kinda guide do i have to look at?
i watched function, custom function, background task video.. but all of them are not about trigger based automation. so frustrated.. please help me