Count the Number of Specific Character in a String or Text Box in InfoPath

Tuesday, August 25, 2015

If you want to count the number of a specific character in a string in a field or textbox without coding, you can try this out of the box rules of InfoPath...

Subtract or Add Days, Months or Year to Dates with Custom Date Pattern using PowerShell Script

Wednesday, August 6, 2014

I will share a simple trick for adding days or months to dates and the result will be a custom date pattern. Check the script below… 

Read and Get Values from Excel File using PowerShell Script

Monday, August 4, 2014

What do I use to read data or values from excel file?  And what if I want to read every row on multiple columns? Example data is like this....

Highlight Row, Change Font Color and Highlight One Cell Based on Status or Column Value using JQuery in SharePoint

Friday, July 18, 2014

Colors are good indicator and can tell you something. Using colors on a list can help you identify or at least help you make a quick conclusion about an item. Also, plain texts can be boring and bland.

In this post, I will cover 3 scripts that will apply color to your list based on the status or a column value. This script is working on both SharePoint 2010 and SharePoint 2013...

Removing Unwanted White Pages and Spaces in SSRS Report Builder

Thursday, July 10, 2014

I ran into an issue on my SSRS Report Builder of having blank white pages on print view or exported PDF files or word files. Sometimes it expands my report table/line horizontally then when I check print preview, it will extend the lines or tables into the next page...

Deleting or Removing Corrupted Web Parts in SharePoint

Tuesday, January 28, 2014

If you encountered an unexpected error when trying to edit the web parts or the site never loads, it means that your web part is corrupted. You need to delete that web part from that site or page...

Highlight SharePoint Task List Row based on Multiple Due Dates

Monday, January 13, 2014

I have a requirement that needs to highlight “Incomplete” row based on a certain task with a unique due date. It also highlights the row if the task is not yet completed and exceeds the due date.