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, ElishaForm(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)
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.
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 ------------------------------
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.
Is 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?
Formula to look up a corresponding field from a related table?
I'm a new QuickBase user. This is probably a simple question, but I don't know how to construct a formula to look up a corresponding field from a related table. I have a parent table and a child table with a one-to-many relationship. The child table contains only two fields: Code and Description. There are thousands of records in the child table, each containing a Code and a corresponding Description. The parent table has a form. One of the fields in the form allows users to manually enter a Code. Another field in the form -- which is a text formula field -- is where I want to enter a formula that will return the corresponding Description based on the Code entered in the first field. Both the Code and Description fields from the child table are part of the relationship to the parent table. I'm not sure what functions in Quickbase will produce the desired result. I've scoured online help, the knowledge base, the community, etc. for several hours. The closest I've come is finding a response saying yes, QuickBase can do this, but no instructions on how. Can someone please help? Thanks in advance.Suggestion to work around when ""Report too large. Maximum number of bytes in report exceeded"" error?
I want to queried all data from a table/report to save it into a local database. I've tried to export it into CSV format, however, got the problem as attached image. Please suggest ways to overcome it with: no filter applied one extracted data file only (like a svn dump file) I've read QB HTTP API and wonder if it can help to over come the "too large" issue?
