How to use linking records in scripting

I have 2 tables, staffs and works. there are 5 staffs. and there is a field called duties in my works tables. I would like to write a script to assign the duties in my duties field. I am using the linking record but I don’t know how to use the built-in methods to do so. can anyone help me thanks.

Welcome to the community, @brian_yu! :smiley: Have you reviewed the scripting API documentation related to linked record fields (referred to as the multipleRecordLinks type in the docs)? There are examples that show both the read and write formats for the field. If you’re having problems implementing a solution, please share an appropriate snippet from your code—remembering to format it using the “Preformatted text” option in the toolbar (icon: </>)—and we’ll try to help.

1 Like