Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

URL button not showing on reports

I am trying to create a button on a report on my resource table for each employee in my company to set them as a filter.  For some reason the button is blank even though I have display as a button checked.  Here is the code in case it is a code issue.  Any ideas?

URLRoot() & "db/" & [_DBID_PROJECT_SOLUTIONS_REPORTING_FILTER] & "?a=API_EditRecord" &
"&rid=1" &
"&apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &
"&_fid_6=" & URLEncode([Email]) &
"&rdr=" & URLEncode(URLRoot() & "db/bpmjsbsnt?a=showpage&edit=1&pageid=24")

------------------------------
Ivan Weiss
------------------------------
APIs and custom code
Button
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    Ivan,

    Any chance you cleared the box for the Text?



    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      Nope, I have something in there.

      ------------------------------
      Ivan Weiss
      ------------------------------
  • JasonJohnson2's avatar
    JasonJohnson2
    Qrew Cadet
    6 years ago
    Move the app token down one line before the "&rdr

    ------------------------------
    Jason Johnson
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      Why would that matter?  I typically put the apptoken first.  The order matters?

      ------------------------------
      Ivan Weiss
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        I actually do not think that it matters.  It is actually bizzare that the link is blank.  That usually only happens if there is an error in the formula.  I would be happy to look at your app myself if you want to contact me off line.  Alternatively, what I would do is to make a new formula URL field (do not copy this one) and copy and paste in the formula.  Maybe that field got corrupted or confused somehow.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------
  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    Qrew Commander
    6 years ago
    Hey Ivan,
    I'm happy to see you're using your new API button skills!
    This one has me a bit baffled too as I don't see any obvious issues with the formula.
    If you still can't get the button to appear, send me an email :-)

    ------------------------------
    Quick Base Junkie (find me on YouTube)
    Founder
    Quick Base Junkie
    CA
    ------------------------------
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    When I use your code, field titles, and put 'something' in the link text label field the button shows up and works for me:


    It replaced fid6 with [Email] and directed me to a page in "Customize this Page" mode when clicked.

    Any chance your issue is related to permissions:

    Or maybe it is being hidden by a dynamic form rule?


    ------------------------------
    Adam Keever
    ------------------------------
    • IvanWeiss's avatar
      IvanWeiss
      Qrew Captain
      6 years ago
      Low and behold an embarassing one and sorry to waste the time!

      I accidentally duplicated the field and used the wrong one on the report grrrr!

      ------------------------------
      Ivan Weiss
      ------------------------------
      • QuickBaseJunkie's avatar
        QuickBaseJunkie
        Qrew Commander
        6 years ago
        It happens to the best of us... glad you figured it out!

        ------------------------------
        Sharon Faust (QuickBaseJunkie.com)
        Founder, Quick Base Junkie
        https://quickbasejunkie.com
        ------------------------------