Forum Discussion

JakeRattner1's avatar
JakeRattner1
Qrew Cadet
4 years ago

URL Button to change forms, check box and redirect back to original record.

Hi Everyone, 

I'm trying to create a Formula-URL field which, when pressed, switches the form and checks a box on that same record, then returns to the original record..

I have a URL button that can go to a new form in edit and, once saved, it will redirect back to the original form: 
URLRoot() & "db/" & Dbid() & "?a=er&dfid=24&rid=" & [Record ID#]& "&z=" & Rurl()

Then this is what I would expect to use to check a box:
URLRoot() & "db/" & [_DBID_RFP___SITES] & "?a=API_EditRecord&rid="&URLEncode ([Record ID#])& "&_fid_665=1"&"&rdr="&URLEncode( URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl())

However, when I try to combine them I either get stuck at the api results (no redirect), it opens a new record or only checks the box and doesn't go to the new form.  

Any suggestions would be amazing.

Thanks!




------------------------------
Jake R
------------------------------

APIs and custom code
Buttons
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Jake, when you say 

    "checks a box on that same record", do you mean to put he record into edit mode and check a box and and leave the user sitting in edit mode until they save.

    if so, there is no a way to do that unless you are willing to first edit the record to check he box and then land the user in edit mode with the checkbox checked and saved in the database.   That will mean that if the user abandons the record and never saves, that the checkbox will still be checked.  

    In other words it is not possible to put up an Edit Record form and pre populate certain fields.






    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JakeRattner1's avatar
      JakeRattner1
      Qrew Cadet
      4 years ago

      Hi Mark, 

      Thanks for the response.  Apologies for the sloppy wording.  It's actually neccessary that the box be checked prior to moving to the new form.  Would that order of operations make this possible within QB?



      ------------------------------
      Jake R
      ------------------------------