Forum Discussion

NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago

Making a simple mistake on rich text URL

I seem to be making a somewhat simple mistake on a rich text field that I can't seem to get figure out. The field generates a QR code which, when scanned, adds a record to another table and populates some fields in that table. 

My code is below:

"<img src=\"http://chart.apis.google.com/chart?chs=200x200&amp;cht=qr&amp;chld=|0&amp;chl=" & URLEncode(URLRoot() & "db/" & [_DBID_INVENTORY_PRODUCTS] & "?a=API_GenAddRecordForm&_fid_8=" & [Order - Expected Inventory Record ID#]) &
"&_fid_12=" &URLEncode([Product Name])

& "\" alt=\"Scan to add a ticket\" title=\"Scan to add a ticket\"/>"

The code above works fine from a syntax perspective and even populates FiD 8 has intended, however, it's not populating FiD 12. Both FiD 12 and [Product Name] are the same field types of Text fields.

------------------------------
Niraj Shah
------------------------------
APIs and custom code
Formulas and functions
  • NirajShah4's avatar
    NirajShah4
    Qrew Cadet
    5 years ago
    I recreated this as just a URL - formula field and it works as intended - but I really need it to be a QR code..

    Code for the formula URL:

    URLRoot() & "db/" & [_DBID_INVENTORY_PRODUCTS] & "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Order - Expected Inventory Record ID#]) &
    "&_fid_12=" &URLEncode("test") &
    "&_fid_6=" & Now()
    & "&z=" & Rurl()



    ------------------------------
    Niraj Shah
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    I think that the issue has to do with this part


    & "\" alt=\"Scan to add a ticket\" title=\"Scan to add a ticket\"/>"

    try getting it to work without that line or else just ending with 

     & ">"



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • NirajShah4's avatar
      NirajShah4
      Qrew Cadet
      5 years ago
      Thanks, Mark.

      When I do that, the code is accepted, however no QR code image appears. My code is below and my image is attached

      "<img src=\"http://chart.apis.google.com/chart?chs=75x75&amp;cht=qr&amp;chld=|0&amp;chl=" & URLEncode(URLRoot() & "db/" & [_DBID_INVENTORY_PRODUCTS] & "?a=API_GenAddRecordForm&_fid_8=" &URLEncode ([Order - Expected Inventory Record ID#])) &
      "&_fid_12=" &URLEncode([Product Name]) &
      "&_fid_6=" &Now() &
      "&z=" & Rurl()

      & "/>"




      ------------------------------
      Niraj Shah
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        try this
        "<img src=\"http://chart.apis.google.com/chart?chs=75x75&amp;cht=qr&amp;chld=|0&amp;chl="
        & URLRoot() & "db/" & [_DBID_INVENTORY_PRODUCTS] & "?a=API_GenAddRecordForm&_fid_8=" &URLEncode ([Order - Expected Inventory Record ID#])) &
        "&_fid_12=" &URLEncode([Product Name]) &
        "&_fid_6=" &Now() &
        "&z=" & Rurl()

        & "/>"

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------