ShowInEditForm and ShowInNewForm properties missing from SPFieldLink/Choice field couldn’t be hidden in SharePoint

At some point you might notice that SPFieldLink is missing the two boolean flags known from SPField type: ShowInEditForm and ShowInNewForm. To make it more confusing, the ShowInDisplayFormflag is available and exposed as a public property.

I added this blog so that you can save some time doing research on the same problem.

1.Set private fields values using reflection (No use)

We may try to force setting the values for private fields (that exist in SPFieldLink) with code similar to the following:

At this point, fieldLink.SchemaXml variable will explicitly contain ShowInEditFormattribute in XML. It seems that we’re at home, but… when you create list instance based on this content type, this value will just be ignored. By the way, ShowInDisplayForm that is a public property in SPFieldLink is also ignored.

2. create different fields on the SPWeb.Fields level

This “solution” is to let go SPFieldLink and just create more SPFields with the same display name. Some of them will have the ShowInEditForm property set to true, some to false. Then, when creating content types, just add the field with desired property set. The list using this content type will inherit property values from SPFields.

In result, display, edit and new forms will look as expected for user. Data structure will be less clear however, because some fields that are logically the same, will have multiple instances in SPWeb.Fields collection. It will appear in site columns gallery that there are duplicates of those columns.

3.set the values on a list

Another way to do this, is not to rely on any inherited values for those properties, but set them explicitly in SPList.Fields collection, after the list is created and content types are added to list.

Lists are likely to be created during deployment process, so this could be done in some C# code or in PowerShell after the structure is deployed.

Which is the good solution:)

None of those solutions seems satisfying, and it will not replace the missing SharePoint functionality. If you manage to find a better fix then a please share your fix.

Increase the width of column in SharePoint 2013

Easy and simple method to increase the width of column in SharePoint:

  1. Open the site in SharePoint designer
  2. Go to the SharePoint list, go to List
  3. Click on Edit list in SharePoint designer

3. Go to the view where you want the column’s width to be increased.

4. Move cursor downwards in the code and stop when the List view tools tab gets enabled.(If not please find below Important Note)

5. Go to Design and click on Customize XSLT, there click on customize entire view.

6. You can see that now entire codes will be visible.

7. For example I want to increase the width of column “status”. I find status in the code and stop when I see the following set of code:

<xsl:template name=”FieldRef_header.Description” ddwrt:dvt_mode=”header” match=”FieldRef[@Name=’Description’]” mode=”header” ddwrt:ghost=”hide”>

<th nowrap=”nowrap” scope=”col” onmouseover=”OnChildColumn(this)”>

<xsl:attribute name=”class”>

8. Now, I change the code:

<th nowrap=”nowrap” scope=”col” onmouseover=”OnChildColumn(this)”>

To

<th scope=”col” onmouseover=”OnChildColumn(this)” style =”width: 1350px; white-space:normal;min-width:1350px”>

Important Note:

Sometimes it may happen that List View Tools tab will not be visible,You can follow below instructions to enable it.

Edit the Web Part properties and tick Miscellaneous > Server Render. I know on Tasks view webparts that this disables the Timeline and Complete icon functionality but it

  1. Enables the List View Tools and
  2. Enables valid filtering (with Server Render unticked, the filtering is wrong!).

Hope this helps,

Thanks and Regards,

Virendra

Make a term set available to other site collections in SharePoint

Hi,

Today I got an issue in which I wanted to copy Local term set from one site collection to other.

I found the below article which was helpful for me

When you create term sets in one site collection, by default, they’re not available to other site collections in the tenant. However, you can give site collections access to term sets that you’ve created in other site collections. For example, if you’ve created a catalog tagging term set in an authoring site collection of a cross-site publishing scenario, you can give the publishing site collection access to the tagging term set.

  1. Make sure that you’re a member of the Owners SharePoint group on the site that contains the term set.
  2. From Settings Small Settings gear that took the place of Site Settings. , select Site Settings.
  3. On the Site Settings page, in the Site Administration section, select Term store management.
  4. In the Term Store Management Tool, select the group that contains all term sets within the site collection.
    The group that contains all term sets within the site collection
  5. In the Site Collection Access section, type the URLs of the site collections that you want to give access to the term sets.
  6. Select Save.

Ref:https://support.office.com/en-us/article/Make-a-term-set-available-to-other-site-collections-in-SharePoint-5e1271e2-6e1f-4d22-8a0d-b2648a412ca7?ui=en-US&rs=en-US&ad=US&fromAR=1

Hope this helps,Thanks

Virendra

 

Error loading navigation: The Managed Navigation term set is improperly attached to the site SP2013

Hi,

I got this error when I tried to restore site and content from higher environment(QA) to lower environment(TEST)

Below are the steps I performed

  1. The solution is to switch back to structure navigation in site settings->navigation and switch to managed navigation again. This way, the lost attached web id seems to be written again.
  2. Checked Term Owners which were from QA environment,did not resolved.Corrected them as per the lower environment.(Which resolved the issue in my case)
  3. You can  try removing the MMS for the webapplication via central admin-> services connections and try attaching again after reset. If still issue exists may be you can create another MMS and try attaching to the webapplication and check whether its working or not.. Good luck

Hope it helps you,

Happy learning..

Thanks,

Viru

Before Properties,After Properties and ListItem in Sharepoint 2010/2013 Event Recievers

Event recievers are common in Sharepoint development so its better to understand the data available in each events. Sometimes as a developer we jump into coding before thinking about contextual data availability.One more imprtant thing to notice list event reciever  and document libraray event reciever are different interms of contextual data avaialability.Following Table will give you a clear picture about the contextual data in each events.

Sharepoint List

Event BeforeProperties AfterProperties ListItem
ItemAdding Null New  Value Null
ItemAdded Null New Value New Value
ItemUpdating Null Changed Value Original Value
ItemUpdated Null Changed Value Changed Value
ItemDeleting Null Null Original Value
ItemDeleted Null Null Null

Sharepoint Document Libraray

