• Christopher Milner
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 6
    Questions
  • 8
    Replies
I have a custom object (titled "Workfront") we are using to track customer onboarding projects. Data from this is being synced over from an outside program and the field we are using to record the name of the trainer ("Implementation Specialist") is coming across as text.

I would like to create a contact lookup field on the object and somehow populate that field with what is in the text field. i.e. if the text field says "John Doe" and we have a contact named "John Doe", I would like to somehow grab the text value, perform a search, and populate the lookup field with a matching contact (if one is found). Any insight on achieving this would be greatly appreciated!
I am attempting to write a validation rule to fulfill a customer request. Essentially, we have a custom field on the contact record called "Division". The short version is, I would like a validation rule that restricts a record from being created/saved if "Division" is blank when the related account = 0013200001FTkYh (ID of the account in question). Any help would be appreciated!
I am attempting to generate a SOQL query across the following three objects:
  • Account (standard).
  • Cases (standard).
  • Workfront__c (custom object housing implementation project information; related to Account via lookup field 'WkFrontSFAccount').

Most of our accounts have a related workfront project (when new customers purchase implementation), and within the project information there is a "project manager" field. At the end of the day, I would like to generate a list of cases, grouped by Account for any Account that had an implementation project where the project manager = "X".

Example: Say accounts "A1" and "A2" were implemented by "John Doe". I would like a SOQL query that returns cases for A1 and A2 but no other cases and grouped by the account name. Thanks in advance if anyone can assist here! Really just getting my feet wet with SOQL; a 3 layer query is giving me some issues.

Context:
Within our org we have a custom "Workfront" object we are using to track implementation projects for new customers. This object has a related list on the page layout called "Workfront Participants", which is a junction object with two lookup fields. One is a contact lookup and the other lookup for the "Workfront" project. The "Workfront" object is related to accounts in our org. 

Need:
I would like a visualforce page list button that loads a new page which is a list of contacts from the account the current project is related to. A user can then select checkboxes next to each desired contact and click "add" to add them to the "Workfront Participants" related list.

Is this something that is doable/someone could assist me with?

User-added image
I created a new custom case field called "Business Days Case Open" and pulled this equation from another question (posted back in 2014).
If( Isclosed,

(CASE(MOD(Datevalue(CreatedDate) - DATE(1985,6,24),7),
0 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
1 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
2 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
3 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
4 , CASE(MOD(ClosedDate - CreatedDate ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
5 , CASE(MOD(ClosedDate - CreatedDate ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
6 , CASE(MOD(ClosedDate - CreatedDate ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
999)
+ (FLOOR((ClosedDate - CreatedDate)/7)*5)
-
IF(OR(
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=0),
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=1)), 1, 0)),

(CASE(MOD(Datevalue(CreatedDate) - DATE(1985,6,24),7),
0 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
1 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
2 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
3 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
4 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
5 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
6 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
999)
+ (FLOOR((Today() - Datevalue(CreatedDate))/7)*5)
-
IF(OR(
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=0),
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=1)), 1, 0)))

This works great if the case is open, but once we close a case, the field only returns a value of "0". Any insight on how I can get this to properly calculate even if the case is closed? It should be calculating the time between the Created Date and the current Today date. I have poked at this a little bit with no luck. Any help would be appreciated!
We have a custom lightning component (titled NavBar) which was built to function as a header/navigation bar for our Koa community. Awhile back, an update broke the mobile responsiveness of this. i.e. when a desktop browser window was shrunk or when viewed on a smaller screen (such as a phone or tablet), the menu would compress and options would be under a hamburger icon. Now, the the menu items no longer compress and the bar breaks visibility on anything less than a full browser page. I did not write this and am barely into learning CSS, Bootstrap, lightning, etc. so was hoping to maybe get some assistance. The code in its basest form is as follows:
<aura:component implements="forceCommunity:availableForAllPageTypes" >
	<div class="hcss-header">
		<div class="hcss-header-color"> 
			<a class="hcss-header-logo" href="/"><img src="https://hcss.force.com/customer/s/HCSS-Logo2.png?v=1" style="height:55px; padding-top:7px;"/></a>
			<div class="hcss-header-links">
				<a class="item" href="/">Home</a>
				<a class="item" href="/s/contactsupport" target="_blank">Contact Support</a>
				<a class="item" href="https://support.hcss.com/" target="_blank">Download Portal</a>
				<a class="item" href="http://community.hcss.com" target="_blank">HCSS Community</a>
				<a class="item" href="/s/webinars" target="_blank">Webinars</a>
				<a class="item" href="http://chat.hcss.com" target="_blank">Live Chat</a>
				<a class="item hcss-active" href="http://bomgar.hcss.com" target="_blank">Start A Remote Session</a>
			</div>
		</div>
	</div>
</aura:component>
I am attempting to write a validation rule to fulfill a customer request. Essentially, we have a custom field on the contact record called "Division". The short version is, I would like a validation rule that restricts a record from being created/saved if "Division" is blank when the related account = 0013200001FTkYh (ID of the account in question). Any help would be appreciated!
I created a new custom case field called "Business Days Case Open" and pulled this equation from another question (posted back in 2014).
If( Isclosed,

(CASE(MOD(Datevalue(CreatedDate) - DATE(1985,6,24),7),
0 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
1 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
2 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
3 , CASE(MOD(ClosedDate - CreatedDate ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
4 , CASE(MOD(ClosedDate - CreatedDate ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
5 , CASE(MOD(ClosedDate - CreatedDate ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
6 , CASE(MOD(ClosedDate - CreatedDate ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
999)
+ (FLOOR((ClosedDate - CreatedDate)/7)*5)
-
IF(OR(
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=0),
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=1)), 1, 0)),

(CASE(MOD(Datevalue(CreatedDate) - DATE(1985,6,24),7),
0 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
1 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
2 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
3 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
4 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
5 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
6 , CASE(MOD(Today() - Datevalue(CreatedDate) ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
999)
+ (FLOOR((Today() - Datevalue(CreatedDate))/7)*5)
-
IF(OR(
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=0),
NOT(MOD( Datevalue(CreatedDate) - DATE (2000 ,1, 1) ,7)=1)), 1, 0)))

This works great if the case is open, but once we close a case, the field only returns a value of "0". Any insight on how I can get this to properly calculate even if the case is closed? It should be calculating the time between the Created Date and the current Today date. I have poked at this a little bit with no luck. Any help would be appreciated!
Is there a tool to Migrate Article types to Knowledge Article types Lightning?  I did not see anything in the release notes.
Hi,

I need to create one formula field (returns number) which will calculate Case Age (In days) such that it will keep incrementing until case is closed. If the case is closed it will stop counting. This excludes weekends.

Can someone please help me on this?

Thanks,
Pooja
Hi All, I am using the below format to retrive the feild label: However I need to remove the last 3 characters of the label during display. Any Idea? Thanks
  • December 07, 2010
  • Like
  • 0