You may use below steps to achieve language translation for custom form which is used in SharePoint multilingual site. Create List named as: Translations Above list contains information of translation for different language. I have used language pack Hindi for Language Code: 1081 for SharePoint Site. Columns detail for Translation list: Title: Label code text. […]
About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table with a list of column names or a table type in the first parameter. However there two other […]
Ever wanted to count distinct values in your pivot tables? Something like above: Let’s say you have store sales data. Several products are sold on each day. When you make a pivot table from this data and add product count, Excel counts all products. But we want to see just the distinct count (ie if there is a duplicate product in a day, we want to count it just once). Here is a simple trick to add distinct count to Excel pivot tables easily.
Make better use of the Quick Access Toolbar (QAT) We all know that shortcuts could save us lots of time when working with Excel. Excel has many built-in shortcuts. Ctrl+C, Ctrl+V should be the most popular and commonly used ones as most of us are doing copy and paste daily, or even hourly. ;p […]
How to Check The Active Validation Rules based On SOQL. This Simple query fetches the Active Validation Rules on Object. Select id,Active,Description,EntityDefinition.DeveloperName,ErrorDisplayField,ErrorMessage From ValidationRule where EntityDefinition.DeveloperName=’Object Name’ and active = true to run this query Open Developer Console and Copy and Paste the Above Query in Query Editor. Before executing, you need to enable the […]
Disclaimer: I don’t know what I’m talking about, I’ve done little Win API (Win32) development and I only have a few years of Java development of which maybe 2 or 3 are developing desktop applications with JavaFX (Dashman being my first fully fledged out JavaFX app). Disclaimer 2: I have only tested this on my […]