You need to sign in to do that
Don't have an account?
ZIKRA LOBANI 6
create formula field
Hi,
I need help to create formula field on custom object which should be reffernce to Autonuber field on another custom object .
new object : order
field name : request number
object : Internal request
field autonumber : IN number
I have used this formula(text) :
request number =Internal_request__c.IN_Number__c
and the result was syntax error ??!
I need help to create formula field on custom object which should be reffernce to Autonuber field on another custom object .
new object : order
field name : request number
object : Internal request
field autonumber : IN number
I have used this formula(text) :
request number =Internal_request__c.IN_Number__c
and the result was syntax error ??!
Means, there sould be lookup or master detail field available on object 'order' to object 'Internal request'.
but still there's syntax Error: Field Internal_Request_J__c does not exist ??!
How to solve this .
Second for autoNumber fields the return type is of formula is 'Text'.
Third to get value of autoNumber in number field you have write "Value(Internal_request__c.IN_Number__c)" in formula.
If you add fields using Insert field navigation then you will not get any error.
I created the formula as you mentioned "()" , but the formula appears on the field ?
Thank you .
appreciate your cooperation .
For confirmation can you test the same senario with Standard Objects, by creating autonumber on account and used it in Contact, then you will understand the problem.