Forum Discussion

Qrew Member

6 years ago

Formula error: Expecting text but found number in numeric reference formula field

I have a numeric reference field with the following formula: [Pharmacy / Drug Shipping - Record ID#] And I'm receiving an error with the entire formula underlined in red stating "Expecting text ...

App builders

Formulas and functions

Tables and fields

ChayceDuncan2

Qrew Cadet

6 years ago

Is your field type formula-numeric? Sounds like the error you would receive if the formula you have is text? Does wrapping it in a toText() resolve it?

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

Forum Discussion

Formula error: Expecting text but found number in numeric reference formula field

Related Content

Parent to Child Reference Field

Empower exceeded all expectations!

Reference tables quandary

Tracking References and Definitions

Multiple reference proxy fields help