Questions tagged [number]

The tag has no usage guidance.

12 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
213 views

How to prevent salesforce from auto- formatting phone numbers

I am using a lightning component to display a phone number. I am currently in France and i want all the phone numbers to follow local formatting, which is not the case when i use the lightning ...
1
vote
0answers
77 views

How to allow decimal input whose number of decimal places is lower than the step value of input component

I have a lightning input component with the attributes as type="number", formatter="decimal",and step="0.01". However, this seems to restrict the decimal input to be of exactly 2 decimal places. Is ...
1
vote
2answers
5k 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
1answer
250 views

How to create a data extension with everyone who has ever opened or clicked on an email?

I'm trying to create a data extension with everyone who has ever opened or clicked on an email in it... The challenge is, that we used to have a SFDC + ExactTarget integration prior to migrating to ...
0
votes
0answers
38 views

I can not show numbers(Quantity) in lightning datatable. All other fields are showing properly except number. Any solution please?

component.set('v.columns', [ {label: 'Product Name', fieldName: 'Name', type: 'Text'}, {label: 'Total Quantity', fieldName: 'Total_Quantity__c', type: 'number'}, {...
0
votes
0answers
47 views

How to use “.” in LWC datatable in a column of type number?

I noticed that is not possible to use a number like "12.6" in a cell of type "number" but is only accepted a number like "12,6". How can I allow the use of the "dot" character? Thanks, Luca
0
votes
1answer
82 views

Increase the Number type field by 1 on record every time it's edited and Saved

I'm working on a Record where I need one of my fields which is Number type should auto update to +1 whenever the formula filed in the record gets populated. The Number field should increase by 1 unit (...
0
votes
0answers
31 views

auto number which is text

I have to create a field on opportunity which will be lookup to a custom object. On custom object, there is a Quote Number (Text) which is a standard field, I have to fetch that quote number to a ...
0
votes
1answer
59 views

Can't insert a record with Number(16, 2) field type

I've to insert, for my test method, an Invoice__c object with a value of Amount_Due__c more than 0. This field is a Formula (Number) with 2 Decimal Places field with this syntax Invoice_Amount__c - ...
0
votes
1answer
55 views

How to create a formula to output a number for a picklist value, and reject an N/A value?

In creating a formula to stamp the numerical value of a picklist, I am having difficulty with an "N/A" value. Right now, the picklist has 0,1,2,3,4,5,6,7,8,9,10,N/A as options to choose from. I am ...
0
votes
0answers
474 views

Where Clause in Query to match Phonenumber

How can I match for phonenumber in my whereclause? My query: SELECT id, Membership_number__c, Phone, Email FROM Contact WHERE Phone = :phoneNumberString Above mathces fine on these phonenumber ...
0
votes
0answers
2k views

How to convert number field to text in formula field?

I created a number field with options, Required, Unique and External Id checked, and want to use formula to convert Employee Number to text to prevent commas from displaying in the field. I tried to ...