Discussions

Expand all | Collapse all

Customer Feedback Survey

  • 1.  Customer Feedback Survey

    Posted 25 days ago
    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
    ------------------------------


  • 2.  RE: Customer Feedback Survey

    Posted 25 days 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
    ------------------------------



  • 3.  RE: Customer Feedback Survey

    Posted 18 days 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
    ------------------------------



  • 4.  RE: Customer Feedback Survey

    Posted 18 days 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
    ------------------------------



  • 5.  RE: Customer Feedback Survey

    Posted 18 days ago
    In the code above, there a numeric Percent field being updated called [% Project Completed] 

    with field ID# 143.


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