In this post, we will try to retrieve the query string parameter value from the url using the SharePoint calculated column. In the below formula I'm trying to read the value of the query string "DefaultView". So when using the formula, I have used "11" as index which is the length of "DefaultView", that needs to changed as per your parameter's length.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| =LEFT(RIGHT([URLCOLUMN],LEN([URLCOLUMN])-INT(FIND("DefaultView=",[URLCOLUMN])+11)),INT(FIND("&",RIGHT([URLCOLUMN],LEN([URLCOLUMN])-INT(FIND("DefaultView=",[URLCOLUMN])+11))))-1) |
Comments
Post a Comment