Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
10 subscribers
Views
2328 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
I have a record that contains a grid field. Within this grid I have two columns
helmuta
over 9 years ago
I have a record that contains a grid field. Within this grid I have two columns that contain information that I want to format. The first field is a user field that currently displays the userid. I would like to format that into a field that contains first name last name. I have a function that does the look up for me but I don't know how to apply it to the field. Here is the layout:
a!gridTextColumn(
label: "Owner",
field:"owner",
data: index(local!data,"owner",{}),
alignment: "CENTER"
),
function that I want to use is COMMON_formatUserFirstLastName that takes an input of type user.
The second column contains a deciaml value that I want to display as a formatted dollar amount. Here is the definition:
a!gridTextColumn(
label: "Price",
field: "dollars",
data: index(loca...
OriginalPostID-139815
OriginalPostID-139815
Discussion posts and replies are publicly visible
Parents
0
jackm829
A Score Level 3
over 9 years ago
dollar() is multiple safe, meaning that you can pass in a list and dollar({a,b}) = {dollar(a), dollar(b)}. The rule COMMON_formatUserFirstLastName is probably not defined in a way that is compatible with multiples. So best bet is to "apply" this rule as in the code above.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
jackm829
A Score Level 3
over 9 years ago
dollar() is multiple safe, meaning that you can pass in a list and dollar({a,b}) = {dollar(a), dollar(b)}. The rule COMMON_formatUserFirstLastName is probably not defined in a way that is compatible with multiples. So best bet is to "apply" this rule as in the code above.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data