I have a Formula query that is giving me the error message "Expecting Number."I expect that the field (159) is a number in my table. The record ID (108) should also be a number?Commented out on the attachment is the formula that I had copied out of the help areato start with. As I add "s" to the end of GetFieldValue or GetRecord - the errors change butdo not resolve my issue.Is there a Formula Query "guru" who can enlighten me on what I'm overlooking?Thanks,------------------------------Chad KragnessTimber Technologies, LLCYear 1 user (creator)------------------------------

There needs to be a query with a filter. Try this. i know the syntax is brutal to get correct.var text QUERY = "{3.EX.108}";// this converts to a numberToNumber( // this converts the result which is a "textlist" format to plain text.ToText( // this gets the Field values from field 159 GetFieldValues(this gets a set of records which meet the filterGetRecords($QUERY,[_DBID_TITAN_TIMBER_ITEMS]),159)))var text QUERY = "{3.EX.108}";ToNumber( ToText( GetFieldValues(GetRecords($QUERY,[_DBID_TITAN_TIMBER_ITEMS]),159)))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

I'm certainly no expert on queries so this is just an educated guess but - I suspect you are using a formula numeric field. I am surmising that the getfieldvalues call returns text no matter what. Someone else will have to confirm. So you are returining text. If you are sure it will only pull one value, wrap the whole thing in tonumber()------------------------------Mike Tamoush------------------------------

Thanks Mike,I tried ToNumber() and ToText() in a few places in the formula to no avail. I also tried changing the type of the filedfrom Formula-Numeric to Formula-Text as a trial and that doesn't work either.------------------------------Chad Kragness------------------------------

please post your code by copy paste so its editable.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

GetFieldValues(GetRecords(108, [_DBID_TITAN_TIMBER_ITEMS]), 159));//GetFieldValues(GetRecord(101, [_DBID_PROJECTS]), 5) sample from quickbase help.Thanks Mark.New to this forum stuff.------------------------------Chad Kragness------------------------------

Question on a Formula Query | Qrew Discussions

MikeTamoush
Qrew Commander
3 years ago
I'm certainly no expert on queries so this is just an educated guess but -

I suspect you are using a formula numeric field. I am surmising that the getfieldvalues call returns text no matter what. Someone else will have to confirm. So you are returining text. If you are sure it will only pull one value, wrap the whole thing in tonumber()

------------------------------
Mike Tamoush
------------------------------
- ChadKragness
  Qrew Member
  3 years ago
  Thanks Mike,
  
  I tried ToNumber() and ToText() in a few places in the formula to no avail. I also tried changing the type of the filed
  from Formula-Numeric to Formula-Text as a trial and that doesn't work either.
  
  ------------------------------
  Chad Kragness
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    please post your code by copy paste so its editable.
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Question on a Formula Query