Topics in Quick Base 1970-01-01T00:00:00Z 10247 10241 0 0 0 87 7542695 Field change in connected table triggers field change in local table's corresponding record - possible? 2017-06-23T03:02:42Z 2017-06-23T01:02:34Z Adam adam_parker_dem651d9cyfff I have an app that uses connected tables and regular tables. My records are "products" in this situation.&nbsp;<br /><br />When work is done on a product, my vendor updates the status for that record/product to "complete."&nbsp;I have a table within my own app that more or less mirrors the vendor's table. The two tables have fields with matching values, which I'm hoping I can use to leverage a relationship.&nbsp;<br /><br />What I want to achieve is: when the vendor updates a product's status to "complete" in the connected app, I want the corresponding record in my app to update to "complete." Ideally, this would be a text value and not a checkbox, but I'm open to any/all thoughts on the best way to approach this.&nbsp; question 1 2 1 comment 7541374 Compulsory Selection in Multi Select 2017-06-22T21:57:36Z 2017-06-21T02:57:53Z Arshad Khwaja arshad_khwaja_7166138 I have a multi select field (holding State names) which is a required field when creating a new required. &nbsp;However, due to organisational requirements, we have to ensure that in some cases, users select two states. Largely this is because our entire business is configured so that one large and small state is looked after by a team. <br /><br />Is there any way that I could ensure that users always select correct second state? &nbsp;&nbsp; question 7 5 2 comment 7541846 Does Quickbase have a replace function? 2017-06-22T20:34:03Z 2017-06-21T18:39:47Z Jordan Beatty jordan_beatty In JavaScript I would do something like&nbsp;<br /><br /><pre>var&nbsp;test =&nbsp;"I Hate Spaces";<br />var&nbsp;example = test&#46;replace(" ",&nbsp;"_");</pre><br />Then I could get the display "I_Hate_Spaces". Is there something similar I can do in Quickbase to replace characters in strings conditionally? I would like to be able to have it be a separate field. So then someone could then input, say a project name, then the other field would mimic the input but remove the spaces and replace them with underscores. question 7 4 1 comment 7536144 Eliminating double scheduling 2017-06-22T18:25:23Z 2017-06-12T17:47:46Z Hans Hamm hans_hamm question 13 5 1 comment 7541745 Run API_DoDuery using qid for a summary report that uses paramerters 2017-06-22T18:16:12Z 2017-06-21T16:17:19Z Robert robert_in2kyko36l4ls I have a table of contractor data with first name, last name, start and end dates, burden amount, ball rate and pay rate. I want to summarize the bill, pay and burden amounts and do other averages and calculations on that data as of a given date, i.e. all contractors whose start date is on or prior to June 1st and end date is on or after June 1st. Then, I want to copy the result from that summary into a historical table so I can report on data trends from month to month.<br /><br />What I have done to date is to create a summary report prompting the user for the start and end date. The user then enters the same date for each prompt, e.g. June 1st, and the report runs successfully. &nbsp;The user can then copy these records to the history table using the option on the report page under the More button. This issue with this method is that the "As Of Date", June 1st in this example, is not entered into the history table and the user needs to enter it into the copied records in the history table. This is not an efficient method.<br /><br />To solve this, I want to use jquery and javascript to prompt the user to enter the "As of date", query the summarized data and then use API_AddRecord to write the rows into the history table using the correct "As of date". The issue with this solution is that I cannot run the summary report using the qid and pass in the "as of date" to summarize the proper set of records. &nbsp;Is there another/easier method of solving this other than querying all the records within my "as of date" and writing all the calculations myself, prior to writing the records to the history table?<br /><br /><br />Since this post, I came up with the idea of relating a table that contains the &nbsp;"as of&nbsp;date&nbsp;" to my contractor data table. This works as the related id will always be 1. I just update the date in the&nbsp;"as of&nbsp;date" table and the report does report the correct values when I run it on the contractor page.<br /><br />However, when I run the API_DoQuery I get the following error:<br /><br />&lt;qdbapi&gt;<br /> &lt;action&gt;API_DoQuery&lt;/action&gt;<br /> &lt;errcode&gt;2&lt;/errcode&gt;<br /> &lt;errtext&gt;Invalid input&lt;/errtext&gt;<br /> &lt;errdetail&gt;API_DoQuery only supports table-type queries.&lt;/errdetail&gt;<br />&lt;/qdbapi&gt;<br /><br />My code for the query, which is chained to the api_EditRecord call, is:<br /><br /> var promiseQRY = $.get(dbidContractor , {<br /> act: "API_DoQuery",<br /> qid: "8",<br /> clist: ""<br /> });<br /><br />Any ideas on why I'm getting this error? question 3 4 1 comment 7540539 API Connection To Third Party Software 2017-06-22T18:13:55Z 2017-06-19T23:02:31Z Joey Zint joey_zint New Opportunity<br /><br />This may be lengthy so please forgive me...<br /><br />I am interested in connecting an app to a third party software called PlanGrid. PlanGrid is a blueprint management program (upload, markups, RFI's, highlight, versions, etc)<br /><a href="" rel="nofollow" target="_blank"></a><br /><br /><br />PlanGrid seems to have a decent API for connecting to their software but I am a little out of my league on this one. They have a web based option, a Windows App and a mobile app.<br /><br />API Documentation....<a href="" rel="nofollow" title="Link:"></a><br /><br />SDK.....<a href="" rel="nofollow" target="_blank" title="Link https//githubcom/plangrid/plangrid-api-net"></a><br /><br />Here is what I want to attempt to do:<br /><br />When we create a project in our app, PG has a Create Project API as well....we seem to be creating all of the information needed to achieve that in PG.<br /><br />Next step would be to upload a drawing to a project, edit it in PG and have that drawing reside as a file attachment in the project. When I attach the drawing in QB, it would also upload to PG under the project.<br /><br />I see it, I get it, not sure where to start. I am having a call with one of their software engineers and also to get setup with them and get a user token for their software as well as to provide them with out QB account information so that their software will allow a connection from us.<br /><br />Just looking for some ideas and direction on what type of pages I need to build to get started<br /><br />Have some place holders already started....easy part is done!<br /><br /><br /><img src="" title="Image:" /><img src="" /> question 1 5 2 comment 7542462 Stop automatically adding new fields to reports. 2017-06-22T17:59:32Z 2017-06-22T17:50:05Z QB Development qb_development Here's the problem. Whenever I create a new relationship and add lookup fields or summary fields, QB attaches the new fields to reports. How do I stop this from happening? Is there a universal app setting where I can set the program to "not add new fields to reports" similar to the "When new fields are created Do Nothing" option for forms? question 2 3 2 comment 7540995 creating fields based on summary total columns. Does anyone have a workaround with this limitation? 2017-06-22T15:20:08Z 2017-06-20T16:04:27Z Paul paul_jljxeyv1l7yp0 We are facing consistent walls in getting some simple calculations from a summary total reporting level. We have created numerous summary reports but cannot do simple calcs using the summarised totals i.e. working out margins between two total values, subtracting one total value summary from another etc. It would be really great if we could create further summary fields calculating from summed totals. Has anyone got a workaround? we seem to be having to create many tables to get around this but now hitting walls as some calcs are just too deep nested at lower levels. question 2 3 1 comment 7540887 Edit Parent Record In Popup and update Child record to show Edit 2017-06-22T15:10:34Z 2017-06-20T13:59:40Z Jacob jacob_8bmxzz0ecsm9p Hello,<br /><br />Currently I have a button that opens a parent record in edit mode in a popup window where the user can make changes save and close out window without navigating away from child record. &nbsp;Is there anyway to have this functionality still exist but also have it refresh the child record to show the new change on the parent level but on the child record form. &nbsp;While I like the idea and functionality of the popup I would love to hear other ideas for easily editing a parent from the child record which is my basic problem I am trying to solve for.<br /><br />Thanks. question 2 3 1 comment 7541923 I am trying to get a percentage omitting a NULL field. 2017-06-22T15:09:13Z 2017-06-21T20:40:59Z Casameira Reyes casameira_reyes My formula consist of multiple sections each equaling a percentage; however, when a section Null it isn't calculating in the total scores.&nbsp; question 20 2 1 comment 7542336 Can I have a button to invoke a script locally and pass values from a field into it? 2017-06-22T14:47:19Z 2017-06-22T14:25:26Z Jordan Beatty jordan_beatty I am assuming this isn't possible or not worth its work but I am curious. Whenever we have a new client/project we have to create a group of folder for them, and they are always the same group folder. So they are named "Client/Project + Folder Name". We use a really simple batch file to create the folders:<br /><br /><pre>@echo off md Folder_1 Folder_2 Folder_3</pre><br />Though is it possible that I could invoke it through a Quickbase button and also pass a field value to it. So if the client name was say "Bob" it would pass it, and get the output Bob_Folder_1 or [Client/Project Name]_Folder_1. question 2 3 1 comment 7540587 Confirmation button in email 2017-06-22T14:33:12Z 2017-06-20T00:41:05Z Lochlan Broughton lochlan_broughton We have designed a HTML 'Booking Ticket' email to be sent as an email notification to clients when booking details are received.<br /><br />The email notification is sent to the client directly via Quickbase notify upon saving the form.<br /><br />We would like to include a button in the email which the client presses that 'confirms' the booking.<br /><br />How would we go about building this button that changes the 'job status' field in a job row to 'confirmed'? question 1 4 2 comment 7441444 Collapsing all or a few nominated Sections Collapsed 2017-06-22T13:49:50Z 2016-08-31T04:46:36Z Arshad Khwaja arshad_khwaja_7166138 <p>As I have a fairly long form, &nbsp;I would like to make it easier for users to look at the collapsed sections and then choose to expand the ones they want. &nbsp; &nbsp;Is there an option to achieve this?&nbsp;</p> question complete 9 2 1 comment form, users 7524207 How to create tabs in a form for better navigation 2017-06-22T12:52:46Z 2017-05-23T10:40:56Z Nenad Ilic nenad_ilic I need to create several tabs in one table form that would function in the following way:<br />Tab 1 - will cover one area of table information (eg basic information)<br />Tab 2 - will cover other<br />etc<br /><br />So idea is to group table sections per groups in tabs.<br /><br />Is it possible to create this types, and how? question 27 12 3 comment 7533511 Service Worker Travel Log - Day 13 2017-06-22T11:09:09Z 2017-06-07T18:17:43Z dandiebolt <b>Day 13 - Hip Hip Cheerio!</b><br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1607290/RackMultipart20170607-23872-1u09mkj-screenshot_inlinejpg1496857821" /><br /><br /><br />Let's continue our previous post which dealt with our new <b>Service Worker</b>&nbsp;buddy&nbsp;<b>sw8.js</b>.<br /><br /><b>Code Page sw8.js</b><br /><a href=";pagename=sw8.js" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bmtpmup9qadbpagepagenamesw8js">;pagename=sw8.js</a><br /><br />You will notice that our new <b>Service Worker</b> had a line at the top that imported the <b>cheerio.js</b> library:<br /><pre><br />importScripts("<a href=";pagename=cheerio.js&quot;)" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bmss68i2jadbpagepagenamecheeriojs">https:&#47;&#47;haversineconsulting&#46;quickbase&#46;com/db/bmss68i2j?a=dbpage&amp;pagename=cheerio&#46;js")</a>;</pre><br />The reason that we are including this library is because we need to parse the <b>XML </b>response from <b>API_DoQuery</b> and convert it to a <b>JSON</b> response without having access to the <b>DOM </b>or&nbsp;<b>jQuery</b>. <b>Cheerio.js&nbsp;</b>is just a light weight&nbsp;<b>jQuery </b>replacement library that is often used server side (typically with <b>Node</b>) but equally useful within a <b>Service Worker</b>.<br /><br />Here are some docs about <b>Cheerio.js</b>:<br /><br /><b>Cheerio.js</b><br /><a href="" rel="nofollow" target="_blank" title="Link https//cheeriojsorg/"></a><br /><br /><b>Cheerio.js Github Page</b><br /><a href="" rel="nofollow" target="_blank" title="Link https//githubcom/cheeriojs/cheerio"></a><br /><br />The usage of <b>Cheerio.js</b> within our <b>Service Worker</b> is pretty straightforward and basically is exactly the same as the <b>jQuery </b>solution that used the helper function&nbsp;<b>XMLFlatToObj&nbsp;</b>.<br /><br /><b>$ = cheerio.load(body);</b><br /><br />var data = [];<br />var record = {};<br />$("record").each(function() {<br />&nbsp; record = {};<br />&nbsp; $(this).children().each(function () {<br />&nbsp; &nbsp; record[$(this).prop("tagName")] = $(this).text();<br />&nbsp; });<br />&nbsp; data.push(record);<br /><b></b>})<br /><br />The first statement loaded the <b>XML </b>response into the&nbsp;<b>Cheerio</b>&nbsp;object and the rest of the code is exactly the same as the orignal&nbsp;<b>jQuery </b>solution.<b><br /></b><br />The only other thing worth remarking on is how we package up the <b>JSON </b>response. In a nutshell we take the <b>data </b>array obtained from the above script format it as <b>JSON </b>and set the headers of the new Response to indicate we are sending back <b>JSON </b>instead of <b>XML </b>and to <u>not</u> cache the <u>new</u> response:<br /><br /><pre><b>var newBody = JSON&#46;stringify</b>({records: <b>data</b>}, null, " &nbsp;");<br />return new Response(newBody, {<br />&nbsp; headers: {<br /><b>&nbsp; &nbsp; 'Content-Type': 'application/json',</b><br /><b>&nbsp; &nbsp; 'Cache-Control': 'max-age=0'</b><br />&nbsp; }<br />});</pre><b></b><b><br /></b>It is really that simple! In summary, we created a new parameter value<b> &amp;fmt=json </b>&nbsp;for <b>API_DoQuery</b>&nbsp;and included the conversion code within our <b>Service Worker</b> which will convert the <b>XML </b>response to <b>JSON </b>whenever this <b>API </b>method is used in <b>Table #8</b>.<br /><b><br /></b><blockquote>Your are really going to like our next post as we are going to create a new <b>API </b>from scratch! To make it even more exciting I will take suggestions for what this new <b>API </b>will be named and what it will do. I am going to be out of the office for a few days so if there is some <b>API </b>you want let me know and if it is simple enough I that can make a demo out of it I will.</blockquote><b><br />Next Up: Day 14 - Where No API Has Gone Before</b> question 2 2 2 create