Sign Up ›
  • jo price
  • NEWBIE
  • 0 Points
  • Member since 2020
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 1
    Replies
4 replies

Does anyone know can I have a formula field that can also be a pick list?

Can I have a field that is both a picklist and formula?  The picklist values will be 1 to 72.

I need 1 field to be able to used 2 ways. 

1st – Formula to work out the number of months between 2 date fields and return the result as a number, eg Date 1 = 18 August 2021 / Date 2 is 7 February 2021 Result = 8 (representing 8 months).
AND
2nd - also need people to be able to manually select a value between 1 and 72 from the picklist.

Is this possible or do I need 2 separate fields
 
2 replies

api synch issues

We are seeing this error when trying to sycnh transaction records from our web site to salesforce using API code the :

This is the full error message
Funraisin (Funraisin)
May 7, 2020, 6:20:03 PM GMT+10
<pre>Array
(
[0] => stdClass Object
(
[causeview__Expected_Amount__c] => 2.00
[Service_Fee__c] => 0.00
[causeview__Gift_Type__c] => One Time Gift
[causeview__Source__c] => Funraisin
[causeview__Receipt_Type__c] => Single Receipt
[Legacy_Receipt_Number__c] => DONSHW1142
[causeview__Status__c] => Payment Received
[causeview__Channel__c] => Web
[RecordTypeId] => 0122v000001ePxfAAE
[causeview__Affiliated_Contact__c] => 0032v00003V8JtXAAV
[causeview__Gift_Date__c] => 2020-05-07T00:00:00+10:00
[causeview__Constituent__c] => 0032v00003V8JtXAAV
)
)
</pre><pre>Array
(
[0] => stdClass Object
(
[errors] => Array
(
[0] => stdClass Object
(
[fields] => Array
(
[0] => RecordTypeId
)
[message] => Record Type ID: this ID value isn't valid for the user: 0122v000001ePxfAAE
[statusCode] => INVALID_CROSS_REFERENCE_KEY
)
)
[id] =>
[success] =>
)
)
</pre>d

this ID 0122v000001ePxfAAE represents an opp record type
4 replies

Does anyone know can I have a formula field that can also be a pick list?

Can I have a field that is both a picklist and formula?  The picklist values will be 1 to 72.

I need 1 field to be able to used 2 ways. 

1st – Formula to work out the number of months between 2 date fields and return the result as a number, eg Date 1 = 18 August 2021 / Date 2 is 7 February 2021 Result = 8 (representing 8 months).
AND
2nd - also need people to be able to manually select a value between 1 and 72 from the picklist.

Is this possible or do I need 2 separate fields