Event BeforeProperties AfterProperties ListItem
ItemAdding Null Null Null
ItemAdded Null Null New Value
ItemUpdating Original Value Changed Value Original Value
ItemUpdated Original Value Changed Value Changed Value
ItemDeleting Null Null Original Value
ItemDeleted Null Null Null

Hope this Helps,

Thanks,

Virendra

Visual Studio Shortcut keys

Hi,

You can refer below link for all versions of Visual Studio Shortcuts.  http://visualstudioshortcuts.com/2013/

Below mentioned are useful for Visual Studio 2013

Analyze

Navigate Backward
Shift+Alt+3
Navigate Forward
Shift+Alt+4

Architecture

New Diagram
Ctrl+\, Ctrl+N

Architecture Context Menus

Add Node
Ins
Both Dependencies
B
Incoming Dependencies
I
Outgoing Dependencies
O
New Comment
Ctrl+Shift+K
Ctrl+E, C
Remove
Del
Rename
F2

Architecture Designer

Navigate To Code
F12

Build

Build Selection
Shift+F6
Build Solution
Ctrl+Shift+B
F6
Cancel
Ctrl+Break
Compile
Ctrl+F7
Run Code Analysison Solution
Alt+F11

Class Diagram

Collapse
Num –
Expand
Num +

Class View Context Menus

Properties
Alt+Enter
Viewin Page Inspector
Ctrl+K, Ctrl+G

Misc

Commit All Edits
Shift+Alt+U
Move Left Edgetotheleft
Ctrl+Shift+,
Move Left Edgetotheright
Ctrl+Shift+.
Move Right Edgetotheleft
Ctrl+Shift+Alt+,
Move Right Edgetotheright
Ctrl+Shift+Alt+.
TSql Editor Clone Query
Ctrl+Alt+N
TSql Editor Database Combo
Shift+Alt+PgDn
View File In Script Panel
Shift+Alt+PgDn

Debug

