Welcome to the community, @VR_Team! :grinning_face_with_big_eyes: Normally when I see a question begin with “is there a way to have a script…”, I’m ready to say “Yes”. However, I then red the end of your post:
Technically, the answer is still “Yes,” but I have a question for you: if the records are linked, why not use a lookup field to pull in any data from that linked record? No scripting required.
For example, say you have two tables: [People]
and [Companies]
. Records in the [People]
table track each person’s individual info: name, phone, home address, etc. There’s also an {Employer}
link field, where you can make a link to a record from [Companies]
to indicate where they work. If you want to have their work address visible in their personal record in [People]
, you can add a lookup field named {Work Address}
to the [People]
table, using the link to their company to bring in the company’s address. If they change employers, just change the link to a new company, and that new company’s address would appear in the {Work Address}
lookup field.
Is this the kind of thing you’re talking about, or is it something else?