Discussions

 View Only
  • 1.  Expecting a text but found number"" URL Encode()

    Posted 04-03-2018 17:38
    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.

    Thoughts? 


  • 2.  RE: Expecting a text but found number"" URL Encode()

    Posted 04-03-2018 17:49
    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.


  • 3.  RE: Expecting a text but found number"" URL Encode()

    Posted 04-03-2018 21:12
    Sorry to report, but you've run into a bug.   

    QBE012336: Formulas are showing non-errors now