Forum Discussion

AmandaTorrisi's avatar
AmandaTorrisi
Qrew Trainee
5 years ago

Simple Redirect for EOTI

I have a customer survey form for EOTI to fill out. Ideally they would receive the link for the survey in an automatically generated notification from Quickbase. They would then be creating a new  record once the survey is filled out. 
My link to the survey is this: 
 (https://lightshipgroup.quickbase.com/db/bqsxvcdiv?a=nwr&preview=1&dfid=10&ifv=1)

Once the use clicks "submit" I would like them go get redirected to a .html page that I have set as the EOTI default page. In other apps, I have more complicated rich texts fields that accomplish this, as well as creating other records at the same time...but I can not get the more simple formula to just save and redirect to work! 

This is the formula I have now and it just says the page unrecognized: 
var text bgcolor = "#34A853";
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";
var text url =

"&rdr=&NextURL="&URLEncode("https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41");
"<a " & $style & " href=\"" & $url & "\">Submit</a>"

I feel like it is something simple that I am just missing!! Any help would be greatly appreciated. Thank you!



------------------------------
Amanda Torrisi
------------------------------
  • The link to the survey needs to have the Next URL as part of it


    "https://lightshipgroup.quickbase.com/db/bqsxvcdiv?a=nwr&preview=1&dfid=10&ifv=1"
    "&rdr=&NextURL="&URLEncode("https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41");

    Then 
    change this to  this to

    var text url ="https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41";

    I think that you have the table set to Save Parent automatically, so when  you navigate away, it will save the record.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • AmandaTorrisi's avatar
      AmandaTorrisi
      Qrew Trainee
      Perfect, that worked! Thanks so much!

      ------------------------------
      Amanda Torrisi
      ------------------------------
    • AmandaTorrisi's avatar
      AmandaTorrisi
      Qrew Trainee
      Ok I am just getting back to this after a week and I am losing my mind... the link works if I copy and paste into the browser but I am trying to make a button I can add to the form, and then the notification email. 
      Why does this not work as a url field? (I've also tried rich text/formula rick text. etc) 
      URLRoot()"https://lightshipgroup.quickbase.com/db/bqsxvcdiv?a=nwr&preview=1&dfid=10&ifv=1"
      "&rdr=&NextURL="&URLEncode("https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41"

      Ive also tried 
      URLRoot() "https://lightshipgroup.quickbase.com/db/bqsxvcdiv?a=nwr&preview=1&dfid=10&ifv=1"
      "&rdr=&NextURL="&URLEncode("https://lightshipgroup.quickbase.com/db/bj9qhjr75?a=dbpage&pageID=41");


      ------------------------------
      Amanda Torrisi
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Can you try removing the

        &preview=1

        Also, if you are in mobile mode I don't think you can redirect.    Mobile does support &rdr=

        will users be on phones?

        if so, a better way will be to have a View version of the firm which just displays a thank you message.

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