Tuesday, May 28, 2019

10 Excel Skills and Top 10 Sites

10 Excel Skills that can help you analyze data like a pro:
  1. Sparkline
  2. Power Pivots
  3. Conditional Formatting
  4. Text Formulas
  5. Slicers
  6. Flash Fill
  7. Charts
  8. Vlookup
  9. IF Formulas
  10. Quick Analysis

Thursday, May 16, 2019

SharePoint Designer 2010 - Set Variable [Today]-x Days



To set a DateTime field to [Today] + 5 days using a SharePoint Designer 2010 Workflow, this is what I did:


1) Create a Local Variable (ETA Date) of type Number
2) Use a Do Calculation task in the workflow and set:

value: Workflow Context:Date and Time Last Run (As Double)
operation: plus
value: 432000 (number of seconds in 5 days or 60*60*24*5)
Output to: Variable: ETA Date


3) Finally, set the value of the respective field of the current item to the ETA Date variable
In your case, use the subtract operation and the second value is 2419200 (60*60*24*28).


Note: Compare the Date in Workflow, Current Item:ReminderDate equals (ignoring time) Today


Reference Link

Friday, May 10, 2019

Handel Multiple Click on Elements JQuery

I have experience that user on the page try to click multiple time on the button, in case of page delay, this is a short way to handle such issue.


This will remove all event handlers:

$(element).off().on('click', function() {
    // function body
});

To only remove registered 'click' event handlers:

$(element).off('click').on('click', function() {
    // function body
});

Wednesday, May 8, 2019

Send E-mail from javascript using REST API - SharePoint

In SharePoint 2013 we can send emails using REST API where we can utilize SP.Utilities.Utility.SendEmail for doing the job. 

Note: The recipient is limited to a valid SharePoint user for security reasons.



Note: You can add 'CC' and 'BCC' property also to send email, property 'results' having array.

Friday, April 5, 2019

Remove a specific class from all child elements, and add new class



$('#parentDiv').find("*").removeClass("old-class").addClass("new-class");

Thursday, March 28, 2019

Useful Windows Command Prompt Commands

1. Command History: You can track down your command history.
c:\> doskey /history

2. Run multiple commands:You just need to put “&&” between each command and save some time.
c:\>winword && notepad && msexcel

3. See PC driver list :You can see all the drivers installed on your computer.
c:\>driverquery

4. Send an output to clipboard: Save the output of a command.
c:\>ipconfig /all | clip

5. Create Wi-Fi hotspot right from the command prompt
Before opening the Command Prompt to execute the commands needed for this, you need to open Control Panel and find Change adapter settings in the Network and Sharing option. There, click on the connection you are using and click on Properties. Now find the sharing tab and check the option “Allow other network users to connect through this computer’s internet connection.”

-Open the Command Prompt with administrative privileges and enter the following command to enabled hotspot:
c:\> netsh wlan set hostednetwork mode=allow ssid=Youthotspotname key=yourpassword

-start the Wi-Fi hotspot
c:\>netsh wlan start hostednetwork

-To stop it, simply enter this command:
c:\>netsh wlan stop hostednetwork

Wednesday, March 20, 2019

Upload Attachment to SharePoint Site List Item

Application Form Window