AnsweredAssumed Answered

A script to make a button click take me to a particular record

Question asked by simonpsmith on Jan 25, 2016
Latest reply on Jan 25, 2016 by DanielShanahan

I have a contacts layout where I want to be able to be viewing one contact's record and move to their partner's record (if applicable) at the click of a button in the layout.

 

Basically I need to be matching the "Contact Partner ID Number" to the "Contact ID Number" (if there is one) but can't find how to do this effectively.

 

If I had a simple table (below), with 4 fields and 5 records... by clicking a button while viewing Tom's record, I'd be taken to Sally's (record 5); from Dick's I'd go to Jane's (record 4); Jane's would take me to Dick's (record 2) and from Sally's I'd go to Tom's (record 1). As Harry has no partner on the system then nothing would happen.

 

Hope someone can help.

 

Record IDContact ID NumberContact NameContact Partner ID Number
113579Tom59786
224680Dick46975
313648Harry
446975Jane24680
559786Sally

13579

Outcomes