How to make a button return to the same place on the page.
I'm curious if a command can be added to a button to have the rdr go back to the same place on the page when you clicked the button. Example... I have a button that adds a child record, but the button is basically in the middle of the form. When you click the button, it successfully adds the record and comes right back to the parent, but you always land at the top of the page and not back where the button is (for more clarity, it's a "+" and a "-" button to add count to inventory, so I want to click the plus button and just return right back to where the button is on the page so I can click it again). I'm not sure if this is Javascript, or part of a QB formula... or just not possible. Thanks for the help!90Views0likes7CommentsLookup 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? Thanks30Views2likes10CommentsCalculating Distance from 2 Address Fields
I have seen a lot of posts that partially answer elements I want to do, and I am relatively new to QuickBase (not necessarily databases or analytics, though). I am trying to calculate the distance between a worksite and a contractor's address to determine reimbursed mileage. So a couple of questions/asks to help: 1) It appears there is not a function or API plug-in to do actual driving mileage. Is that correct? 1)a) If there is a function/API, I have not found it. Does anyone have a good resource for it? 2) If there is not a function/API, I noticed a few posts on JavaScript formulas to calculate a Haversine distance formula. I just need approximates for budgeting purposes, not actual reimbursements (since they do this through their contractor payroll and screenshots). 2)a) Is the Haversine relative accurate to driving mileage from anyone that has used it in the past? 2)b) How do you pull Latitude/Longitude from address fields to do the Haversine calculation? I think I am just missing how to do it from other posts in here. ------------------------------ Jeffrey Weide ------------------------------30Views1like7CommentsClose 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 ------------------------------28Views0likes16CommentsPossible to make a custom cancel button?
Old threads show ways to make a formula/url or rich text that emulates the cancel button, but it involves using javascript. Is there any current way to make a custom cancel button? My use case involves needing it for mobile. I have a custom save button that does more than just save, and so I want a custom cancel button next to it (I currently have a big warning telling the user not to use the native buttons below, since I cant get rid of them). I tried just making a button to navigate away from the page - the problem is it autosaves no matter what. I want it to NOT save. I believe the advanced option to save when navigating away from the page, does not have any effect on mobile, so I cant simply uncheck it. ------------------------------ Mike Tamoush ------------------------------25Views0likes3CommentsCustom 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 ------------------------------24Views0likes5CommentsURL Formula Button w/ Two API Calls
I am working with 3 tables: Parent Table: Work Orders--> Intermediary (Child) Table: Subcontractor Quotes--> Child Table: Status History. I have an embedded report on my Work Order form which displays the Subcontractor Quotes. I have a Formula-URL button displayed on the report called [Subcontractor Dispatched]. When the button is clicked, I need two things to happen: I need to create a record in the Status History Table. I've successfully accomplished this with the following formula: var bool show = If(Contains([Quote Status], "Approved by PM"),true,false); If($show=true, URLRoot() & "db/" & [_DBID_STATUS_HISTORY] & "?a=API_AddRecord&_fid_16=" & URLEncode ([Record ID#])& "&_fid_10=Subcontractor Dispatched" & "&_fid_11=Subcontractor Quote Status" & "&_fid_9=" & URLEncode(User()) & "&apptoken=xxxxxxxxxxxxx" & "&rdr=" &URLEncode ( URLRoot() & "db/" & Dbid() &"?a=doredirect&z=" & Rurl()),"") I need to update the related parent Work Order record by checking a checkbox field. However, I have two problems: A.) I can't seem to figure out how to denote which record to update in my formula. I've tried using the formula below but it returns an error stating >No such record< and >Missing "rid" parameter< (I assume it must be because the field [Related Work Order] actually exists in the Subcontractor Quotes table, not the Work Orders table): URLRoot() & "db/" & [_DBID_WORK_ORDERS] & "?a=API_EditRecord&_rid=" & URLEncode([Related Work Order]) & "&_fid_155=true" & "&apptoken=xxxxxxxxxxx" & "&rdr=" &URLEncode ( URLRoot() & "db/" & Dbid() &"?a=doredirect&z=" & Rurl()) B.) Once I get the API_EditRecord formula correct, I'm not really sure how to structure my formula with the two API calls together and make it work. Any help, advice, or resources would be much appreciated! ------------------------------ Thanks, Aleisha ------------------------------Solved22Views0likes2CommentsRestful API how to update multiple records?
Hi, I'm new to QB and API. I'm trying to update a field (checkbox) in a table for multiple records using an unique Key field. I managed to update the field for one Key field, but failed to update multiple in one request. My script for one record looks like : { "to": "ID of my table", "data": [ { "72": { "value": "unique Key field" }, "60": { "value": true =>tick the checkbox } } ], "fieldsToReturn": [ 3 ] } Is there a simple way to run this action with multiple values for my FiD 72? Thanks for your help. ------------------------------ David NEGROBAR ------------------------------21Views0likes2CommentsURL formula to edit a record and ""refresh the page
I regularly use little API URL formula buttons like this one. var text $CopyStatustoPreviousStatus = blah blah blah ......; $CopyStatustoPreviousStatus & "&rdr=" & URLEncode($ReDisplayReport) That works well when I have a button dedicated to either refreshing the record I am sitting on or refreshing a particular report. I also use this great technique a lot to not refresh the report (so the user does not lose their place in the report or does not lose their Dynamic filter selections. var text URL= blah blah blah ....; "javascript:" & "$.get('" & $URL & "',function(){" & "$.jGrowl('email Triggered to Prospect', {life: 5000});" & "});" & "void(0);" But I would love to know how to make a button which will do some blah blah blah stuff and then refresh the screen - that way I could have the same button be used on any report and any record. Ideally it would reload the screen and preserve the user's Dynamic filter selections if they were on a report. If there a way to modify the code above to incorprate this concept &"javascript:location.reload(true);" and not do the growl pop up. ie I'm looking for a button to be able to execute a URL formula which would say edit a record and then refresh whatever screen the user is on. In that situation with a refresh, typically the user's feedback that the button click "took" will be that the report refreshed or the record refreshed, so we don't need or want that jgrowl pop up.20Views0likes19Comments