+ Start a Discussion
kevindotcarkevindotcar 

Formula fields on SOQL lookup

Hi gang

I have a user that created a custom object that has a formula field.
I'd like to program a lookup on this field, but my SOAP message return is always saying
"<sf:exceptionCode>INVALID_FIELD</sf:exceptionCode>"

and pointing the little carat-thingy underneath the field name.
My first question is if it's even allowable for us to look at furmla fields.

Thanks in advance

KC

KingsleyKingsley
You may have doen this already, but do you have the "__c" suffix added to the field name?
kevindotcarkevindotcar

Hi-

Yes- 
to make matters weirder, I did a "DescribeSObject" call on the object and the field doesn't show up.

I don't see anything in the API reference that says there's anything different about Formula fields, but darned if I can't see the darn thing.

KC
KingsleyKingsley
Does the sforce Explorer show the field?
BWMoonBWMoon
We are having a similar issue with feeding a text formula feed through, and it is not showing up in the SFORCE EXPLORER.