TechnicalWorldOfMe

SharePoint List: How to Display Days Elapsed or Countdown  Problem :Have you thought about introducing a countdown or even days elapsed as a feature in a sharepoint list? Solution: Well i have a solution for you using javascript. It does get a little involved with code but very easy to implement. 4 Step Implementation: Step 1 : Create the list in sharepoint and name it what you like Add two columns: Column 'Today" type = Date and Time Column 'Days Elapsed' type = calculated Step 2 : Under list settings, go to column you have just added called Days Elapsed and enter the following formula: =ROUND(Today-Created,0)&" days" --> Output Data Type as a Single Line of Text. Step 3 : Some code --> Copy the code below and paste it into a nodepad, go through the code and change the name of your list: Look for LIST NAME , thats where you will change the name to your list name and also change the column name for "Today" if you named it...

SharePoint: How to set up a pop up message in a list Would you like to display a message to the user once they have selected Save in a SharePoint list.We will be performing this task using the javascript PreSave function in newform.aspx. Well this is how you do it. Watch this how to video: Potential Issue: If you have required fields in the form, the presaveaction() function will display pop up message regardless of required field. You will need to perform a validation for required fields. This will be a separate post later. OR Follow these instructions: Step 1: In SharePoint site, go to your list, then right-click Add New Item. Step 2: Select Open in  New tab  Step 3: Go to the newly opened tab and then go to Site Actions (Top Left) then select Edit Page. Step 4: You will then select Add a Web Part  Step 5: Once you have selected Add a Web Part, at the top you will then select Content Editor, then click add. Step 6: Select t...

HOW TO IMPORT OUTLOOK GLOBAL LIST FROM     WITHIN EXCEL In one of my projects, I needed to import information from outlook into excel. To take on this task, i needed a intro lesson to macros. What will this macros code do? The macros code will be activated before right click activity. Once the macros is activated, it will pull up the Global Address Book, there you can search your directory of contacts then select add. Your selection will import that contact (in my case i would just the name, but you can do email and other attributes) . The following is what i would like it to do: Here you have the excel sheet, the red area is where i would like to fill a name. I will select that cell, then right-click. With the right click the Address Book will pop up. Once you have the address book up, you can select the name you would like to fill. Then click add. In this screen shot you can see that the selected cell has been filled. H...