9 Replies Latest reply on Jan 25, 2016 8:49 AM by DanielShanahan

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

    simonpsmith

      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