Email Enabled Calculated Fields

10 05 2017

I am back! Today I am going to show you how to use calculated fields to form an email address and a clickable link to send to that email address you just created.
The ask was to create a custom list that had the following fields:
Cost Code
Location City
This information just happened to be avaialable in another SQL database, so rather than populate it it manually, I decided to go BCS all over that sucker. BUt, that’s not what we will talk about today.
Once that information is safely in SharePoint via external contentype, I used 2 calculated columns to get the email and the mailto link.
The first calculated column was used to concatenate the cost center and location to form the much needed address. So if you are following at home create 2 calculated columns.
The first colum will take Cost Code and Location city, mash them together and spit out an email address the address in the following format
Since i have no column named store, i will just hard code it in. Here is the email formula:
=CONCATENATE(“STORE”,[Cost Center],Location_City,”@mystore.COM”)

Now, to make it a clickable mailto link, i really had to mess with the html. For your second calc column add this formula:

You guessed it, EMAILCALC is the name of the first calc column.
that’s it.
Love me.


Application Registry Service…what is it? what happens if i delete the db?

24 11 2010

The application registry service enables users to search and collaborate around business data and provides backward compatibility to BDC service.

During my sharepoint 2010 travels, I cam across an interesting issue. In an effort to rename databases to something other the “wss_dbname_reallylongguidthatmakesnosense”, i deleted this database and forgot about it for some time. Low and behold, the application registry service still shows as started and runs happily, or so it seems. I am sure the logs are screaming some bloody murder, but the Central Admin console is just perfectly fine running. Why is this? If I deleted a database, shouldn’t sharepoint be screaming at me with some cryptic message? Apparently not until I actually connect to a BDC service with MOSS 2007 or, I try to manually backup the farm. Either way, there is a way to fix this.

Obviously, you can recreate the database using powershell, but, I don’t know how to do that yet fluently, so I took the easy approach.

1. First I deleted the application registry service.

2. Then I clicked on the wizard. The wizard is kind of nifty, because it tells you with choices what service application can be installed. Low and behold, the ARS is one of them. So I clicked on it and continued.

3. I decided to skip the whole creating a new site collection, since I already had one and success, the ARS db is happily back in sql with its ridiculous long guid name.

Happy time.

More sharepoint alert wierdness! Alert links don’t work after url change.

5 05 2009

If you have been following sharepointdojo, you no doubt now the alert nightmares I have experienced. Here is another one:

Upon migrating my farm to new location and hardware, it was noted that alerts where still pointing to the old farm. How do iyou fix this?

Well the good people over at the msdn forums pointed me in the direction of the sql table that all alert subscriptions are housed: immedSubscriptions.

Below is linkage that shows you how to change the alerts to point to the new farm.

On a side note, always use the alternate access map name and not the server name. Trust me it will save you a huge headache later.