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

Question

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 but found number". The number is correct; why is it expecting text?

chayceduncan2 · Answer

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

quickbasecoachd · Answer

If the formula does save OK&nbsp; and you are just referring to the yellow triangle warning in the formula editor, sometimes that formula editor is not 100% correct in its warnings, ie it may be a false alarm.

Forum Discussion

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

2 Replies

Related Content

Multiple reference proxy fields help

Same reference field, different selections within the form

Formula Not Functioning as Expected

Formula URL - Edit then Add

Rich Text formula 'expecting text' at the end of formula

Recent Discussions

Extrapolating nuanced data

Filter Monthly, Quarterly, Yearly from one Date field

Forms help

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record