Apply Code Changes
Alt+F10
Autos
Ctrl+Alt+V, A
Ctrl+D, A
Ctrl+D, Ctrl+A
Break All
Ctrl+Alt+Break
Breakat Function
Ctrl+B
Ctrl+D, N
Ctrl+D, Ctrl+N
Breakpoints
Ctrl+Alt+B
Ctrl+D, B
Ctrl+D, Ctrl+B
Call Stack
Ctrl+Alt+C
Ctrl+D, C
Ctrl+D, Ctrl+C
Delete All Breakpoints
Ctrl+Shift+F9
Launch
Alt+F2
Disassembly
Ctrl+Alt+D
DOMExplorer
Ctrl+Alt+V, D
Enable Breakpoint
Ctrl+F9
Exceptions
Ctrl+Alt+E
Ctrl+D, E
Ctrl+D, Ctrl+E
Go To Previous Callor Intelli Trace Event
Ctrl+Shift+F11
Capture Frame
Ctrl+F12
Start Diagnostics
Alt+F5
Graphics Move Pixel Selection Down
Shift+Alt+Down Arrow
Graphics Move Pixel Selection Left
Shift+Alt+Left Arrow
Graphics Move Pixel Selection Right
Shift+Alt+Right Arrow
Graphics Move Pixel Selection Up
Shift+Alt+Up Arrow
Graphics Reset Zoom
Shift+Alt+0
Graphics Zoom In
Shift+Alt+=
Graphics Zoom Out
Shift+Alt+-
Immediate
Ctrl+Alt+I
Ctrl+D, I
Ctrl+D, Ctrl+I
Intelli Trace Calls
Ctrl+Alt+Y, T
Intelli Trace Events
Ctrl+Alt+Y, F
Java Script Console
Ctrl+Alt+V, C
Locals
Ctrl+Alt+V, L
Ctrl+D, L
Ctrl+D, Ctrl+L
Process Combo
Ctrl+5
Stack Frame Combo
Ctrl+7
Thread Combo
Ctrl+6
Toggle Current Thread Flagged State
Ctrl+8
Toggle Flagged Threads
Ctrl+9
Memory1
Ctrl+Alt+M, 1
Ctrl+D, Y
Ctrl+D, Ctrl+Y
Memory2
Ctrl+Alt+M, 2
Memory3
Ctrl+Alt+M, 3
Memory4
Ctrl+Alt+M, 4
Modules
Ctrl+Alt+U
Ctrl+D, M
Ctrl+D, Ctrl+M
Parallel Stacks
Ctrl+Shift+D, S
Parallel Watch1
Ctrl+Shift+D, 1
Parallel Watch2
Ctrl+Shift+D, 2
Parallel Watch3
Ctrl+Shift+D, 3
Parallel Watch4
Ctrl+Shift+D, 4
Processes
Ctrl+Alt+Z
Ctrl+D, P
Ctrl+D, Ctrl+P
Quick Watch
Shift+F9
Ctrl+Alt+Q
Ctrl+D, Q
Ctrl+D, Ctrl+Q
Refresh Windowsapp
Ctrl+Shift+R
Registers
Ctrl+Alt+G
Ctrl+D, R
Ctrl+D, Ctrl+R
Restart
Ctrl+Shift+F5
Run To Cursor
Ctrl+F10
Set Next Statement
Ctrl+Shift+F10
Show Call Stackon Code Map
Ctrl+Shift+`
Show Next Statement
Alt+Num *
Start
F5
Start Windows Phone Application Analysis
Alt+F1
Start Without Debugging
Ctrl+F5
Step Into
F11
Step Into Current Process
Ctrl+Alt+F11
Step Into Specific
Shift+Alt+F11
Step Out
Shift+F11
Step Out Current Process
Ctrl+Shift+Alt+F11
Step Over
F10
Step Over Current Process
Ctrl+Alt+F10
Stop Debugging
Shift+F5
Stop Performance Analysis
Shift+Alt+F2
Tasks
Ctrl+Shift+D, K
Ctrl+D, K
Ctrl+D, Ctrl+K
Threads
Ctrl+Alt+H
Ctrl+D, T
Ctrl+D, Ctrl+T
Toggle Breakpoint
F9
Toggle Disassembly
Ctrl+F11
Ctrl+D, D
Ctrl+D, Ctrl+D
Watch1
Ctrl+Alt+W, 1
Ctrl+D, W
Ctrl+D, Ctrl+W
Watch2
Ctrl+Alt+W, 2
Watch3
Ctrl+Alt+W, 3
Watch4
Ctrl+Alt+W, 4

Debugger Context Menus

Delete
Alt+F9, D
Go To Disassembly
Alt+F9, A
Go To Source Code
Alt+F9, S

Design

Fit All
Ctrl+0
Show Handles
F9
Zoom In
Ctrl+Alt+=
Zoom Out
Ctrl+Alt+-

Diagnostics Hub

Stop Collection
Ctrl+Alt+F2

Diff

Ignore Trim Whitespace
Ctrl+\, Ctrl+Space
Inline View
Ctrl+\, Ctrl+1
Left Only View
Ctrl+\, Ctrl+3
Next Difference
F8
Previous Difference
Shift+F8
Right Only View
Ctrl+\, Ctrl+4
Side By Side View
Ctrl+\, Ctrl+2
Switch Between Left And Right
Ctrl+\, Ctrl+Tab
Synchronize View Toggle
Ctrl+\, Ctrl+Down Arrow

DOMExplorer

Refresh
F5
Select Element
Ctrl+B
Show Layout
Ctrl+Shift+I

Edit

Break Line
Enter
Shift+Enter
Char Left
Left Arrow
Char Left Extend
Shift+Left Arrow
Char Left Extend Column
Shift+Alt+Left Arrow
Char Right
Right Arrow
Char Right Extend
Shift+Right Arrow
Char Right Extend Column
Shift+Alt+Right Arrow
Char Transpose
Ctrl+T
Clear Bookmarks
Ctrl+B, C
Ctrl+B, Ctrl+C
Collapse All Outlining
Ctrl+M, Ctrl+A
Collapse Current Region
Ctrl+M, Ctrl+S
Collapse Tag
Ctrl+M, Ctrl+T
Collapseto Definitions
Ctrl+M, Ctrl+O
Ctrl+M, O
Comment Selection
Ctrl+K, Ctrl+C
Ctrl+E, C
Ctrl+E, Ctrl+C
Complete Word
Ctrl+Space
Alt+Right Arrow
Ctrl+K, W
Ctrl+K, Ctrl+W
Copy
Ctrl+C
Ctrl+Ins
Copy Parameter Tip
Ctrl+Shift+Alt+C
Create Copyof Work Item
Shift+Alt+C
Cut
Ctrl+X
Shift+Del
Cycle Clipboard Ring
Ctrl+Shift+V
Ctrl+Shift+Ins
Decrease Filter Level
Alt+,
Delete
Del
Ctrl+Del
Shift+Del
Delete Backwards
Bkspce
Shift+Bkspce
Delete From Model
Shift+Del
Delete Horizontal White Space
Ctrl+K, Ctrl+\
Ctrl+E, \
Ctrl+E, Ctrl+\
Document End
Ctrl+End
End
Document End Extend
Ctrl+Shift+End
Shift+End
Document Start
Ctrl+Home
Home
Document Start Extend
Ctrl+Shift+Home
Shift+Home
Edit Cell
F2
Enable Bookmark
Ctrl+B, E
Ctrl+B, Ctrl+E
Expand All Outlining
Ctrl+M, Ctrl+X
Expand Collapse Base Type List
Shift+Alt+B
Expand Current Region
Ctrl+M, Ctrl+E
Find
Ctrl+F
Find All References
Ctrl+K, R
Ctrl+K, Ctrl+R
Shift+F12
Findin Files
Ctrl+Shift+F
Find Next
F3
Find Next Selected
Ctrl+F3
Find Previous
Shift+F3
Find Previous Selected
Ctrl+Shift+F3
Format Document
Ctrl+K, Ctrl+D
Ctrl+E, D
Ctrl+E, Ctrl+D
Format Selection
Ctrl+K, Ctrl+F
Ctrl+E, F
Ctrl+E, Ctrl+F
Generate Method
Ctrl+K, M
Ctrl+K, Ctrl+M
Go To
Ctrl+G
Goto Brace
Ctrl+]
Goto Brace Extend
Ctrl+Shift+]
Go To Declaration
Ctrl+F12
Go To Definition
F12
Go To Find Combo
Ctrl+/
Go To Next Location
F8
Go To Prev Location
Shift+F8
Hide Selection
Ctrl+M, Ctrl+H
Increase Filter Level
Alt+.
Incremental Search
Ctrl+I
Indent
Shift+Alt+Right Arrow
Insert Snippet
Ctrl+K, Ctrl+X
Ctrl+K, X
Insert Tab
Tab
Line Cut
Ctrl+L
Line Delete
Ctrl+Shift+L
Line Down
Down Arrow
Line Down Extend
Shift+Down Arrow
Shift+Up Arrow
Line Down Extend Column
Shift+Alt+Down Arrow
Line End
End
Line End Extend
Shift+End
Line End Extend Column
Shift+Alt+End
Line Open Above
Ctrl+Enter
Line Open Below
Ctrl+Shift+Enter
Line Start
Home
Line Start Extend
Shift+Home
Line Start Extend Column
Shift+Alt+Home
Line Transpose
Shift+Alt+T
Line Up
Up Arrow
Line Up Extend
Shift+Up Arrow
Shift+Down Arrow
Line Up Extend Column
Shift+Alt+Up Arrow
List Members
Ctrl+J
Ctrl+K, L
Ctrl+K, Ctrl+L
Make Lowercase
Ctrl+U
Make Uppercase
Ctrl+Shift+U
Move Control Down
Ctrl+Down Arrow
Down Arrow
Move Control Down Grid
Down Arrow
Move Control Left
Ctrl+Left Arrow
Left Arrow
Move Control Left Grid
Left Arrow
Move Control Right
Ctrl+Right Arrow
Right Arrow
Move Control Right Grid
Right Arrow
Move Control Up
Ctrl+Up Arrow
Up Arrow
Move Control Up Grid
Up Arrow
Move Selected Lines Down
Alt+Down Arrow
Move Selected Lines Up
Alt+Up Arrow
Navigate To
Ctrl+,
Navigate To Lollipop
Shift+Alt+L
New Accelerator
Ins
New String
Ins
Next Bookmark
Ctrl+K, Ctrl+N
Ctrl+B, N
Ctrl+B, Ctrl+N
Next Highlighted Reference
Ctrl+Shift+Down Arrow
Next Key Typed
Ctrl+W
Open File
Ctrl+Shift+G
Outdent
Shift+Alt+Left Arrow
Overtype Mode
Ins
Page Down
PgDn
Page Down Extend
Shift+PgDn
Page Up
PgUp
Page Up Extend
Shift+PgUp
Parameter Info
Ctrl+Shift+Space
Ctrl+K, P
Ctrl+K, Ctrl+P
Paste
Ctrl+V
Shift+Ins
Paste Parameter Tip
Ctrl+Shift+Alt+P
Peek Backward
Ctrl+Alt+-
Peek Definition
Alt+F12
Peek Forward
Ctrl+Alt+=
Previous Bookmark
Ctrl+K, Ctrl+P
Ctrl+B, P
Ctrl+B, Ctrl+P
Previous Highlighted Reference
Ctrl+Shift+Up Arrow
Quick Find Symbol
Shift+Alt+F12
Quick Info
Ctrl+K, Ctrl+I
Ctrl+K, I
Redo
Ctrl+Y
Ctrl+Shift+Z
Shift+Alt+Bkspce
Refresh Remote References
Ctrl+Shift+J
Refresh Work Item
F5
Remove
Del
Removefrom Diagram
Del
Remove Row
Ctrl+Del
Replace
Ctrl+H
Replacein Files
Ctrl+Shift+H
Reverse Incremental Search
Ctrl+Shift+I
Scroll Column Left
Ctrl+Left Arrow
Scroll Column Right
Ctrl+Right Arrow
Scroll Line Down
Ctrl+Down Arrow
Scroll Line Up
Ctrl+Up Arrow
Select All
Ctrl+A
Select Current Word
Ctrl+Shift+W
Selection Cancel
Esc
Select Next Control
Tab
Select Previous Control
Shift+Tab
Select To Last Go Back
Ctrl+=
Show Code Lens Menu
Alt+`
Show Tile Grid
Enter
Size Control Down
Ctrl+Shift+Down Arrow
Shift+Down Arrow
Size Control Down Grid
Shift+Down Arrow
Size Control Left
Ctrl+Shift+Left Arrow
Shift+Left Arrow
Size Control Left Grid
Shift+Left Arrow
Size Control Right
Ctrl+Shift+Right Arrow
Shift+Right Arrow
Size Control Right Grid
Shift+Right Arrow
Size Control Up
Ctrl+Shift+Up Arrow
Shift+Up Arrow
Size Control Up Grid
Shift+Up Arrow
Stop Hiding Current
Ctrl+M, Ctrl+U
Stop Outlining
Ctrl+M, Ctrl+P
Ctrl+M, P
Stop Search
Alt+F3, S
Surround With
Ctrl+K, Ctrl+S
Ctrl+K, S
Swap Anchor
Ctrl+K, Ctrl+A
Ctrl+E, A
Ctrl+E, Ctrl+A
Tab Left
Shift+Tab
Toggle All Outlining
Ctrl+M, Ctrl+L
Ctrl+M, L
Toggle Bookmark
Ctrl+K, Ctrl+K
Ctrl+B, T
Ctrl+B, Ctrl+T
Toggle Completion Mode
Ctrl+Alt+Space
Toggle Outlining Expansion
Ctrl+M, Ctrl+M
Ctrl+M, M
Toggle Task List Shortcut
Ctrl+K, Ctrl+H
Ctrl+E, T
Ctrl+E, Ctrl+T
Toggle Word Wrap
Ctrl+E, Ctrl+W
Ctrl+E, W
Uncomment Selection
Ctrl+K, Ctrl+U
Ctrl+E, U
Ctrl+E, Ctrl+U
Undo
Ctrl+Z
Alt+Bkspce
View Bottom
Ctrl+PgDn
View Bottom Extend
Ctrl+Shift+PgDn
View Top
Ctrl+PgUp
View Top Extend
Ctrl+Shift+PgUp
View White Space
Ctrl+R, Ctrl+W
Ctrl+E, S
Ctrl+E, Ctrl+S
Word Delete To End
Ctrl+Del
Word Delete To Start
Ctrl+Bkspce
Word Next
Ctrl+Right Arrow
Word Next Extend
Ctrl+Shift+Right Arrow
Word Next Extend Column
Ctrl+Shift+Alt+Right Arrow
Word Previous
Ctrl+Left Arrow
Word Previous Extend
Ctrl+Shift+Left Arrow
Word Previous Extend Column
Ctrl+Shift+Alt+Left Arrow
Word Transpose
Ctrl+Shift+T

