I have a button that sits on a report that is on a user page that creates pop up to a special form that also has a button that that acts on a checkbox and then refreshes the page.Here is my formula that sits on the pop up form:var text Update = URLRoot() &"db/" & Dbid() & "?act=API_EditRecord"& "&rid=" & [Record ID#]& "&_fid_1046=1";var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();If([Ready for Dispositions]=false,$Update& "&rdr=" & URLEncode($RefreshPage))What do I need to add to my formula to close the pop up after the button is clicked?------------------------------George Bramhall------------------------------

Not sure if I was clear. I want the button on the form to update the record (check a checkbox) and then close the form (pop-up)------------------------------George Bramhall------------------------------

I think that this would require a code page. But I'm not that kind of a coder.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

If you go to this link:https://resources.quickbase.com/db/bq8kmgrcqThen click on the examples. The second example is titled : Add Child in Popup w/ Auto Close on Save - Rich TextIt gives you a code page, and then a NextURL statement to call that code page. Admittedly, I haven't tried it, but I told myself I need to experiment with that as soon as I have the need again!To me, this solution only will work in instances where &NextURL will work. I know NextURL works in conjuction with the add record api, but not sure about edit record?------------------------------Mike Tamoush------------------------------

Ok I built the close window page per the site you shared.butI get this error <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>7484</rid> <num_fields_changed>1</num_fields_changed> <update_id>1645809864144</update_id> </qdbapi>...when I click the rich text button with this code:var text Update = URLRoot() &"db/" & Dbid() & "?act=API_EditRecord"& "&rid=" & [Record ID#]& "&_fid_1046=1";var text RefreshPage = "&NextURL=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=21&z=");"<a class='Vibrant Danger OpenAspopup' href='" & If([Ready for Dispositions]=false,$Update& $RefreshPage)& "' data-height=500 data-width=500 data-refresh=true title='Clicking this button will open a popup'>Confirm EM/DD Removal</a>"and pop doesn't close.Any ideas? ------------------------------George Bramhall------------------------------

Technically as it says there is 'no error' which likely just means the redirect (close pop up) is not working. My guess is you have pageid 21 in your code. That is the page id from the sample code. Be sure that matches what your actual code page id is. Hopefully that will fix it. Like I said, I haven't actually tested this myself so I can't confirm it even works, but it looks promising. Let me know if fixing the code page works! Oh, also I dont think you need the &z= at the end. The sample shows it ending after the 21 (or your code page number)------------------------------Mike Tamoush------------------------------

Close a pop up form after a button is clicked on the form

16 Replies

GeorgeBramhall2
Qrew Cadet
3 years ago
Not sure if I was clear. I want the button on the form to update the record (check a checkbox) and then close the form (pop-up)

------------------------------
George Bramhall
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  I think that this would require a code page. But I'm not that kind of a coder.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - MikeTamoush
    Qrew Commander
    3 years ago
    If you go to this link:
    
    https://resources.quickbase.com/db/bq8kmgrcq
    
    Then click on the examples. The second example is titled : Add Child in Popup w/ Auto Close on Save - Rich Text
    
    It gives you a code page, and then a NextURL statement to call that code page. Admittedly, I haven't tried it, but I told myself I need to experiment with that as soon as I have the need again!
    
    To me, this solution only will work in instances where &NextURL will work. I know NextURL works in conjuction with the add record api, but not sure about edit record?
    
    ------------------------------
    Mike Tamoush
    ------------------------------

Forum Discussion

Close a pop up form after a button is clicked on the form