I have a field in a custom object in where i can write HTML text within wysiwyg editor.
when i tried to export it with a report (csv/xls) my field got exported with text format
is there a way to make Export/Import data from that custom object and maintaining the html format of the field ?
Thanks in advance.
Did you try exporting with Data Loader (https://help.salesforce.com/articleView?id=exporting_data.htm&type=0)
This formula works fine
Log_Trends__c.Final_Pay__c:SUM / Log_Trends__c.LogEntry_Hours_Worked__c:SUM
Trying to get half of the total. I tried
(Log_Trends__c.Final_Pay__c:SUM / Log_Trends__c.LogEntry_Hours_Worked__c:SUM) * .5
I struggle with formulas and am trying to create a formula to review an outstanding amount against payments being made. Here's what I've got:
IF((!ISBLANK(Payment_1__c) && ISBLANK(Payment_2__c), Outstanding_Loan_Credit_Amount__c - Payment_1__c),
IF((!ISBLANK(Payment_2__c) && ISBLANK(Payment_3__c), Outstanding_Loan_Credit_Amount__c - Payment_2__c)
IF((!ISBLANK(Payment_3__c) && ISBLANK(Payment_4__c), Outstanding_Loan_Credit_Amount__c - Payment_3__c)
IF((!ISBLANK(Payment_4__c) && ISBLANK(Payment_5__c), Outstanding_Loan_Credit_Amount__c - Payment_4__c)
IF((!ISBLANK(Payment_5__c) && ISBLANK(Payment_6__c), Outstanding_Loan_Credit_Amount__c - Payment_5__c)
IF((!ISBLANK(Payment_6__c) && ISBLANK(Payment_7__c), Outstanding_Loan_Credit_Amount__c - Payment_6__c)
IF((!ISBLANK(Payment_7__c) && ISBLANK(Payment_8__c), Outstanding_Loan_Credit_Amount__c - Payment_7__c)
IF((!ISBLANK(Payment_8__c), Outstanding_Loan_Credit_Amount__c - Payment_1__c), 0))))))))
Can you give more background? In this result field, are you trying to deduct the payments from the outstanding loan credit amount? If so, it could be as simple as:
and check the "Treat blank fields as zeroes" on Blank Field Handling options.
Thanks for screenshot.
This shows data as Blank*** means Data was entered at the time of import.If it is really blank it would not show you anything.
You may clean data for contacts and update correct values.
Today's Date: 11/17/2018
Formula Field Value: 3/15/2018
IF( AND( ISBLANK(Date_1__c), ISBLANK(Date_2__c), ISBLANK(Date_3__c), ISBLANK(Date_4__c) ), NULL, DATE(1900, 01, 01) + MIN( BLANKVALUE(IF(Date_1__c < TODAY(), NULL, Date_1__c), DATE(4000, 12, 31)) - DATE(1900, 01, 01), BLANKVALUE(IF(Date_2__c < TODAY(), NULL, Date_2__c), DATE(4000, 12, 31)) - DATE(1900, 01, 01), BLANKVALUE(IF(Date_3__c < TODAY(), NULL, Date_3__c), DATE(4000, 12, 31)) - DATE(1900, 01, 01), BLANKVALUE(IF(Date_4__c < TODAY(), NULL, Date_4__c), DATE(4000, 12, 31)) - DATE(1900, 01, 01) ) )
When a lead clicks the link, they are routed to my site, confirm their opt out, and then my site will automatically check the "email opt out" box for that lead via the Salesforce API.
The problem I'm running into is that the formula I use to generate the Opt Out URL field on the Lead object results in a truncated Lead ID.
Original Formula I Used: "https://mysite.com/unsubscribe" + "?" + Id
The Original Formula generated a URL on all lead records but the URL did not include the last three characters of the 18 character Lead ID.
I thought that perhaps my URL was too long so I created a revised formula that substituted "optout" for "unsubscribe" to make the URL shorter.
Revised formula: "https://mysite.com/optout" + "?" + Id
But the last three characters of the Lead ID were still truncated.
What's going on here?!? Why are my Lead IDs being truncated?
You can convert 15 Digit ID to 18 Digit ID:
Use CASESAFEID(Id) as suggested by Deepak above. Refer below link for more infor on this.
"https://mysite.com/optout" + "?" + CASESAFEID(Id)
Does anyone know why my field formula would be throwing an #Error! if this formula evaluates to TRUE?
( Order_Date__c ) >= DATE(YEAR(TODAY()),MONTH(TODAY()),1),
( Order_Date__c ) <= DATE(YEAR(TODAY()),MONTH(TODAY()),31)
My formula return type is "Number", and weirdly enough if this formula evaluates to FALSE, it does return a 0.
It's just when it evaluates to TRUE, it doesn't return a 1, just the "#Error!".
Also to note, there are no syntax errors when it is compiled.
So you can amend it to be like this =
(The idea is simple. Add to the current month to advance to the next month and then subtract 1 from the 1st of the next month(as obtained) to get the last day of the current month)
IF( AND( Order_Date__c >= DATE(YEAR(TODAY()), MONTH(TODAY()), 01), Order_Date__c <= DATE( IF( MONTH(TODAY()) = 12, YEAR(TODAY()) + 1, YEAR(TODAY()) ), IF( MONTH(TODAY()) = 12, 01, MONTH(TODAY()) + 1 ), 01 ) - 1 ), 1, 0 )
When attempting to upsert leads, dataloader has been crashing once in step 3 "Mapping". When editing a map, the entire window freezes, mysteriously the "salesforce" text in the app logo in the disappears, and I have to force quit. Please help!
I created a custom layout for the tasks for the service cloud platform. I can't figure out how to make it visible to my users. They would all have access to 2 tasks layout, the default one and the custom I created.
Go to Task Setup - > Activities ->Task Page Layout - >Page Layout Assignment- >Edit Assignment.
Assign Task Page Layout to Record Type Based on User Profile.
Also, Go to Profile and Provide Access to Task Record Types.