Close a pop up form after a button is clicked on the form
I have a button that sits on a report that is on a user page that creates pop up to a special form that also has a button that that acts on a checkbox and then refreshes the page. Here is my formula that sits on the pop up form: var text Update = URLRoot() &"db/" & Dbid() & "?act=API_EditRecord"& "&rid=" & [Record ID#] & "&_fid_1046=1"; var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); If([Ready for Dispositions]=false,$Update & "&rdr=" & URLEncode($RefreshPage)) What do I need to add to my formula to close the pop up after the button is clicked? ------------------------------ George Bramhall ------------------------------100Views0likes16CommentsLookup and fill field values based on the content of another table
I have two tables: Table A holds records for daily delivery routes, two of its fields are the [Driver Name] and [Van ID]. Table B holds records of every stop completed on all daily routes, it also has the fields [Driver Name] and [Van ID]. The stop records in Table B are imported via an API call to a platform which records GPS tracking data for each van. The [Van ID] is obtained with the call, but the [Driver Name] cannot be. What I want to do is for every record in Table B, where the [Van ID] = "123", for example, I want to lookup in Table A which delivery route had [Van ID] = "123" and find the associated driver name, and show it in the Table B record(s). Has anyone had any experience with a problem like this? Thanks100Views2likes10CommentsQuickbase Code page to query a table and display records
I have created a code page which should query a table and display certain records using API -GenResults table. I am going to embed this code page in forms. Based on value in each record(in field - test temp inventory query) the contents in the table changes. Below is the code page code <html> <head> <script src= ~test temp inventory query~ lang="text/javascript"> </script> <style> td.m { font-family:verdana; font-size:70%; } td.hd { font-family:verdana; font-size:70%; font-weight:bold; color:white;} </style> </head> <body> <h1>Example</h1> <table cellpadding=5 bgcolor=lightgreen> <tr> <td> <script lang="text/javascript"> qdbWrite(); </script> </td> </tr> </table> </body> </head> </html> The third line, value of src determines the query. ~test temp inventory query~ is the field where query is created as a formula text . The value in formula text looks something like this https://Domain.quickbase.com/db/iddbdbdbid?a=API_GenResultsTable&apptoken=tokn123 t=1&query={'29'.CT.'TYCU700'}OR{'29'.CT.'TYRD60'}OR{'29'.CT.'TYTG8580'}&clist=29.17.7.9.8.38.44.49&slist=17 But the contents are not getting pulled correctly. Which is best way to pass value in field to the QuickBase code page and display the link to code page as embedded in the same form. ?100Views0likes5CommentsCustom Save and Close button
Hello everyone, This is probably a super simple solution but for the life of me I have not been able to get it to work. I am trying to create a custom button that simply saves the record on a form that has both the parent and the child records in edit mode. Example: A parent record form has an embedded grid of related child records. When the parent record is in edit mode, the grid of child records is editable, so that the user can add or modify the related child records. At this point, the parent record has already been saved, so the record ID of the parent already exists. All I want my button to do is to save any changes made to both/either the parent or the child records. I want this button to work exactly like Quickbase's native "save & close" button. Thanks in advance for your help! ------------------------------ Juan Solorio ------------------------------99Views0likes5CommentsButtons, Buttons, Buttons - (new code for all!)
Hello all, Sorry I haven't gotten around to putting out some nice code goodies, but today is a new day full of buttons for you. So here you go! This basic gray button saves your work and then sends you to a code page. - It is good for saving and then a thank you page or you can alter it to go to another form. Just plop it in a Rich TextFormula Field and you are ready to go. Pretty slick. "<a class='Vibrant Snowy SaveBeforeNavigating' href='https://mysite.quickbase.com/db/tableIDhere?a=dbpage&pageID=12&ifv=10'>Save & Logout</a>" This next little bit of code really can be used for any link or button, and is a life saver for those of us dealing with the EOTI role. This is a special encoding that QB can understand. I have it here encoding the Record ID#, but you can use it for any number. ENCODING: &r=" &QB32Encode([Record ID#]) URLRoot() & "db/" & [_dbid_table] & "?a=dr&r=" & QB32Encode( [Record ID#]) Have you ever just wanted to click a button and save something as a csv? Yeah, me too. So I did. This one can take a bit of set up (or not) depending on if you want to download a filtered report or not. First I make a report (qid=59 in this case), then I make a bunch of "ask the user" filters (V0, V1, V2,...). This would be a filter where you would say, filter by Shirt Size and instead of putting 'equals Red' in the report, you would put 'equals <ask the user>'. Then you would put whatever you were wanting to filter for the report into the code below. This is great for dynamic reports. But back to the CSV. As you can see on the end, there is '&options=csv'. It really is that easy. Just plop this is a URL Formula Field and make yourself a button. https://myebsite.quickbase.com/db/tableID?a=API_GenResultsTable&qid=59&nv=3&v0=MyFirstFilter&v1=MyNextFilter&v2=MyOtherFilter&options=csv Looking for an alternative to using the Record ID# in your links / buttons. Yeah, who wants to use the Record ID# when your key field is your email? I sure don't, and I'm just lazy enough to make it work. The key is the 'Key' field. Below I have an example of a button that saves what the applicant is working on in one form and then navigates them to edit their parent record by looking up their email. In the parent table, the Key is Applicant Email, so it can use the Applicant Email Address from the child table (the application that they are working on) to find the parent profile record. Just throw this button into a Rich Text Field and you're done. "<a class='Vibrant Success SaveBeforeNavigating' href='https://mywebsite.quickbase.com/db/tableID?a=er&key="&URLEncode([Applicant Email Address*])&"&ifv=10'>Edit Applicant Profile</a>" And last of all, a nice list of the "Vibrant" button set: List(" ", "<a class='Vibrant'>Vibrant</a>", // regular grey button "<a class='Vibrant Alert'>Vibrant Alert</a>", // yellowish "<a class='Vibrant Danger'>Vibrant Danger</a>", // red "<a class='Vibrant Primary'>Vibrant Primary</a>", // blue "<a class='Vibrant Snowy'>Vibrant Snowy</a>", // white "<a class='Vibrant Success'>Vibrant Success</a>" // also blue, but they clain green ) Super Secret Bonus Code: Gradient Background (can be used in buttons and code pages!) background-image: linear-gradient(220deg, #1e6fb7 50%, #5086b5 80%); ------------------------------ QuickBase Girl ------------------------------99Views2likes1CommentLooking for simplest example to access quickbase using python
Can someone point me to examples that show how a quickbase/db can be accessed from the command line/using python -? We would like to access, add, delete, change records and create reports - and in addition to the GUI provided, do such using CLI tools and python (saw pybase on github, am having some difficulty with it - unless someone can provide a complete example -?)99Views2likes22CommentsFormula-URL button with API_AddRecord, then API_EditRecord (need to edit the record just added)
I am working with two tables: Parent Table: Work Orders Child Table: Status History I have a formula-URL button that is supposed to do multiple things: Add a record in the Status History table: [Type]=Work Order Status, [Status]=Closed, [Status Changed By]=Current User If [QC/QA Status] Contains "QC/QA Fail", then Add a record in the Status History table: [Type]=QC/QA Status, [Status]=Revision Complete - QC/QA Needs Review, [Status Changed By]=Current User Open Code Page 9, Prompt User for Comments, then Edit the record added in step 2 by populating [QC/QA: Work Order Review/Revision Comments] with User Prompted Input. Everything works perfectly, except the User Prompted Input doesn't populate the [QC/QA: Work Order Review/Revision Comments] field on my Status History record (created in Step 2). I've tried including a formula query (as a variable) and referencing it in my formula to use as the Record ID from the record added in Step 2 above but it didn't work. Then I tried using another formula field [Max QC/QA RID for Comments], which I created on the Work Order form to run the query and I referenced it in my formula to use as the RID but it didn't work. I guess the API-EditRecord isn't working which I can only speculate it's related to the Record ID? Does anyone know if there is a better way to do this? Here is a link to the code page I used: Code Pages - PromptAndRefresh.html (quickbase.com) Here is my formula below: var bool show = If(Contains([W/O Status],"Received") or Contains([W/O Status],"Created") or Contains([W/O Status],"Dispatched")or Contains([W/O Status],"Pending Review") or Contains([W/O Status],"Pending Revision"),true,false); var bool QCQAFail= If(Contains([QC/QA Status],"QC/QA Fail"),true,false); var text WOStatus= URLRoot() & "db/" & [_DBID_STATUS_HISTORY] & "?a=API_AddRecord&_fid_6=" & URLEncode ([Record ID#]) & "&_fid_10=Closed" & "&_fid_11=Work Order Status" & "&_fid_9=" & URLEncode(User()) & "&apptoken=xxxxxxxxx"; var text QCQAStatus= URLRoot() & "db/" & [_DBID_STATUS_HISTORY] & "?a=API_AddRecord&_fid_6=" & URLEncode ([Record ID#]) & "&_fid_10=Revision Complete - QC/QA Needs Review" & "&_fid_11=QC/QA Status" & "&_fid_9=" & URLEncode(User()) & "&apptoken=xxxxxxxxx"; //var Text qcqaID = ToText(GetFieldValues(GetRecords("{10.EX.'Revision Complete - QC/QA //Needs Review'} AND {6.EX."&[Record ID#]&"}",[_DBID_STATUS_HISTORY]),3)); //var text MAXID= //ToText(Max(ToNumber(Part($qcqaID,1,";")), //ToNumber(Part($qcqaID,2,";")), //ToNumber(Part($qcqaID,3,";")), //ToNumber(Part($qcqaID,4,";")), //ToNumber(Part($qcqaID,5,";")), //ToNumber(Part($qcqaID,6,";")), //ToNumber(Part($qcqaID,7,";")))); //var Number MAXID= //Max(ToNumber(Part($qcqaID,1,";")), //ToNumber(Part($qcqaID,2,";")), //ToNumber(Part($qcqaID,3,";")), //ToNumber(Part($qcqaID,4,";")), //ToNumber(Part($qcqaID,5,";")), //ToNumber(Part($qcqaID,6,";")), //ToNumber(Part($qcqaID,7,";"))); var text urlToExecute = URLRoot() & "db/" & [_DBID_STATUS_HISTORY] & "?a=API_EditRecord&apptoken=" & "&apptoken=xxxxxxxxx" & "&rid=" & [Max QC/QA RID for Comments] & "&_fid_28="; // Field to Populate with the user prompted input var text Page= URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=9" // Open code page 9 & "&url=" & URLEncode($urlToExecute); // Pass in the URL to execute var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); var text DoBoth= $WOStatus & "&rdr=" & URLEncode($QCQAStatus) & URLEncode("&rdr=" & URLEncode($Page)) & URLEncode("&rdr=" & URLEncode("&rdr=" & URLEncode($RefreshPage))); var text DoOne= $WOStatus & "&rdr=" & URLEncode($RefreshPage); If($show=true and $QCQAFail=true, $DoBoth, $show=true, $DoOne,"") Any help or advise would be much appreciated! Thanks, ------------------------------ Aleisha Aldrich ------------------------------99Views0likes0CommentsWorking Formula to Change Font Style, Size, Color etc...
Here is an easy way to change the native Quick Base font and background of the entire page of a table report or form. This information is also in a reply to another thread, but I wanted to start a new one with a specific subject and hashtags. There is an old thread that has some code that you can put into a formula rich text field that will increase the font size for all of the text in a report. Here is the link to the original thread: link This solution was crafted by @_anom Diebolt). I found that it can be expanded to include other CSS elements and styling and can also be coupled with the .hide() function to remove various elements from the page. Take this code and paste it into a rich text formula field. The first two lines style the font and the third adjusts the background color; 100.5% is the font size parameter while Nirmala UI is the font type. This is just for example and it can be tailored to your specific need so feel free to delete any of the styling that you don't need or like. "<img src onerror='$(`*`).css(`font`, `bold 100.5% Nirmala UI`);'> <img src onerror='$(`*`).css(`color`, `blue`);'> <img src onerror='$(`*`).css(`background-color`, `lightgrey`);'> <img src onerror=' $(\"#navTop\").hide(); $(\"#tablesMenuBarWrapper\").hide(); $(\"#TableNPageBarSeparator\").hide(); $(\"#pageNavBarTray\").hide(); $(\"#stdCustThisFormButton\").hide(); $(\"#formFooterButtonsContainer\").hide(); $(\"#customBasicBrandMenus\").hide(); $(\"#recordNavBar\").hide(); $(\"#signInLink\").hide();'>" In the interest of the user experience, title the field - so that it doesn't take up space and add it as the last field in your table so it is out of the way. If you use it on a form, just tick the check box for an alternate title and leave it blank to not show the - on the form. You can make many of these formula fields and add them to various forms and tables to create different styling for each, they will just have to have unique field titles. Here is the original table report: And here is the result of using the formula rich text field on a table report: Here is the result on a form: This does not work on the mobile app. #formula #font #style #color #background #size #hide #report #form #custom #customize #UI ------------------------------ Adam Keever ------------------------------99Views0likes1CommentSave button with a redirect
I haven't found a thread yet with a solution that is working with me so, I am trying to to make a button that saves and redirects. Currently I am trying <div class='Vibrant Success' onclick='RedirectURL.value=myurlhere;editform.rl.value="";DoSave();'>Save</div> I got my current setup from this threadhttps://community.quickbase.com/quickbase/topics/how-can-i-save-and-redirect-to-a-home-page This thread is the closest thing to what I am looking for.Iwould like to be able to save a form and then be redirected to a different table and its default report. Is there an easier solution?99Views1like33Comments