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

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
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?
Photo of Jamie Owens-Knight

Jamie Owens-Knight

  • 72 Points

Posted 1 month ago

  • 0
  • 1
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 |
Quandary Knowledge Base
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,724 Points 50k badge 2x thumb
If the formula does save OK  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.