Grid Tokens

Tokens on computed fields

Bellow is a list with tokens which can be used in computed fields on grid:

1. [FieldName=defaultValue] => when used in a computed field, this token will display the defaultValue set in the token.

2. [FieldName=[UserID]] => the UserID values are displayed in the grid field 

3. [LastName=[UserID]] => the grid should display the value from profile Last Name field, if Last Name is empty, then the value after Last Name should be displayed, meaning the UserId.

4. [LastName=[Querystring:tabid]] => the grid displays the value from profile Last Name field, if Last Name is empty, then the value after Last Name should be displayed, meaning the Querystring:tabid.

5. [FieldName] => the grid should bring empty value

6. set as data source SQL Query with:
select * from Users WHERE UserId = '[QueryString:_id=-1]'
=> the values in grid will not be displayed until the following query string is added in the url: site.com/page.aspx?_id=1

7. add the token as condition on an action set on a grid item button: '[QueryString:_id=-1]'
set send email as action
add the same token in the subject and in the body of the email
=> the action will be executed only when the url of the grid page is accessed with site.com/page.aspx?_id=1 and in the sent email, the token should displayed its value (1)

8. to execute the action for any user id, the condition should be [QueryString:_id] > 1
=> access the url with param ?_id=2 and the button action should be executed

9. to display the values from the grid for users with id greater that 1, the statement should be:
select * from Users where '[QueryString:_id]' >= 1
=> access the url with param ?_id=1


Comments