+ 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
SteveMoSteveMo
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
SteveMoSteveMo
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