• mcc22
  • NEWBIE
  • 10 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 6
    Questions
  • 9
    Replies
I am using three checkboxes (A, B, C) in the final screen of a flow that needs to be required based on the selection of the other checkboxes. 

The requirement is as follows: If C is blank, A and B are required, else C is required. 

I have tried writing this forward and backward and can't seem to find a formula that works. 

Is it possible to add a third condition in the following? This is as far as I got.
IF({!C}=TRUE && A = FALSE, TRUE, FALSE)

Many thanks
  • April 26, 2021
  • Like
  • 0
Greetings all,
I am trying to build a detail page button on a custom object (Fulfillment__c) that allows a sales rep to easily track a package.

When used separately the URLs work without error. However, when I try to use the same URLs in an IF function, it returns "Error: Enter a URL that is valid and well-formed." 
(!IF(Fulfillment__c.Shipping_Carrier__c = "UPS® Ground",
https://www.ups.com/track?loc=en_US&tracknum={!Fulfillment__c.Packaging_Tracking_Number__c}&requester=WT/trackdetails,

(IF(Fulfillment__c.Shipping_Carrier__c = “Standard Freight", https://trackmyparcel.com.au/{Fulfillment__c.Packaging_Tracking_Number__c}
))
There are other posts containing this error but none resolve my issue. I would be most grateful for any direction on this error. Or if there is another approach to meet this requirement. Thank you. 
  • March 23, 2021
  • Like
  • 0

Hello, 
I am trying to build a detail page button on a custom object (Fulfillment__c) that allows a sales rep to easily track a package. The tracking number and shipping carrier are custom fields. The goal is to leverage the IF function to use the correct URL with (tracking number merge field) based on the shipping carrier. Here's the basic format of my formula.

{!IF(Fulfillment__c.ShippingCarrier = "UPS","https://www.ups.com/{!Fulfillment__c.Tracking_Number__c}",
(IF(Fulfillment__c.ShippingCarrier = “FedEx", ”https://fedex.com/{!Fulfillment__c.Tracking_Number__c}”,
(IF(Fulfillment__c.ShippingCarrier = “DHL, ”https://dhl.com/{!Fulfillment__c.Tracking_Number__c}”
   )))))
}
I receive a syntax error on the second IF but I'm not exactly sure the cause. Is it possible to use merge fields in the formula? TIA
  • March 09, 2021
  • Like
  • 0
Hello all,

We have orders with associated accounts being created as part of an integration with eCommerce and ERP.

It is essentially creating person accounts since these are consumers. Instead of enabling person accounts, I would like to create a new contact record using the data from the account where Account.Person__c = true (custom field created to designate consumer accounts). 

This would be an easy PB but I'm having trouble setting values with the name fields. Any shared experience on how to "reverse-concatenate" Account.Name into Contact first name & last name?

Thanks in advance
  • January 05, 2021
  • Like
  • 0
I have a screen flow that is displayed perfectly for admins only. Non-admin users receive the following error message: 
User-added image
Users have no trouble viewing/using other flows on the same page layout. I have tried removing it and adding it back. Verified all permissions. No email notifications.

Any ideas? Your help is greatly appreciated. 
  • November 03, 2020
  • Like
  • 0

The Amazon Connect CTI Adapter is installed, configured, and can receive/place inbound and outbound calls.

However, when a call is received it opens the global search results page w/ contact instead of opening the contact detail page. Similarly, if an associated record cannot be found it returns the global search page with "no results". 

Any ideas on why the screen pop settings in the softphone Layout editor are not firing correctly? Thanks in advance. 

  • September 28, 2020
  • Like
  • 0
I am using three checkboxes (A, B, C) in the final screen of a flow that needs to be required based on the selection of the other checkboxes. 

The requirement is as follows: If C is blank, A and B are required, else C is required. 

I have tried writing this forward and backward and can't seem to find a formula that works. 

Is it possible to add a third condition in the following? This is as far as I got.
IF({!C}=TRUE && A = FALSE, TRUE, FALSE)

Many thanks
  • April 26, 2021
  • Like
  • 0
Greetings all,
I am trying to build a detail page button on a custom object (Fulfillment__c) that allows a sales rep to easily track a package.

When used separately the URLs work without error. However, when I try to use the same URLs in an IF function, it returns "Error: Enter a URL that is valid and well-formed." 
(!IF(Fulfillment__c.Shipping_Carrier__c = "UPS® Ground",
https://www.ups.com/track?loc=en_US&tracknum={!Fulfillment__c.Packaging_Tracking_Number__c}&requester=WT/trackdetails,

(IF(Fulfillment__c.Shipping_Carrier__c = “Standard Freight", https://trackmyparcel.com.au/{Fulfillment__c.Packaging_Tracking_Number__c}
))
There are other posts containing this error but none resolve my issue. I would be most grateful for any direction on this error. Or if there is another approach to meet this requirement. Thank you. 
  • March 23, 2021
  • Like
  • 0

Hello, 
I am trying to build a detail page button on a custom object (Fulfillment__c) that allows a sales rep to easily track a package. The tracking number and shipping carrier are custom fields. The goal is to leverage the IF function to use the correct URL with (tracking number merge field) based on the shipping carrier. Here's the basic format of my formula.

{!IF(Fulfillment__c.ShippingCarrier = "UPS","https://www.ups.com/{!Fulfillment__c.Tracking_Number__c}",
(IF(Fulfillment__c.ShippingCarrier = “FedEx", ”https://fedex.com/{!Fulfillment__c.Tracking_Number__c}”,
(IF(Fulfillment__c.ShippingCarrier = “DHL, ”https://dhl.com/{!Fulfillment__c.Tracking_Number__c}”
   )))))
}
I receive a syntax error on the second IF but I'm not exactly sure the cause. Is it possible to use merge fields in the formula? TIA
  • March 09, 2021
  • Like
  • 0
Hello all,

We have orders with associated accounts being created as part of an integration with eCommerce and ERP.

It is essentially creating person accounts since these are consumers. Instead of enabling person accounts, I would like to create a new contact record using the data from the account where Account.Person__c = true (custom field created to designate consumer accounts). 

This would be an easy PB but I'm having trouble setting values with the name fields. Any shared experience on how to "reverse-concatenate" Account.Name into Contact first name & last name?

Thanks in advance
  • January 05, 2021
  • Like
  • 0
I have a screen flow that is displayed perfectly for admins only. Non-admin users receive the following error message: 
User-added image
Users have no trouble viewing/using other flows on the same page layout. I have tried removing it and adding it back. Verified all permissions. No email notifications.

Any ideas? Your help is greatly appreciated. 
  • November 03, 2020
  • Like
  • 0
Hello All,

How to calculate the 5 business date since the record created date in the formula field.

Adv thanks

Regards,
VSk98 
  • November 03, 2020
  • Like
  • 0

The Amazon Connect CTI Adapter is installed, configured, and can receive/place inbound and outbound calls.

However, when a call is received it opens the global search results page w/ contact instead of opening the contact detail page. Similarly, if an associated record cannot be found it returns the global search page with "no results". 

Any ideas on why the screen pop settings in the softphone Layout editor are not firing correctly? Thanks in advance. 

  • September 28, 2020
  • Like
  • 0
Error: Enter a URL that is valid and well-formed
please helpme
see this code
{IF(Opportunity.parent__c==null, 
URLFOR($Action.Opportunity.New,null,[clone=1,id=Opportunity.Id,retURL="/"&Opportunity.Id,00N2800000FJLEz= Opportunity.Name ],true), 
Opportunity.parent__c

}