URL 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.99Views0likes19CommentsHow 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!98Views0likes7CommentsClose 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 ------------------------------79Views0likes16CommentsLookup 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? Thanks75Views2likes10CommentsCustom 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 ------------------------------72Views0likes5CommentsInserting hyperlink URL href field and referencing in Rich Text HTML field
I am trying to no avail to insert a URL formula field ("https://www.google.com/") for argument sake into a rich text field where I have a table created with HTML. Some of the code is below per the picture attached: \n<tr><td SPAN STYLE=\"color: black; font-size: 12pt; font-weight: bold; background-color: lightblue\">"&"B"&"</td>\n \n<td SPAN STYLE=\"color: black; font-size: 12pt; font-weight: bold\">"&"Front of Building"&"</td>\n \n<td SPAN STYLE=\"color: black; font-size: 8pt\">"&[test_url_field]&"</td>\n I would like the link to be clickable and a hyperlink instead of a text link for the test_url_field. Is this possible? I have tried the following: 1) To Text (creating a to text formula field that converts test_url_field to a text) 2)Declaring a Variable var text URL="https://" &[test_url_field]; a. also tried var text URA="<a href='"&[test_url_field]&"'</a>"; 2) Creating line of code no variable: "<a href="URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [test_url_field]& "</a>"</td></td>\n Any help would be appreciated so much ------------------------------ Lija Harris ------------------------------71Views0likes1CommentSave 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?68Views1like33Commentshow 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.64Views2likes20CommentsCalculating 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 ------------------------------64Views1like7Commentsjavascript prompt with a dropdown menu
Below is my code page: What I want to do is, have the prompt show a dropdown of values they can select from, instead of having the user enter any text. Thanks (function(){ var dbid = "bnt8grwvt"; var dbidTable = dbid; var apptoken = "mytoken"; $.ajaxSetup({data: {apptoken: apptoken}}); var description= prompt("Enter a brief description of the work done in this session: ", ""); if (description == null || description == "") { alert("You did not enter a description I will cancel this Time Out."); Return; } var promise = $.get(dbidTable, { act: "API_EditRecord", rid: QBU_rid, _fid_7: "Active", // _fid_6: "Out" }).then(function(xml) { console.dirxml(xml); $.get() & location.reload(true); }); })();59Views1like3Comments