Discussions

 View Only
  • 1.  Simple Redirect for EOTI

    Posted 09-18-2020 10:57

    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
    ------------------------------


  • 2.  RE: Simple Redirect for EOTI

    Posted 09-18-2020 11:10
    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
    ------------------------------



  • 3.  RE: Simple Redirect for EOTI

    Posted 09-18-2020 14:04
    Perfect, that worked! Thanks so much!

    ------------------------------
    Amanda Torrisi
    ------------------------------



  • 4.  RE: Simple Redirect for EOTI

    Posted 09-28-2020 09:14
    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
    ------------------------------



  • 5.  RE: Simple Redirect for EOTI

    Posted 09-28-2020 09:24
    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
    ------------------------------



  • 6.  RE: Simple Redirect for EOTI

    Posted 09-28-2020 09:39
    I do not know how to remove the quickbase interface but leave the save button.... I had to create a submit button, and when I remove the redirect part from the survey url, the submit button no longer works. I could try to figure out how to add a thank you message if they select save and close (if I could figure out how to get save and close back on the page, while still hiding the rest of QB interface)... I feel like this is simple and I am just complicating it!

    ------------------------------
    Amanda Torrisi
    ------------------------------



  • 7.  RE: Simple Redirect for EOTI

    Posted 09-28-2020 10:16
    In your post above you had a URLRoot() in front of the coder that does not belong.  That will cause a syntax error.

    Will this be used in Mobile mode?  The last time I tried to get EOTI working I was unable to get a perfect user experience if I needed the Quick Base Branding and headers all removed and needed a solution which worked well in desktop and mobile mode..

    If you set the Advanced properties of the tale to save parent automatically when a child is created, what that actually does is to auto save when you navigate away form the page. 

    That would allow you to simply have a button to navigate to your dashboard page on the form.

    So the button to get to your EOTI form would be

    URLRoot() & "/db/bqsxvcdiv?a=nwr&dfid=10&ifv=1"

    and then the Submit button would be just be 

    URLRoot() & "db/" & AppID() & "a=showpage&pageid=5"

    But in Mobile mode you will not be able to suppress the native Save button  So the best I think that you can do if your users end up in mobile mode is to have a thank you form which is specified as the View form for EOTI Role and to set the form not to show build in fields and to have a Rich text formula field as a thank you message. Maybe a link to get to your Rich text page on the view form. 

    The issue in mobile seems to be that you cannot suppress the native save button which means that userswill land back viewing that record that they just entered. 



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