Formula Query expecting number but found text
I'm new to writing formula queries and keep running into type mismatches. I'm figuring bonuses for our technicians, and have the bonus rate stored on another table. var text myquery= "{8.EX.'"&[U...
Forum Discussion
I tried this but unfortunately it still does not work. The variable seems to be the problem, as $myquery is highlighted in the formula.
------------------------------
Anne Martin
------------------------------
------------------------------
Anne Martin
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendPlease post a copy and paste your formula text and also the error message
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- Is this what you're asking for?
//Tech Codes FID 8 = technician, FID 17 = bonus rate
var text myquery= "{8.EX.'"&[User to text]&"'}";
ToNumber(
ToText(
Getfieldvalues(getrecord($myquery,[_DBID_TECH_Info]),7) ))
------------------------------
Anne Martin
------------------------------- MarkShnier__YouChange GetRecord to GetRecords
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Thanks, Blake & Mark. That worked!
------------------------------
Anne Martin
------------------------------