Editor Context Menus

Add Comment
Ctrl+Shift+K
Breakpoint Editlabels
Alt+F9, L
Show Item
Ctrl+`
Edit Local File
Ctrl+Shift+P
Execute
Ctrl+Alt+F5
Execute In Interactive
Alt+Enter
Execute Line In Interactive
Alt+’
Go To View
Ctrl+M, Ctrl+G
Toggle Header Code File
Ctrl+K, Ctrl+O
View Call Hierarchy
Ctrl+K, Ctrl+T
Ctrl+K, T

File

Exit
Alt+F4
New File
Ctrl+N
New Project
Ctrl+Shift+N
New Web Site
Shift+Alt+N
Open File
Ctrl+O
Open Project
Ctrl+Shift+O
Open Web Site
Shift+Alt+O
Print
Ctrl+P
Rename
F2
Save All
Ctrl+Shift+S
Save Selected Items
Ctrl+S

Format

Align Bottoms
Ctrl+Shift+Down Arrow
Align Centers
Shift+F9
Align Lefts
Ctrl+Shift+Left Arrow
Align Middles
F9
Align Rights
Ctrl+Shift+Right Arrow
Align Tops
Ctrl+Shift+Up Arrow
Bold
Ctrl+B
Button Bottom
Ctrl+B
Button Right
Ctrl+R
Center Horizontal
Ctrl+Shift+F9
Center Vertical
Ctrl+F9
Check Mnemonics
Ctrl+M
Convertto Hyperlink
Ctrl+L
Edit Text
F2
Insert Bookmark
Ctrl+Shift+L
Italic
Ctrl+I
Reset All
Ctrl+Shift+R
Sizeto Content
Shift+F7
Space Across
Alt+Right Arrow
Alt+Left Arrow
Space Down
Alt+Up Arrow
Alt+Down Arrow
Tab Order
Ctrl+D
Test Dialog
Ctrl+T
Toggle Guides
Ctrl+G
Underline
Ctrl+U

Graph View

Bottomto Top
Alt+Up Arrow
Leftto Right
Alt+Right Arrow
Rightto Left
Alt+Left Arrow
Topto Bottom
Alt+Down Arrow

Help

Addand Remove Help Content
Ctrl+Alt+F1
Ctrl+F1, M
Ctrl+F1, Ctrl+M
F1 Help
F1
View Help
Ctrl+F1, V
Ctrl+F1, Ctrl+V
Window Help
Shift+F1

Image

Airbrush Tool
Ctrl+A
Brush Tool
Ctrl+B
Copyand Outline Selection
Ctrl+Shift+U
Draw Opaque
Ctrl+J
Ellipse Tool
Alt+P
Erase Tool
Ctrl+Shift+I
Filled Ellipse Tool
Ctrl+Shift+Alt+P
Filled Rectangle Tool
Ctrl+Shift+Alt+R
Filled Rounded Rectangle Tool
Ctrl+Shift+Alt+W
Fill Tool
Ctrl+F
Flip Horizontal
Ctrl+H
Flip Vertical
Shift+Alt+H
Larger Brush
Ctrl+=
Line Tool
Ctrl+L
Magnification Tool
Ctrl+M
Magnify
Ctrl+Shift+M
New Image Type
Ins
Next Color
Ctrl+]
Ctrl+Right Arrow
Next Right Color
Ctrl+Shift+]
Ctrl+Shift+Right Arrow
Outlined Ellipse Tool
Shift+Alt+P
Outlined Rectangle Tool
Shift+Alt+R
Outlined Rounded Rectangle Tool
Shift+Alt+W
Pencil Tool
Ctrl+I
Previous Color
Ctrl+[
Ctrl+Left Arrow
Previous Right Color
Ctrl+Shift+[
Ctrl+Shift+Left Arrow
Rectangle Selection Tool
Shift+Alt+S
Rectangle Tool
Alt+R
Rotate90 Degrees
Ctrl+Shift+H
Rounded Rectangle Tool
Alt+W
Show Grid
Ctrl+Alt+S
Show Tile Grid
Ctrl+Shift+Alt+S
Small Brush
Ctrl+.
Smaller Brush
Ctrl+-
Text Tool
Ctrl+T
Use Selectionas Brush
Ctrl+U
Zoom In
Ctrl+Shift+.
Ctrl+Up Arrow
Zoom Out
Ctrl+Shift+,
Ctrl+Down Arrow

Load Test

Jump To Counter Pane
Ctrl+R, Q

Other Context Menus

Insert Column
Ins
Column
Ctrl+L
Cancel Interactive Evaluation
Ctrl+Break
Removefrom Workspace
Del
Go To Controller
Ctrl+M, Ctrl+G
Viewin Page Inspector
Ctrl+K, Ctrl+G
Add New Diagram
Ins
Down
Alt+Down Arrow
Down5
Alt+PgDn
To Bottom
Alt+End
To Top
Alt+Home
Up
Alt+Up Arrow
Up5
Alt+PgUp
Rename
Ctrl+R, R
Removefrom Diagram
Shift+Del
Hide Methods Pane
Ctrl+1
Copy Referenceto Clipboard
Ctrl+C
Insert Delay Before
Ctrl+Alt+D
Locate All
Shift+Alt+L
Locatethe UIControl
Ctrl+Shift+L
Movecode
Ctrl+Alt+C
Splitintoanewmethod
Ctrl+Shift+T

Page Inspector

Minimize
F12

Project

Add Class
Shift+Alt+C
Add Content Page
Ctrl+M, Ctrl+C
Add Existing Item
Shift+Alt+A
Add New Item
Ctrl+Shift+A
Class Wizard
Ctrl+Shift+X
Override
Ctrl+Alt+Ins
Previewchanges
Alt+;, Alt+C
Publishselectedfiles
Alt+;, Alt+P
Replaceselectedfilesfromserver
Alt+;, Alt+R

Projectand Solution Context Menus

Move Down
Alt+Down Arrow
Move Up
Alt+Up Arrow

Query Designer

Cancel Retrieving Data
Ctrl+T
Criteria
Ctrl+2
Diagram
Ctrl+1
Execute SQL
Ctrl+R
Goto Row
Ctrl+G
Join Mode
Ctrl+Shift+J
Results
Ctrl+4
SQL
Ctrl+3

Refactor

Encapsulate Field
Ctrl+R, Ctrl+E
Ctrl+R, E
Extract Interface
Ctrl+R, Ctrl+I
Ctrl+R, I
Extract Method
Ctrl+R, Ctrl+M
Ctrl+R, M
Remove Parameters
Ctrl+R, Ctrl+V
Ctrl+R, V
Rename
Ctrl+R, Ctrl+R
Ctrl+R, R
F2
Reorder Parameters
Ctrl+R, Ctrl+O
Ctrl+R, O

Resources

Audio
Ctrl+4
Files
Ctrl+5
Icons
Ctrl+3
Images
Ctrl+2
Other
Ctrl+6
Strings
Ctrl+1

Solution Explorer

Open Files Filter
Ctrl+[, O
Ctrl+[, Ctrl+O
Pending Changes Filter
Ctrl+[, P
Ctrl+[, Ctrl+P
Sync With Active Document
Ctrl+[, S
Ctrl+[, Ctrl+S

SQL

Execute With Debugger
Alt+F5
Expand Wildcards
Ctrl+R, E
Ctrl+R, Ctrl+E
Fullyqualify Names
Ctrl+R, Q
Ctrl+R, Ctrl+Q
Moveto Schema
Ctrl+R, M
Ctrl+R, Ctrl+M
Query Results New Row
Alt+End
Query Results Refresh
Shift+Alt+R
Query Results Stop
Alt+Break
Rename
Ctrl+R, R
F2
Ctrl+R, Ctrl+R
SSDTSchema Compare Compare
Shift+Alt+C
SSDTSchema Compare Generate Script
Shift+Alt+G
SSDTSchema Compare Next Change
Shift+Alt+.
SSDTSchema Compare Previous Change
Shift+Alt+,
SSDTSchema Compare Stop
Alt+Break
SSDTSchema Compare Write Updates
Shift+Alt+U
TSql Editor Cancel Query
Alt+Break
TSql Editor Execute Query
Ctrl+Shift+E
TSql Editor Results As File
Ctrl+D, F
TSql Editor Results As Grid
Ctrl+D, G
TSql Editor Results As Text
Ctrl+D, T
TSql Editor Show Estimated Plan
Ctrl+D, E
TSql Editor Toggle Execution Plan
Ctrl+D, A
TSql Editor Toggle Results Pane
Ctrl+D, R

Table

Columntothe Left
Ctrl+Alt+Left Arrow
Columntothe Right
Ctrl+Alt+Right Arrow
Row Above
Ctrl+Alt+Up Arrow
Row Below
Ctrl+Alt+Down Arrow

Team

Go To Git Branches
Ctrl+0, Ctrl+N
Ctrl+0, N
Go To Git Changes
Ctrl+0, Ctrl+G
Ctrl+0, G
Go To Git Commits
Ctrl+0, Ctrl+O
Ctrl+0, O
Goto Next Work Item
Shift+Alt+N
Goto Previous Work Item
Shift+Alt+P
New Linked Work Item
Shift+Alt+L
Refresh
F5
Team Explorer Search
Ctrl+’

Team Foundation Context Menus

Tfs Annotate Move Next Region
Alt+PgDn
Tfs Annotate Move Previous Region
Alt+PgUp
Go To Builds
Ctrl+0, Ctrl+B
Ctrl+0, B
Go To Connect
Ctrl+0, Ctrl+C
Ctrl+0, C
Go To Documents
Ctrl+0, Ctrl+D
Ctrl+0, D
Go To Home
Ctrl+0, Ctrl+H
Ctrl+0, H
Go To My Work
Ctrl+0, Ctrl+M
Ctrl+0, M
Go To Pending Changes
Ctrl+0, Ctrl+P
Ctrl+0, P
Go To Reports
Ctrl+0, Ctrl+R
Ctrl+0, R
Go To Settings
Ctrl+0, Ctrl+S
Ctrl+0, S
Go To Team Explorer Navigation
Alt+Home
Go To Team Explorer Next Section Content
Alt+Down Arrow
Go To Team Explorer Page Content
Alt+0
Go To Team Explorer Previous Section Content
Alt+Up Arrow
Go To Team Explorer Section1 Content
Alt+1
Go To Team Explorer Section2 Content
Alt+2
Go To Team Explorer Section3 Content
Alt+3
Go To Team Explorer Section4 Content
Alt+4
Go To Team Explorer Section5 Content
Alt+5
Go To Team Explorer Section6 Content
Alt+6
Go To Team Explorer Section7 Content
Alt+7
Go To Team Explorer Section8 Content
Alt+8
Go To Team Explorer Section9 Content
Alt+9
Go To Web Access
Ctrl+0, Ctrl+A
Ctrl+0, A
Go To Work Items
Ctrl+0, Ctrl+W
Ctrl+0, W
Team Explorer Navigate Backward
Alt+Left Arrow
Team Explorer Navigate Forward
Alt+Right Arrow
Set Focuson Left Window
Alt+1
Set Focuson Result Window
Alt+2
Set Focuson Right Window
Alt+3
Tfs Context My Work Page Create Copy WI
Shift+Alt+C
Tfs Context My Work Page New Linked WI
Shift+Alt+L

Test

Use Coded UITest Builder
Ctrl+\, Ctrl+C
Use Existing Action Recording
Ctrl+\, Ctrl+A

Test Explorer

Debug All Tests
Ctrl+R, Ctrl+A
Debug All Tests In Context
Ctrl+R, Ctrl+T
Open Test
F12
Repeat Last Run
Ctrl+R, L
Run All Tests
Ctrl+R, A
Run All Tests In Context
Ctrl+R, T

Tools

Attachto Process
Ctrl+Alt+P
Code Snippets Manager
Ctrl+K, Ctrl+B
Force GC
Ctrl+Shift+Alt+F12, Ctrl+Shift+Alt+F12

View

All Windows
Shift+Alt+M
Architecture Explorer
Ctrl+\, Ctrl+R
NETNonvisual Controls
Ctrl+Shift+N
Backward
Alt+Left Arrow
Bookmark Window
Ctrl+K, Ctrl+W
Ctrl+W, B
Ctrl+W, Ctrl+B
Browse Next
Ctrl+Shift+1
Browse Previous
Ctrl+Shift+2
Call Hierarchy
Ctrl+W, K
Ctrl+W, Ctrl+K
Class View
Ctrl+Shift+C
Ctrl+W, C
Ctrl+W, Ctrl+C
Class View Go To Search Combo
Ctrl+K, Ctrl+V
Code Definition Window
Ctrl+\, D
Ctrl+\, Ctrl+D
Ctrl+W, D
Ctrl+W, Ctrl+D
Command Window
Ctrl+Alt+A
Ctrl+W, A
Ctrl+W, Ctrl+A
Data Sources
Shift+Alt+D
Document Outline
Ctrl+Alt+T
Ctrl+W, U
Ctrl+W, Ctrl+U
Edit Label
F2
Edit Master
Ctrl+M, Ctrl+M
Entity Data Model Browser
Ctrl+1
Entity Data Model Mapping Details
Ctrl+2
Error List
Ctrl+\, E
Ctrl+\, Ctrl+E
Ctrl+W, E
Ctrl+W, Ctrl+E
F# Interactive
Ctrl+Alt+F
Find Symbol Results
Ctrl+Alt+F12
Ctrl+W, Q
Ctrl+W, Ctrl+Q
Forward
Alt+Right Arrow
Forward Browse Context
Ctrl+Shift+7
Full Screen
Shift+Alt+Enter
Navigate Backward
Ctrl+-
Navigate Forward
Ctrl+Shift+-
Next Error
Ctrl+Shift+F12
Next View
Ctrl+PgDn
Notifications
Ctrl+W, N
Ctrl+W, Ctrl+N
Object Browser
Ctrl+Alt+J
Ctrl+W, J
Ctrl+W, Ctrl+J
Output
Ctrl+Alt+O
Ctrl+W, O
Ctrl+W, Ctrl+O
Pending Checkins
Ctrl+W, G
Ctrl+W, Ctrl+G
Pop Browse Context
Ctrl+Shift+8
Properties Window
F4
Ctrl+W, P
Ctrl+W, Ctrl+P
Property Pages
Shift+F4
Refresh
F5
Report Data
Ctrl+Alt+D
Resource View
Ctrl+Shift+E
Ctrl+W, R
Ctrl+W, Ctrl+R
Server Explorer
Ctrl+Alt+S
Ctrl+W, L
Ctrl+W, Ctrl+L
Show Smart Tag
Shift+Alt+F10
Ctrl+.
Solution Explorer
Ctrl+Alt+L
Ctrl+W, S
Ctrl+W, Ctrl+S
SQLServer Object Explorer
Ctrl+\, Ctrl+S
Synchronize Views
Ctrl+Shift+Y
Task List
Ctrl+\, T
Ctrl+\, Ctrl+T
Ctrl+W, T
Ctrl+W, Ctrl+T
Tfs Team Explorer
Ctrl+\, Ctrl+M
Toolbox
Ctrl+Alt+X
Ctrl+W, X
Ctrl+W, Ctrl+X
UMLModel Explorer
Ctrl+\, Ctrl+U
View Code
Enter
F7
View Designer
Shift+F7
View Markup
Shift+F7
Web Browser
Ctrl+Alt+R
Ctrl+W, W
Ctrl+W, Ctrl+W
Zoom In
Ctrl+Shift+.
Zoom Out
Ctrl+Shift+,

Window

Activate Document Window
Esc
Activate Quick Launch
Ctrl+Q
Activate Quick Launch Previous Category
Ctrl+Shift+Q
Activate Solution Explorer Search
Ctrl+;
Activate Window Search
Alt+`
Add Tabto Selection
Ctrl+Shift+Alt+Space
Close Document Window
Ctrl+F4
Close Tool Window
Shift+Esc
Keep Tab Open
Ctrl+Alt+Home
Moveto Navigation Bar
Ctrl+F2
Next Document Window
Ctrl+F6
Next Document Window Nav
Ctrl+Tab
Next Pane
Alt+F6
Next Tab
Ctrl+Alt+PgDn
Ctrl+PgDn
Next Taband Addto Selection
Ctrl+Shift+Alt+PgDn
Next Tool Window Nav
Alt+F7
Previous Document Window
Ctrl+Shift+F6
Previous Document Window Nav
Ctrl+Shift+Tab
Previous Pane
Shift+Alt+F6
Previous Tab
Ctrl+Alt+PgUp
Ctrl+PgUp
Previous Taband Addto Selection
Ctrl+Shift+Alt+PgUp
Previous Tool Window Nav
Shift+Alt+F7
Show Dock Menu
Alt+-
Show Ez MDIFile List
Ctrl+Alt+Down Arrow
Toggle
Shift+Alt+V

