Questions tagged [formatting]
About formatting data on the view of Visualforce pages.
1
vote
2answers
54 views
Formatting Datetime.now()
I need to format my Datetime.now() to be accepted for a SOAP request.
I can't seem to find a way to format it online. Can anyone advise? I need it to look like: 2019-05-02T21:20:29.999Z
Currently I ...
0
votes
1answer
60 views
Date Format in VisualForce Page
I need this date format in a visualforce page as MM/dd/yy, below is the code. But in page it display as Fri Mar 08 00:00:00 GMT 201903/08/19, Can you please help me on this?
<apex:commandLink ...
0
votes
1answer
229 views
Apex convert string mm/dd/yyyy hh:mm:ss to standard system date (yyyy-mm-dd 00:00:00)
I am trying to convert string from google docs "1/16/2019 11:52:38" to standard system date "2019-01-16 00:00:00". I was able to achieve that using substring method but I am pretty sure there is a ...
1
vote
1answer
1k views
Lightning:datatable number formatting
I have created a lightning:datatable to display order lines. The order lines are fetched via a REST call. I parse the JSON response and add to the datatable data attribute. Everything works fine but ...
1
vote
2answers
511 views
Lightning Component - Date formatting not consistent with standard UI
I am using lightning:datatable to render data including dates.
My date column definition looks like:
{ label: 'Expiration', fieldName: 'ExpirationDate__c', type: 'date'}
The date in the table is ...
0
votes
0answers
20 views
pageBlockTable Column Widths Sync
I have a custom VF page that uses 2 pageBlockTables, 1 to show aggregate amounts for my fields in total, and another to show aggregates by year. I was not able to get them into 1 table, so I tried to ...
0
votes
1answer
338 views
Converting Currency to Decimal And Converting Back To Currency Display in Email Template
I have a currency field that I multiply by .5 in my apex code.
This changes the data type to a Decimal.
I want to display on a visualforce email template the newly updated number as a currency.
...
2
votes
2answers
423 views
Is it possible to make text bold in a custom label?
Background
We have a custom application which we need to support in multiple languages. Visualforce is our main UI framework.
For internationalization we will use Custom Labels. One of the possible ...
0
votes
1answer
156 views
Unordered List with no bullets not working with email template
I have a Visualforce Component that has a un-ordered list. I want that list to have no style other then the indentation. Usually with HTML you would just specify the ul css to be list-style:none or ...
3
votes
0answers
137 views
Moment JS but for Salesforce Apex
Are there any open source libraries similar to Moment JS but for Apex?
Reference:
Moment JS
1
vote
1answer
286 views
Break tag inside rich text field in lightning
We use a Visualforce page to automatically fill a rich text field with some generated content. After that, the user is allowed to edit the content before it's displayed on a website. After our ...
0
votes
1answer
272 views
Marketing Cloud - Timezone - Format/Display
I guys. Need your help, please.
1 -I know the dates in Marketing are saved in CST timezone, but when I view them in "form mode" I need to see them as GMT / UCT. I have already set up account and user ...
0
votes
0answers
142 views
Formatting parameterized custom label inside subject for Visualforce Email template
I'm trying to use the format() visualforce function to have a parameterized custom label as my Visualforce Email Template subject.
This is my current code:
<messaging:emailTemplate
...
0
votes
2answers
242 views
Checkboxes Don't Align on Visualforce page
Checkboxes Don't Align
I have two groups of vertical checkboxes on a Visualforce page and the top one in both columns is about two spaces to the left of the others. What is the best way to format the ...
1
vote
1answer
270 views
How to get current user date/time format in apex, e.g. MM/dd/YYYY hh:mm:ss a z
We need to figure out current user date/time format in apex code to send it to our mobile app in order to display data in same way as it is in Salesforce itself.
In other words, it's about getting ...
1
vote
1answer
314 views
Visualforce format an output number depending on decimal value, if decimal is zero then just display the number
I am trying to display multiple values in a page which are currency fields set with 2 decimals (in the object).
Currently I am using the below expresion to format the values which works great:
<...
0
votes
0answers
172 views
Date Format: Apex Callout (Soap webservice)
We are performing an apex callout from Salesforce to a SOAP based webservice and it requires us to pass a date in the following format: MM/DD/YYYY (note: this should be date datatype). When I am ...
0
votes
1answer
3k views
Using lightning:input with type=“number” and formatter=“currency”
Is there a way to use lightning:input with formatter="currency" to show whole number instead of Decimal number
<lightning:input aura:id="{!item.Id + 'CY_Tile_Budget__c' }"
type="number" name="...
0
votes
1answer
591 views
How do I convert a String to Decimal in Apex using a specific locale?
I am receiving as a response from a third-party webservice a JSON having prices formatted in a different way depending on locale.
Below some examples of the format of the text sent (depending on the ...
0
votes
1answer
149 views
How to replicate NumberFormat based on locale in salesforce
I want to show currency on VF page in different formats based on locale used on the template. NumberFormat class is available in Java to achieve this but in apex is there any way to achieve this.
...
0
votes
1answer
745 views
Formatting as a currency on a VF page
I'm trying to render a currency value to a VF page. Whether I use Decimal or String, it still doesn't seem to work with the OutputText formatting :-
<apex:column>
<apex:facet name="...
0
votes
1answer
490 views
AMPscript Date Formating for French Language in HTML emails
This puts today’s date in my HTML email:
%%=Format(Now(), "MMMM d, yyyy")=%%
Any idea how to format this for FR? I've tried doing this and it doesn’t work:
%%=Format(Now(), "MMMM d, yyyy","fr-CA")=...
1
vote
1answer
80 views
If Statement to format a value depending on a Picklist value of another field
Any Help would be much appreciated- I actually will be doing this for several different currency values If I could use a case statement even better. I know it should be in a class but I do not have ...
0
votes
2answers
775 views
Format VF Page Input Field to 2 decimal places
I would like to format the default inputField value on a Visualforce page. The underlying standard field has a data type of number(10,5). I want this on my VF page with 2 decimal places.
How can I ...
1
vote
1answer
529 views
VF Email Template - Convert GMT to EST/EDT without components/controllers using date formatting?
We are creating a Visualforce email template to be sent when certain Events are saved/edited to meet criteria. The VF Template is related To Event/Contact:
<messaging:emailTemplate subject="...
0
votes
2answers
579 views
Rich Text Area formatting not visible in VF
I am using Rich text areas in my VF page. I am entering the data for the rich text area from the backend and want it to be displayed on the page. The problem is if I add bullets or make the text bold ...
1
vote
0answers
101 views
Ordinal Indicators In Date Formatting
I've been using the following bit of code in my Visualforce pages to get the so called ordinal indicators (the 'st', 'nd', 'rd', and 'th' in 1st, 2nd, 3rd, 4th) when formatting dates.
<apex:...
1
vote
1answer
349 views
Difference between 2 Date fields
In my record I have to datetime fields, now() and Create date. I want to do the difference between them and put this difference in the form:
example:
TOT days TOT hours TOT minutes TOT seconds.
Is it ...
0
votes
1answer
118 views
VF page, using remote objects, in jquery need to format Date and Currency field
I'm using remote objects for this page.
I'm trying to format the field Invoice_Amount__c to contain commas which will separate the numbers and format the Invoice_Date__c field to mm/dd/yyyy.
I ...
3
votes
1answer
369 views
Format date from: 01/01/2017 to 1/1/2017
Got this code:
<apex:outputText value=" {0,date,MM/dd/yyyy }"> <apex:param value="{!IF(Lead.CreatedDate!=null,Lead.CreatedDate+90,'N/A')}"/></apex:outputtext>
how to format date ...
2
votes
1answer
329 views
Online formatter tool for the list output in debug log
do we have any tool just like JSON formatter, XML formatter to format the list output that is coming in debug log text. For example,
[AccountOwner=null, Address=25 S. aka Ave. Duluth MN 802 US,
...
0
votes
2answers
609 views
Date format from Apex variable in VF
apex:variable var="Expiry" value="{!if((TEXT(object.Executed_Expiry_Date__c)!=null && TEXT(object.Executed_Expiry_Date__c)!=''),object.Executed_Expiry_Date__c,
object.Expiry__c)}"
...
2
votes
2answers
991 views
How to format a Visualforce inputField [duplicate]
I want to format the default inputField value on a Visualforce page. I am pre-filling the number field with 1 but it is displaying as 1.00.
The underlying standard field has a data type of number(10,...
0
votes
1answer
744 views
Removing leading zeros in a string in a VFP page?
I have a VFP that displays a list of cases and includes the case number column like this:
<apex:column >
<apex:facet name="header">
<apex:commandLink value="Case #" action="...
1
vote
1answer
34 views
Add > in Visualforce Template Email Subject
I need to add > to the subject of Visualforce email template. Like:
Wayne Enterprise > Bruce Wayne
Directly adding > in the subject doesn't work. I have tried adding HTML code as shown below but ...
0
votes
1answer
253 views
Command Line Data Loader - how to format the date?
I am using the CLI Dataloader to successfully extract records from Salesforce as part of an interface into Back Office Systems. I have a query, a bit like this:
SELECT ID , ClosedDate, createdDate,...
1
vote
1answer
475 views
Calculating the last day of next month using Ampscript
I'm looking to populate the last day of the following month for a promotion that we are running in an email. So, regardless of the current date, the promo will always end the last day of the following ...
2
votes
2answers
794 views
Conditional Cell Color in VF dataTable
I'm using a custom controller to query OpportunityFieldHistory to find changes to Close Date within a given timeframe. Then, the query results are displayed in a VF dataTable. I can display OldValue ...
1
vote
1answer
302 views
How to fix formatting in <apex:pageBlockSection
How can it be align to rest of the fields like how it has Start/End date... like to avoid using style like left-padding etc...
Screen shot how it looks after it renders:
Here is my VFP code that ...
4
votes
1answer
305 views
How to programmatically double apostrophes in custom label translations?
I have a custom label which contains a couple of parameters:
Hello, {0} the other param is {1}.
I wish to output this value in a Visualforce Page like so:
<apex:variable var="firstParam" value="...
0
votes
2answers
688 views
Visualforce pageBlockTable - update values in cells on load
I've been developing a page that displays dollar amounts in a table, and allows updates to those amounts. This table is read from and writes to a JSON string. Some of these dollar amounts have many ...
2
votes
1answer
321 views
How to get default field formatting with outputText?
So I know I can just render a field with its default formatting using outputField:
<apex:outputField value="{!MyObject__c.MyDate__c}" />
If I try to render the same field using outputText I ...
4
votes
2answers
823 views
Visualforce currency euro
I need to display currency. This field is Roll-up summary of formula fields with return type 'Number'
<apex:outputText value="{0, number, currency}">
<apex:param value="{!Invoice....
1
vote
1answer
120 views
Why week of year is wrong?
I'm using this code :
Time t = Time.newInstance(12, 0, 0, 0);
DateTime dt = DateTime.newInstance(Date.parse('22/02/2016'), t);
system.debug(LoggingLevel.WARN, Integer.valueof(dt.Format('w')));
It ...
2
votes
0answers
2k views
How could I do line breaks (/n or /r/n) on Messaging.SingleEmailMessage PlainTextBody?
I know this question is asked before and could found in the below links,
(I am posting this as I want to post my code with some changes to the solutions provided in the below links.)
PlainText email ...
0
votes
1answer
1k views
Trim/remove trailing zeros from decimal apex:inputfield
We have a decimal apex:inputfield that supports up to 12 decimal points; however most of our cases will not use more than 4-5 decimal points and we don't want to clutter the page with extra zeros. ...
0
votes
2answers
905 views
FormatNumber() always 2 decimal
I'm trying to show a number with 2 decimals, and no thousand "," mark.
I have tried:
%%[
Set @PointBalance = 2300
Set @FormatPoint = FormatNumber(@PointBalance,"N2")
]%%
This gives 2,300.00.
...
2
votes
1answer
3k views
Datetime format ignores am/pm?
Hi I am new to apex coding and am trying to parse a datetime and then later on in my program I am trying to convert it back into a string to query items.
For converting a string into a datetime I am ...
0
votes
1answer
1k views
Change Date Format in Formula Field
How do I change the format of a date in formula field? I want its data type to be a date. I want to change its format to 'MM-dd-YYYY' but I don't want to change user's locale settings. Is this ...
0
votes
3answers
762 views
Visualforce Date formatting in arbitrary Locale
So I know I can format dates like
<apex:outputText value="{0, date, MMMM d',' yyyy}">
<apex:param value="{!contact.Birthdate}" />
</apex:outputText>
and this outputs e.g. ...
