function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
AthiSachiAthiSachi 

Formula result is data type (Object), incompatible with expected data type (Number).

Hello all,

 My process builder autocreates an custom object which has lookup relationship. I am trying to populate that relation field with another text field(which hold record Id) using formula . however I get above error message?
How would I update lookuprelationship field  from text field

Thanks
Athi
SteveMo__cSteveMo__c
Can you post screenshots of your Process, Formula, and the error? 

Thanks
AthiSachiAthiSachi
User-added image

Location is the relationship field to location object.  GIGI_MainPlayhouseID__C is the record id of location object(Child) stored in playhouse object(parent).

Formula used:  ([Contact].Account.Playhouse__c.GIGI_MainPlayhouseId__c )
Error message:  Formula result is data type (Object), incompatible with expected data type (Number).

Please let me know how to solve this issue. Thanks in advance
SteveMo__cSteveMo__c
Yeah, that is not correct syntax 
Id.([Contact].Account.Playhouse__c.GIGI_MainPlayhouseId__c)
Instead of using a Formula I would try busing a Field Reference
 
AthiSachiAthiSachi
Field reference doesn't work. GIGI_MainPlayhouseId__c(text field) doesn't appear in that option. That why, I went ahead and added formula but it didnt work either. Please hellp Thanks Athimathi Database And Sales Force Administrator GiGi's Playhouse, Inc. Down Syndrome Achievement Centers asachithanandam@gigisplayhouse.org 262-565-7616