Windows Azure

Retry Mobile Service Script Operation
Ctrl+Num *, Ctrl+R
Show Mobile Service Script Error Details
Ctrl+Num *, Ctrl+D

Workflow Designer

Collapse
Ctrl+E, Ctrl+C
Ctrl+E, C
Collapse All
Ctrl+E, Ctrl+Y
Ctrl+E, Y
Connect Nodes
Ctrl+E, Ctrl+F
Ctrl+E, F
Create Variable
Ctrl+E, Ctrl+N
Ctrl+E, N
Expand All
Ctrl+E, Ctrl+X
Ctrl+E, X
Expand In Place
Ctrl+E, Ctrl+E
Ctrl+E, E
Go To Parent
Ctrl+E, Ctrl+P
Ctrl+E, P
Move Focus
Ctrl+E, Ctrl+M
Ctrl+E, M
Navigate Through Designer
Ctrl+Alt+F6
Restore
Ctrl+E, Ctrl+R
Ctrl+E, R
Show Hide Argument Designer
Ctrl+E, Ctrl+A
Ctrl+E, A
Show Hide Imports Designer
Ctrl+E, Ctrl+I
Ctrl+E, I
Show Hide Overview Map
Ctrl+E, Ctrl+O
Ctrl+E, O
Show Hide Variable Designer
Ctrl+E, Ctrl+V
Ctrl+E, V
Toggle Selection
Ctrl+E, Ctrl+S
Ctrl+E, S
Zoom In
Ctrl+Num +
Zoom Out
Ctrl+Num –

