Forum Discussion

JimHarrison's avatar
Qrew Champion
7 years ago

Expecting a text but found number"" URL Encode()

This URL Formula shows an alert triangle on the left and displays Column: 89 > "Expecting a text but found number". 

URLRoot() & "db/" & [_DBID_SITE_WALKS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([Record ID#])& "&_fid_11="& URLEncode ([Related Job # Log])& "&dfid=10"& "&z=" & Rurl()

Column 89 is the start of "URLEncode ([Record ID#])" and [Record ID#] is underlined. 

It seems like URLEncode is not working like it once did. Removing URLEncode appears to make the formula checker happy. 

Is this a defect of the formula checker or can we remove the URLEncode function? Both appear to work as expected but I haven't tested extensively.


2 Replies

  • If the formula checker is giving a warning but the formula saves OK, then all you can do is to report a bug to Quick Base for the formula checker.
  • Sorry to report, but you've run into a bug.   

    QBE012336: Formulas are showing non-errors now