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 thesavebutton 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 thepage to redirect after theform 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, Elisha
How 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.
Username 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.
Add 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 ------------------------------
Historical Date Change Tracking
I am trying to set up a date field that has changed logged within the form, similar to text fields. Is this possible in Quickbase, maybe using a formula? We are tracking target completion dates. These sometime change, but we want to track how often the target has moved and we want that visible in the form (hence not wanting to use pipelines to achieve this and tracked in a separate report). Any suggestions/solutions? The current field is Date/Time, which does not allow logging.
Create a button that displays an embedded report from a different table
Hello, I want to create a button that displays an embedded report from a different table that is related to what's on the current record. I want a button to go in the green circle and open that report that's embedded and related to that unit. Thank you! And I'm such a novice, so please be elementary with me :) ------------------------------ Renee Hansen ------------------------------Form(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)
Creating a duplicate of the same record in Quick Base
Hello, I just wanted to ask if there is a functionality in Quick Base that allows creating of duplicate records. For example, I have a table named 'Potential Team' and a record in the table is called 'Team.' Now, let's say Record#001 contains a thousand fields containing the names of different member (Member 1, Member 2..Member 999). Is there a way in Quick Base that allows me to re-create/copy the same record including all the data inputted in the fields? It would also be better if there is some sort of button/checkbox in the original record named "Copy record" that will trigger to create this duplicate. Thank you for the help!