XML

Start XSLTDebugging
Alt+F5
Start XSLTWithout Debugging
Ctrl+Alt+F5

Xsd Designer

Show Content Model View
Ctrl+2
Show Graph View
Ctrl+3
Show Start View
Ctrl+1

Happy learning,

Virendra

Options that are not supported for Send e-mail in a workflow

The following options are not supported by the current version of the Send an Email action:

  • Specifying an address on the From line. (E-mail messages sent by the workflow always show the e-mail address specified by the server administrator on the From line. Only the server administrator can change this, and it can only be changed for all notifications in the current Web application, not per workflow.)
  • Including a hyperlink to the Workflow Status page. (There is no way to use a workflow lookup to supply the value of the WorkflowInstanceID variable in the query string.)
  • Using an embedded cascading style sheet (CSS) to format message content. (Text can be formatted by using the styleattribute, but the <style> tag and CSS classes are not supported.)
  • Using a workflow lookup in either the To or CC box that references a column of the Person or Group type that contains multiple values.
  • Specifying a Bcc (blind carbon copy) recipient for a message. (A developer can modify the .ACTIONS file on the server to include a Bcc field, but this cannot be done in the Workflow Designer.)
  • Including another file with a message as an attachment.
  • Embedding image or graphic files in a message.

Ref:https://support.office.com/en-us/article/Send-e-mail-in-a-workflow-11d5f9dd-955f-412c-b70f-cde4214204f4?ui=en-US&rs=en-US&ad=US&fromAR=1#bm9

