Formula URL button - save and redirect
Hi there I?ve created a form accessible to ?everyone on the internet? for our clients to submit service requests. I added ?&ifv=20? to the url to hide the qb branding. However, doing this causes the...
Forum Discussion
Hi there
My apologies for the delayed response. I'm new to javascript & quickbase and at the time of my initial posting these responses were beyond my skill level.
I've advanced a little and decided to give these solutions another go. I�m not sure how & where to plug in these different lines of code.
I tried putting Dan�s code
1) directly into a formula-url field and I get a syntax error.
2) directly into a formula-rich text I�d be redirected to ibm.com whenever I viewed a record
3) into a javascript page and loading it via iol and it would save the record but the redirect wouldn�t work
Similar challenges with Sharons & QBChampions solutions. I'm no sure how/where to put together and plug in the code.
I've had a bunch of success using some IOL scripts for other issues.
Any guidance on how to plug in your answers?
Thanks!
- @Elisha
My suggestion was this
Do not make a custom save button, but rather have the user launch the Add Record off this formula URL button
var text ADD = URLRoot() & "db/" & [_DBIDxxxx] & "?API_GenAddRecordForm":
var text RedirectTo = the url to redirect to;
$ADD
& "&NextURL=" & URELEncode($RedirectTo )
You can build that button on a any record and copy the generated code and paste it into a dashboard button. The formula with them calculate the URLEncoding. - Both my and Mark's (QB Coach) suggestions work in the Formula URL field.
Here is the formula I suggested more explicitly written out using your inital formula as a base:
var text URL = "javascript:void(DoSaveAdd())";
var text URLTWO = URLRoot() & "db/" & Dbid() & "?a=dbpage&pageID=3";
var Text Image = "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit</a>";
"<b href =" & $URL & "&rdr=" & $URLTWO &">" & $Image & "</b>"
(where the pageID=3 is replaced with your pageID).
-Sharon- Never mind! I found another post that explained how to create a formula-rich text field that acts as the "Save & Keep Working". I just updated the URL to include the form ID to get what I needed. Here's the post for anyone else who's interested.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=d959cde4-8af7-4499-b793-c3f8807c57cd&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer
------------------------------
Brittany Scheid
Special Projects Manager
SimiTree
------------------------------- @Brittany Scheid I'm glad you found a solution.
I also have a video that covers the "SaveBeforeNavigating" class (about halfway through the video below) that might be helpful to you or others. AND if you want to learn even more about building buttons in Quickbase I'd recommend The Button Masterclass.
------------------------------
Quick Base Junkie
Quick Base Junkie
https://quickbasejunkie.com
------------------------------
- @Quick Base Junkie What field type does this code get used in? When I tried both Formula-URL & Formula-Rich Text, I received syntax errors saying javascript was not allowed. (screenshot below). I've included my code below as well.
My scenario is that I'm actually not saving a parent record, but wanting to save the record being edited, and bring up that same record but in a different form. Almost like the "save & keep working" but using a different form. Would turning on the "Save parent record automatically when a child record is created" option address this too, negating the need for the javascript?
var text URL = "javascript:void(DoSaveAdd())";
var text URLTWO = URLRoot() & "db/" & [_DBID_EVENTS] & "?a=er&dfid=12&rid=" & [Record ID#];
var Text Image = "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit</a>";
"<b href =" & $URL & "&rdr=" & $URLTWO &">" & $Image & "</b>"
------------------------------
Brittany Scheid
Special Projects Manager
SimiTree
------------------------------
