Forum Discussion

SteveLaurel's avatar
SteveLaurel
Qrew Cadet
5 years ago

Customer Feedback Survey

I am trying to replicate the process almost identical to this article:  Creating a Survey to Collect Data from Non-users
Quickbase remove preview
Creating a Survey to Collect Data from Non-users
At the end of each course in Quick Base University, our training team uses a Quick Base app that I created to collect feedback from our learners. Some of our leaners are users in our app and some are not.
View this on Quickbase >

This main difference is that I already have the record in QuickBase, not creating a new record.  I would like to take the %recLink% in an email notification and add &ifv=1 so not to show the QuickBase ui.

Can this be done?

Thanks



------------------------------
Steve Laurel
------------------------------
APIs and custom code
Button

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    yes, you can do this.

    The difference is that you are not creating a new record, you are editing a record

    So this line here

    https://team.quickbase.com/db/bneukue8v?a=nwr&ifv=1&_fid_22=ZZZZ  

    Would be replaced by

    "https://team.quickbase.com/db/bneukue8v?a=er&rid=" & [Record ID#]  


    In the EOTI Survey app I recently did, thus was the formula for the button which the user would click on in he email Notification.  All the fancy stuff is just to make a nice looking button.  The code itself is mostly adapted from one of Kirk Trachy's Magic Buttons



    // Begin button style
    var text bgcolor = "#6aa84f";
    var text txtcolor = "white";
    var text style = "style=\"text-decoration: none; width: 120px; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
    // End button style




    var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "&dfid=10&fullver=1&ifv=1"
    & "&NextURL=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=showpage&pageid=5" & "&fullver=1");

    var text Words =  "Open Survey";

    "<a " & $style & " href=" & $URL & ">" & $Words & "</a>"

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

      Now - do you happen to have a code snippet for the 1-10 scale? I just need 1-5.

      Thanks

      ------------------------------
      Steve Laurel
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        The famous Kirk Trachy, self proclaimed Quick Base Evangelist  and Quick Base Staffer has his Magic Buttons app available for download in the Exchange.

        This code here as a Rich Text field will allow the user to clock to select a Progress Bar for the % completion  on a project.

        If you like this behaviour we can figure out how to chop it down to a 5 button size.  You do not  need to use those chicklet squares for the images, there could be other images.

        var text star = "<img" & " src=\"" & "https://images.quickbase.com/si/16/228-rect_green.png\">";
        var text notstar = "<img" & " src=\"" & "https://images.quickbase.com/si/16/226-rect_gray.png\">";
        var number numberstars = (Floor([% Project Completed] * 10));
        var number numbernotstars = 10 - $numberstars;
        //10 is the number of units, because 10 is 1/10th of 100.

        var text urlten =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=10";

        var text urltwenty =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=20";

        var text urlthirty =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=30";

        var text urlforty =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=40";

        var text urlfifty =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=50";

        var text urlsixty =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=60";

        var text urlseventy =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=70";

        var text urleighty =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=80";

        var text urlninety =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_143=90";

        var text urlhundred =

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=d9eascudwjxs2sesxkjccwgtq9r" &
        "&_fid_28=Completed" &
        "&_fid_153=Completed" &
        "&_fid_143=100";

        "<span alt=\"" & ToText($numberstars) & " of 10 \" title='" & ToText($numberstars) & " of 10 ' class='NoWrap'>" &

        If($numberstars >= 1, "<a href=\"javascript:" & "$.get('" & $urlten & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlten & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 2, "<a href=\"javascript:" & "$.get('" & $urltwenty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urltwenty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 3, "<a href=\"javascript:" & "$.get('" & $urlthirty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlthirty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 4, "<a href=\"javascript:" & "$.get('" & $urlforty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlforty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 5, "<a href=\"javascript:" & "$.get('" & $urlfifty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlfifty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 6, "<a href=\"javascript:" & "$.get('" & $urlsixty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlsixty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 7, "<a href=\"javascript:" & "$.get('" & $urlseventy & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlseventy & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 8, "<a href=\"javascript:" & "$.get('" & $urleighty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urleighty & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 9, "<a href=\"javascript:" & "$.get('" & $urlninety & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlninety & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        If($numberstars >= 10, "<a href=\"javascript:" & "$.get('" & $urlhundred & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$star&"</a>",
        "<a href=\"javascript:" & "$.get('" & $urlhundred & "', function(){" & "location.reload();" & "});" & "void(0);\">"&$notstar&"</a>") &
        "</span>"

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