Recent searches
No recent searches

Adam Wideman
Joined May 16, 2021
·
Last activity Oct 16, 2021
Following
0
Followers
0
Total activity
2
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Adam Wideman
Adam Wideman commented,
I'm not sure if I'm doing this totally correct or if I need to make a whole different set of custom metrics to pull this off, but I'm trying to add some custom fields to my Organizations for "Service Agreements". Each agreement, of which there are 3 for each organization possible, would have a "Contract Number", "Hours Purchased", and a "Contract Value". I need to pull in Hours Purchased and Contract Number in order to run a query against how many "hours billed" against the "Hours Purchased". I've been able to do this easily with just one contract, but now its causing some erroneous data when we have multiple contracts involved. SO I want a field thats SUPER smart. I need one that knows to show hours purchased relevant to which Contract Number is used. The matching field is called "Ticket Sage Reference" (also custom) and lives in the ticket. I want to say something like
IF ([Ticket Sage Reference]=VALUE(ContractNumber))
THEN 1
ELSE IF ([Ticket Sage Reference]=VALUE(ContractNumber2))
THEN 2
ELSE IF ([Ticket Sage Reference]=VALUE(ContractNumber3))
THEN 3
ENDIF
Then one that would ACTUALLY display the content
IF ([CustomMetric]=1)
THEN VALUE(ContractNumber1)
ELSE IF ([CustomMetric]=2)
THEN VALUE(ContractNumber2)
ELSE IF ([CustomMetric]=3)
THEN VALUE(ContractNumber3)
ENDIF
I'm terrible with functions, please send help . I think I may even be at the point where I may even pay Zendesk to write this for me, but wanted to see if anyone could steer me in the right direction before i did that.
View comment · Posted Apr 12, 2021 · Adam Wideman
0
Followers
0
Votes
0
Comments