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 save button to become hidden. I created a formula url button that will save it using this javascript I found on the forum: var text URL = "javascript:void(DoSaveAdd())";var Text Image = "<a id='saveButton' class='Vibrant Success' onclick='DoSaveAdd()' href='#'>Submit</a>";"<b href =" & $URL &">" & $Image & "</b>" My problem now is how do I get the page to redirect after the form is saved. Here?s a link to the form, you can try it and see what happens. https://sparkav.quickbase.com/db/bnzwm7ykp?a=nwr&ifv=20 I'd like it to redirect to an external webpage. If that is not natively possible than I'd like it to redirect to a rich text page I've created in quickbase. Any help with this would be greatly appreciated! Thanks, Elisha999Views2likes31CommentsHow to display PDF in file attachment fields
File attachment fields can show the attached files in forms and reports, but only a few file types are accepted (jpeg and such). Is there a way around this so that PDF attachments can be shown either directly in the form, or as a pop up window (I believe that is called an Iframe ?) after clicking on some button for that purpose? I now have that sort of working through a Chrome extension, which opens the PDF in another tab, but it's slow and cumbersome and has some unwanted side effects.400Views2likes62CommentsForm(s) on Home Page
I can't be the only one who is needing this, and maybe it is so simple that it is just too dumb to have on the forum, but I also have had a struggle looking through basic help on this. I would like to put an intake form, maybe even two forms, directly on the home page. Like bam! first thing. No click a button to go to a table. Just form first thing. I would like it to just say Thanks or can even go to a report or something afterwards, but I can get to that later. Again, simplest solution to the problem is best. This is not an open to the internet solution, but could be later. Swift help would be awesome. (I also wanted to put this out here so that others could have a solution as well)399Views1like7CommentsAdd child record through parent form and redirect back to parent form in edit mode
Hi, Is there a way I can add child record(s) when adding a parent record through a single form? I am trying to collect general info in the parent form and then have the ability to click a button to add a selected data source into the child table. Once that data source is added, it should automatically redirect me back to the parent form in edit mode as I left it and I should be able to add as many data sources as I want. I tried using a formula button which I found in the exchange, however, it only works as intended when editing a parent record. It doesn't work when adding a parent record because the record ID hasn't been created yet so it can't redirect back to the parent form in edit mode. Here is the code in the formula URL button that I currently use in the form to add a child record: var text redirect=URLRoot()&"db/"&Dbid()&"?a=er&rid="&[Record ID#]; // REDIRECT TO THE FORM IN EDIT var text url = URLRoot() & "db/" & [_DBID_PROVIDER_DETAILS] & "?a=API_AddRecord&apptoken=d4y5wt4betuct5khdpyxbvqp7p6&_fid_48=" & [Record ID#] & "&_fid_39=" & [Data Source 2] & "&_fid_25=" & [Brief description of data] & "&_fid_42=" & [Approx # Interfaces] & "&_fid_37=" & [Data Classification]; $url & "&rdr=" & URLEncode($redirect)Solved299Views1like19CommentsUsername to text field
I am working on a way to log changes to specific fields. I have created a history field that records all the information I want to track when it is changed into an entry in that field. My problem is there are 2 user fields that have Full Name in them and when I attempt to pull than information out and into the new History field it only prints some id number associated with that user, I want it to print the Full Name of the User. My history field is a multiline text field. Below is the action to my dynamic form rule. It states: When the record is saved Action change history to <br><b>Status:</b> [Status] <br><b>Changed by:</b> [Changed by] | <b>Changed Date:</b> [Date Changed]<br><b>Tested By:</b> [Tested by] | <b>Tested Date:</b> [Tested Date]<br><br> Again, everything in this prints beautifully with the exception of the [Changed by] and the [Tested by]. Here is what an output would look like: -- [OCT-23-14 4:19 PM Jordan] -------------- Status: New Changed by: -58508613 | Changed Date: 10-23-2014 Tested By: -58082747 | Tested Date: 10-24-2014 Any guidance is greatly appreciated.299Views0likes13CommentsAdd a button to open a specific form?
I have a table that everyone has access to. Lets call it "Products". For the purposes of this discussion, every role has the same access. I want to be able to add products through two separate buttons on the home page. The first is already there. It takes us to our current add form. We want to keep this. The second, is not. Right now we have it set up on the current add form through dynamic form rules, but you have to answer about 3 different drop downs before you get to it and it is confusing to users. What I want is to have a second button, that when clicked, takes you to a different form I have created to add these specific products. It would be the same for every role. Is this possible, without setting form rules with the roles? Every role would need access to both. ------------------------------ mtn mtn ------------------------------299Views0likes3Commentshow do I create a button that allows the user to continue to the next tab
We are creating a public form with multiple sections. Using the new tab section makes the form looks a lot neater, which is great, but there doesn't seem to be a way for us to indicate to the user where they are in the form and direct them to the next tab. Does anyone know how to create a button where the user can be redirected to the next tab? Or save and redirect to the next tab, or a field that is in the next tab? Also, this is a very noob question, but where can I find the url for my form which removes the Quickbase header and tabs? And how do I embedd the form into an iframe? If it's embedded in an iframe, when I look at it on a mobile, does it default to the QB mobile view? Thanks in advance199Views3likes27CommentsIs it possible to create a ""Save and Keep Working"" button from a formula URL field?
I realize the "Save and Keep Working" button was introduced by Quickbase, but I am wanting to add it somewhere in the middle of my form. I've seen posts relating to this kind of thing, but all of theme were published prior to the introduction of the "Save and Keep Working Button" and I can't seem to get any of them to work. Any thoughts?199Views7likes39Commentshow do I add a save button to a form?
Looking to add a save button to a form, I am sending the user to a Survey and want to embed a Save button at the bottom of the form in case the existing save button in the top right is not obvious enough. I am using this <button id="btnFormSaveDone" class="Vibrant Success" onclick="OnClickSave(kFormAndDone)">Save</button> And the result is "The text to be displayed here contains an event handler. Event handers are not allowed.199Views2likes20Comments