Hope this helps,

Thanks,

Virendra

PowerShell to get Owners, Full Control Users and Site Collection Administrators

Hi,

Get all users who are members of the “Owners” groups.

Get-SPSite -Limit All | 
  Get-SPWeb -Limit All | 
  where { $_.HasUniquePerm -and $_.AssociatedOwnerGroup -ne $null } | 
  foreach { $TTNweburl = $_.Url; $_ } | 
  Select -ExpandProperty AssociatedOwnerGroup | 
  Select -ExpandProperty Users | 
  Select {$TTNweburl}, UserLogin, DisplayName

 

Get all users directly given Full Control

Get-SPSite -Limit All | 
  Get-SPWeb -Limit All | 
  Where { $_.HasUniquePerm } | 
  foreach { $TTNweb = $_; $_ } | 
  Select -ExpandProperty Users | 
  Where { $TTNweb.DoesUserHavePermissions($_,[Microsoft.SharePoint.SPBasePermissions]::FullMask) } | 
  Select {$TTNweb.Url}, UserLogin, DisplayName

You could also find users with Full Control like roles by testing for “ManageWeb” or “ManagePermissions”. For a list of the permission types use:

[System.Enum]::GetNames("Microsoft.SharePoint.SPBasePermissions")

 

Get all users who are Site Collection Administrators:

