Button to open Code Page and pass record data to Code Page

Question

Button to open Code Page and pass record data to Code Page

Can anyone share a method to do this? I have a custom form that works great for creating new records. I want to be able to give the users the ability to then view that record in the same format that they entered the record. I know this is possible with javascript, but is this possible without javascript?

------------------------------
Adam Keever
------------------------------

adamkeever1 · Answer

@Sharon Faust, thanks so much for posting this. I am going to see if I can get it functioning on my end.​------------------------------Adam Keever------------------------------

quickbasejunkie · Answer

@Adam Keever I know we're also discussing the Slack channel, but I didn't want to leave this post hanging.​I would suggest passing your desired redirect as part of the URL and using it in place of the referrer... which should help with the loop. (I'm using chrome, and have not experienced a looping issue with the code)Also, this is only intended to use with a previously saved record as it needs the Record ID to function.Something along the lines of this:FORMULA - URL:URLRoot() &amp; "db/" &amp; AppID() &amp; "?a=dbpage&amp;pageid=17" &amp; // code page"&amp;url=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=printr&amp;dfid=10&amp;rid=" &amp; [Record ID#]) &amp; //passed to code page for print window"&amp;rdrurl=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;rid=" &amp; [Record ID#])//passed for final redirectCODE PAGE:&lt;!DOCTYPE html&gt;&lt;html&gt;&lt;head&gt;&lt;script&gt;var urlParams = new URLSearchParams(window.location.search);var url = urlParams.get('url');var rdrurl = urlParams.get('rdrurl');window.open(url,'Print','width=800,height=700');window.location.href = rdrurl;&lt;/script&gt;&lt;/head&gt;&lt;/html&gt;------------------------------Sharon Faust (QuickBaseJunkie.com)Founder, Quick Base Junkiehttps://quickbasejunkie.com------------------------------

quickbasejunkie · Answer

Here you go! I plan to make a video on this topic soon.

This particular formula/code page passes a URL to display a specific form to a pop-up print window, then returns the user to the page they were on.

This would replace the 'onclick' use in a rich text formula field. Additional parameters (name=value) can be passed they just need to be separated with a "&".

FORMULA - URL:
URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=17" & // code page
"&url=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=printr&dfid=10&rid=" & [Record ID#])//passed to code page for print window

CODE PAGE:
<!DOCTYPE html>
<html>
<head>
<script>
var urlParams = new URLSearchParams(window.location.search);
var url = urlParams.get('url');
var referrer = document.referrer;
window.open(url,'Print','width=800,height=700');
window.location.replace(referrer);
</script>
</head>
</html>

Let me know if this works for you 👍

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------

adamkeever1 · Answer

It works on my end, but results in an endless loop of page reloads. I have to close the page to get it to stop.

@Sharon Faust and @Ryan Pflederer any suggestions?

------------------------------
Adam Keever
------------------------------

adamkeever1 · Answer

@Sharon Faust thanks for the feedback. I use Chrome too. Once I killed the page in which I pressed the button, the print window stopped refreshing. I appreciate your suggestion.------------------------------Adam Keever------------------------------

Forum Discussion

Button to open Code Page and pass record data to Code Page

5 Replies

Related Content

Previous and Next Record Buttons

Formula URL Button to Open New Form and Check a Box

Button to Add Record via Pipeline, and refresh Record

Add button to create record in different app

New Form - Show Create Record button