A change to a record ref field causes a change to a field in the referenced record?

[Patrick_Paul]

I have trainee records that reference mentor records. In the trainee record, when I fill in who the mentor will be (it’s a ref field), I’d like the referenced mentor record to have an automatic change to one of its fields (I have an enum “status” field that I’d like to change to “active”). Is this possible, and if so, how is it done? It needs to not interfere with user agency to later change the mentor’s status manually. Thanks!

[MultiTech]

This post will have some details and techniques that will help you:

Quick Update System - How to update records in your app with a push of a button Tips & Tricks 💡

“How can I update a parent record when a child record is changed?” “How can I mark all the line items in an invoice as paid when I mark the invoice as paid?” “If I have App Formulas inside a physical column, how can I get those to update like a virtual column?” “How can I recalculate formulas with a push of a button?” All of these situations can be solved by implementing a Quick Update System inside your app. What is the Quick Update System? A way to update app formulas and recalculate v…