Questions tagged [number]
The number tag has no summary.
57 questions
0 votes
1 answer
44 views
What does the field datatype "number" mean - we are receiving an XML error trying to SELECT such a field
We have a field in Salesforce declared like this: CNUM Number(10,0) (ExternalID) When we tried to query it from an API call, this method failed: QueryResult queryResult = service.query(queryString); ...
1 vote
1 answer
873 views
InvalidNumber File Import Errors when using "number" field type
I set up a daily automation to pull in a file import from an SFTP folder. For some reason, Marketing Cloud will not accept the columns as a "number" data type. We rounded the numbers to ...
0 votes
1 answer
1k views
LWC Restrict <lightning-input> to number with max value
I have an input on an LWC which has to be a number and not greater than 2000. How do I go about achieving this, because whatever I've tried is not working. This is my input definition: <lightning-...
0 votes
1 answer
165 views
Number field in Custom Metadata returning inconsistent formatting when queried
I don't understand how this is possible? I have a simple custom metadata object with a number field (7,0) called Portal Id. The first record has a value of 20 in that field. When I run this query I ...
2 votes
1 answer
140 views
How do you only display decimal places if they aren’t zero?
I have numerical data being passed into an email to two decimal places, it could be 10.00 or 10.16 for example. Is there a way I can easily show just 10 if the original number is 10.00, but show 10.16 ...
0 votes
0 answers
986 views
Converting text to number
I am trying to create a new field and convert a text to a number but am getting this error (Error: text__c may not be used in this type of formula) when using this formula (Value(text__c)). The ...
0 votes
1 answer
317 views
Salesforce formula not working on number field
I want to calculate the total number of working hours (Mon-Fri 8.30am-5pm) between two date/time fields. For this purpose I created the following two formula fields: TT_Calculate_Emails_SLA__c (...
-1 votes
1 answer
435 views
How to make a number field dependant from a checkbox?
In sales orders I have 2 custom fields Qnty and Free Qnty and a checkbox Free Qnty Only. For orders, that have a number in Quantity it's possible to enter Free Quantity and the checkbox is set to ...
0 votes
1 answer
476 views
page number in vf page
hi all i need pagination in vf page. i've tried increase and reduce currentPage number in navigation button but it didn't work. here my code: controller: public PageReference Next() { ...
0 votes
2 answers
113 views
replace prefixes
Im not sure if I doing this right, I got phone numbers in a form like Phone = '+421\+42199940054' Phone = '+421\+421%' . . . wrong thing are prefixes, wanted only second '+421' My code List<Lead>...
2 votes
1 answer
470 views
SOSL Alphanumeric Search String Behavior, solution using %
I'm trying to understand some SOSL behavior. I had an issue where I needed to do a SOSL search using alphanumeric search strings. EX: 'blue1' We found that attempts to search using alphanumeric data ...
-2 votes
1 answer
48 views
Need "number" field validation rule to accept 08445611044 for ireland companies please help. Currently not accepting this number
The current validation rule, is not accept the number 08445611044: If( ISPICKVAL( Region__c,"NI"),NOT(REGEX(Phone, "0[1-9]{1}[0-9]{8,9}")) , If( ISPICKVAL( Region__c,"SCT&...
-1 votes
3 answers
8k views
Validation rule to check if a NUMBER field is blank doesn't seem to work
I created a Validation rule like below : AND( ISPICKVAL(Rate_Type__c, 'Custom'), ISBLANK(Script_ID__c) ) Script_ID__c is of Number(18,0) data type Unit testing Scenario 1: When I fill Rate Type =...
0 votes
0 answers
180 views
Add Number sequence afterwards based on this Group and Order
I need some help with the following. After the collection of different records across Salesfore, a set of new invoice records is created like the example below This list is Grouped by Invoice number ...
0 votes
1 answer
1k views
Error: Compiled formula is too big to execute (5,254 characters). Maximum size is 5,000 characters Description Help Text
I Have 20 formula fields that calculate a number value based on picklist value selected multiplied by a value in custom metadata. I want to sum all these 20 fields based on changes of the picklist ...