Get-SPSite -Limit All | 
  Get-SPWeb -Limit All | 
  where { $_.HasUniquePerm } | 
  foreach { $TTNweburl = $_.Url; $_ } | 
  Select -ExpandProperty Users | 
  Where { $_.IsSiteAdmin } | 
  Select {$TTNweburl}, UserLogin, DisplayName

 

Who else can see the content, and might have Full Control?

Some users may have access to site content via Web Application level policies. These are set in Central Administration in the Web Application Management section.

Get-SPWebApplication | 
  foreach { $TTNwebappUrl = $_.Url; $_ } | 
  Select -ExpandProperty Policies |  
  Select {$TTNwebappUrl}, DisplayName, IsSystemUser, PolicyRoleBindings, UserName | FT

 

Also you can export the data in “txt” Or “csv” file.

For TEXT : Pipeline below cmdlet

| Out-File -FilePath "C:\Users\YourUserName\Documents\spSites.txt"

For CSV: Pipeline below cmdlet

| Export-CSV  “C:\File.csv”

 

Hope this helps,

Happy Learning …

Vira

 

How to hide a column from new item but not edit item?

Hi,

There are many ways you can achieve it 🙂

Complicated  methods:

  1. You can set these values using the object model (likely Powershell, since this is a one off run). The properties of the SPField object are the same (ShowInNewForm / ShowInEditForm).
  2. With the Sharepoint WebServices it’s possible to hide a field into the NewForm, the Editform and/or the DispForm. You’ll need to use JavaScript with jQuery and SPServices. It’s the UpdateList servicethat will do the trick.
  3. You can also apply jquery to hide the column.

    i.e. $(“input[title=’Title’]”).closest(‘tr’).hide();

    you have to add content editor web part in newform.aspx of list to apply jquery.

Simplest methods:

  1. Just make a custom NewForm.aspx in SharePoint designer, edit it, and delete that field. If you get an error for deleting some mandatory field. Just do inline css style=”display:none” to hide the field, though do make sure it is getting a default value. Then set that newform as the default.
  2. To turn off column in the form: Enable Content Types for the list: go into List Settings, advanced settings, yes to content types, click OK Make the column that you don’t want to see in the form have the content type “hidden”: in List Settings click on Item in the Content Types section. Click on the column you want to hide. For Column Settings select This column is Hidden (will not appear in forms)

Hope this helps..

Thanks,

ViRa

SharePoint Designer 2013 Workflow encoded absolute url of Current Item is incorrect in Email

Hi,

If you attempt to use this process for SharePoint 2013 style workflows (based on Workflow Manager and not the out of the box SharePoint 2010 workflow engine) you will notice that the URL generated is incorrect (ex. “Lists/MyList/1_.00”).

 

I think you should use [%Workflow Context:Current Item URL%] instead of [%Current Item:Encoded Absolute URL%]. You shoud set your Workflow as below:

Data Source:Workflow Context

Field From source:Current Item URL

Return field as:As String

Or  the BEST method which worked for me

In order to get a working link we will have to add “/../DispForm.aspx?ID=” behind the just inserted parameter

Click the “Add Lookup to Body” button again

For the drop down list “Source” select “Current Item”

For the drop downlist “Field” select “ID”

Click “OK”

Now the link in the email body is complete and will look like:
[%Tasks:Encoded Absolute URL%]/../DispForm.aspx?ID=[%Tasks:ID%]

Or

You can use the below link for detail information about how to

Send e-mail in a workflow

https://support.office.com/en-us/article/Send-e-mail-in-a-workflow-11d5f9dd-955f-412c-b70f-cde4214204f4?ui=en-US&rs=en-US&ad=US&fromAR=1

 

Hope this article will help you..

Thanks for reading,

Virendra