Saturday, May 13, 2017

Something That I Use A lot



Currently I seem to be updating lots of records in Salesforce. Many times, I must do it manually and I have check the data before and after. I usually can get the SF record ID and use that to look at the record. I created this Excel formula to help me; it’s nothing special and I am sure it has been around for ages:

=Hyperlink(Concatenate(“https://orgname.com/”, record id))

The record ID is stored in a column next to the link (or anywhere  in Excel) so for example:

=Hyperlink(Concatenate(“https://orgname.com/”, A2))

It’s not a big deal but it has made my life easier; it’s also something to blog about…lol


No comments:

Post a Comment