Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Script or Calculation to refer back to a record


Recommended Posts

I have a layout (called Main Stills) and a layout that is a list of all of the records in that layout (called Stills Report). I've added a Detail button to the Stills Report layout that will ideally take you back to the relevant record. (For example, click the button for Record #3 in the list and it'll go straight to the full Record #3 in the Main Stills layout.)


Can someone give me a lead on how I can tell that button to go to the record associated with that line?



Link to comment
Share on other sites

1) If it is based on the same TO then you can just change layouts (to another layout based upon same table).


2) If not #1 then use GTRR (Go to related record).

Link to comment
Share on other sites

since you are talking about scripting have you ever seen this one. I have 5 phone number fields, 2 land, 1 cell, and 2 fax fields. I used the same validation script for all 5

Let(phone = Filter(Phone2;"0123456789");"(" & Left(phone;3) & ") " & Middle(phone;4;3) & "-" & Middle(phone;7;4))

changing the field name each time.

On the form view it only works for the 2 phone fields Phone1 and Phone2. In the database view it works for both the phone fields and some of the cell phone fields. And when i link this file to another and import the fields it works for none of them. Same formula. going crazy. I have changed "phone" to fax to cell to fax1 just going a bit nuts.

can you help me please? thanks for your time

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use