Topics in Quick Base 1970-01-01T00:00:00Z 12497 12391 0 0 0 336 7754126 I need a field that takes the date field and shows only the month. Formula? 2018-06-25T06:06:59Z 2018-06-22T19:41:29Z Gregg gregg_gn6mjfmzmswjb Every record has a date that is selected by the user. I need to combine all records within a current month to get totals. I dont want to use a summary table, so if I had a formula date field that would convert the date field to just the name of the month i could combine them. Whats the formula for converting a date to a month? question active 3 4 1 comment 7754917 Day and month being swapped in date field on "?a=API_GenAddRecordForm" 2018-06-25T05:43:41Z 2018-06-25T05:43:41Z Gary Boyd gary_boyd_1ihbn3ff0q29e I'm using&nbsp;"?a=API_GenAddRecordForm" &amp;&nbsp;"&amp;_fid_41=" &amp; [Date I want] &amp;&nbsp;"&amp;_fid_42=" ...<br /><br />Field 41 and 'Date I want' are both date fields.<br />In app properties, formatting of dates is DD-MM-YYYY (I live in Australia).<br />When the form opens, in field 41, the day is in the month and month is in day from the 'Date I want'.<br /><br />Thank you. question 0 1 1 create 7437170 Got CSV To Import? 2018-06-25T05:12:06Z 2014-06-02T02:15:48Z Ⲇanom the ultimate (Dan Diebolt) dandiebolt <p>I wanted to show you a simple way to read a <b>CSV</b> file and process it before sending it to QuickBase. Normally when a file input control is on a form you select a file from the local file system and the file gets sent directly to the server when the form posts. However, with the <b>HTML5 File API</b> you can actually read the selected file, manipulate the contents and send the results to the server through an <b>AJAX</b> call so the host page never reloads.</p><p>To simplify the procedure even further I wrote a carefully crafted piece of code to make the process dead simple and allow the greatest level of customization for integration with QuickBase. Here is the code:</p><p><b>Pastie Database</b></p><p><a href=";rid=280" rel="nofollow" target="_blank">;rid=280</a><br /></p><p>In a nutshell all you have to do is place a file control on your page and give it an id such as <b>myFile</b> shown below:</p><p>&lt;input type="file" id="<b>myFile</b>" accept="<b>.csv</b>"&gt;<br /></p><p>After a file is selected by the user, the <b>CSV</b> data will magically show up and can be accessed through the variable <b>csv</b> in the following short snippet of code where the same id is passed to <b>GotCSV</b>():</p><p><b>gotCSV</b>("<b>myFile</b>").then(function(<b>csv</b>){</p><p> //your code here</p><p> console.log(JSON.stringify(<b>csv</b>, null, " "));</p><p></p><p>});</p><p>So if the <b>CSV</b> file contained the following data:</p><blockquote> <p>name,phone,email</p> <p>John,(800) 555-1212,<a href="" rel="nofollow"></a></p> <p>Jane,(888) 555-1212,<a href="" rel="nofollow"></a></p> <p>Baby,(877) 555-1212,<a href="" rel="nofollow"></a> </p> </blockquote><p>You will be able to access the <b>csv</b> variable with properties corresponding to the column names:</p><p>[</p><p> {</p><p> "name": "John",</p><p> "phone": "(800) 555-1212",</p><p> "email": "<a href="" rel="nofollow"></a>"</p><p> },</p><p> {</p><p> "name": "Jane",</p><p> "phone": "(888) 555-1212",</p><p> "email": "<a href="" rel="nofollow"></a>"</p><p> },</p><p> {</p><p> "name": "Baby",</p><p> "phone": "(877) 555-1212",</p><p> "email": "<a href="" rel="nofollow"></a>"</p><p> }</p><p>]</p><p>Once you have the <b>CSV</b> represented as a JavaScript object you can go to town manipulating it. It now becomes a trivial matter to transform or filter the incoming <b>CSV</b> data prior to importing it into QuickBase.</p><p><b>Notes:</b></p><p>(1) The function <b>gotCSV() </b>wraps the <u>two</u> asynchronous processes (a) of the user selecting a local file and (b) reading the local file using the <b>HTML5 File API</b> and returns a promise. </p><p>(2) When the promise resolves the data in the selected file will be converted to an object and available as the JavaScript variable <b>csv</b>.</p><p>(3) This code is very generic and will allow you a perform a wide variety of tasks such as:</p><ul> <li>cleaning up dirty data prior to import</li> <li>normalizing data</li> <li>removing duplicate data</li> <li>prevent importing a redundant data</li> <li>converting quantities prior to import</li> <li>supplying default data prior to import</li> <li>split the raw <b>CSV</b> data into parent/child components prior to import</li> </ul><p>(4) to use the code the only thing you have to do is place your custom code where the comment <i>"your code here"</i> resides. The promise returned by <b>gotCSV()</b> will insure that your code automatically runs as soon as the file is selected and read by the <b>HTML5 File API</b>.</p><p>(5) This code should work in all evergreen browsers including <b>IE11</b>:</p><p><a href="" rel="nofollow" target="_blank"></a></p><p>(6) It may take some time to grok what this code is doing but I assure you this is as <u>extremely</u> powerful technique that can probably greatly streamline your workflow if implemented.</p><p>(7) Enjoy!<br /></p> question complete 15 3 1 comment import, names, user, access, email, javascript, column, filter, tasks, api, custom, form, null 7754766 Script Injection Techniques Recap 2018-06-24T19:38:06Z 2018-06-24T19:38:06Z Ⲇanom the ultimate (Dan Diebolt) dandiebolt I thought this summary of <b>Script Injection Techniques</b> might help others understand the various options for injecting script into QuickBase:<br /><br /><br /><b>Name: IOL (Image On Load)</b><br /><br />Scope: {new, edit, view, report, grid edit} pages<br /><br />Notes &amp; Pros:<ul> <li>Oldest Technique</li><li>Most Examples</li></ul>Cons:<br /><ul><br /> <li>N/A to Charts, Admin &amp; Other Pages</li> <li>Loads Late / Could Flicker</li> </ul><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1737114/RackMultipart20180624-100200-1oldwy0-hr-manasa-malipeddi-04_inlinejpg1529868888" /><br /><br /> <b>Name: BOL (Branding On Load)</b><br /><br />Scope: All Pages In App<br /><br />Notes &amp; Pros:<ul> <li>Modifies Branding Bar</li> <li>Easy for QB to Implement</li><li>Loads Early-ish</li> </ul> Cons: <ul> <li>Fragile To QB Change</li> </ul><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1737114/RackMultipart20180624-100200-1oldwy0-hr-manasa-malipeddi-04_inlinejpg1529868888" /><br /><br /><b>Name: SW (Service Worker)</b><br /><br />Scope: All PagesIn Entire Account!<br /><br />Notes &amp; Pros: <ul> <li>God Mode - Extremely Powerful</li> <li>Offline, Notifications, Background Sync ...</li><li>Loads Before Rendering Starts</li> </ul> Cons: <ul> <li>All or Nothing: Takes Over Account</li> </ul><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1737114/RackMultipart20180624-100200-1oldwy0-hr-manasa-malipeddi-04_inlinejpg1529868888" /><br /><br /><b>Name: DWS (Dashboard Widget Script)</b><br /><br />Scope: Application Dashboard<br /><br />Notes &amp; Pros: <ul> <li>Simple Setup with Web Page Widget</li> </ul> Cons: <ul> <li>Applies Only to Dashboard</li> </ul><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1737114/RackMultipart20180624-100200-1oldwy0-hr-manasa-malipeddi-04_inlinejpg1529868888" /><br /><br /><b>Name: US (User Script)</b><br /><br />Scope: URL Pattern <br /><br />Notes &amp; Pros: <ul> <li>Match Against URL Patterns</li> <li>GreaseMonkey, TamperMonkey</li> </ul> Cons: <ul> <li>Must Install On Per User Basis</li> <li>Differences Between Browsers</li> </ul><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1737114/RackMultipart20180624-100200-1oldwy0-hr-manasa-malipeddi-04_inlinejpg1529868888" /><br /><br /><b>Name: OEH (On Error HTML)</b><br /><br />Scope: {new, edit, view, report, grid edit} pages<br /><br />Notes &amp; Pros: <br /><ul> <li>Variant of IOL</li> <li>No Code Page Needed</li></ul>Cons:<br /><ul><li>Not Very Human Readable (HTML Encoded Script)</li><li>When Used On Reports Can Create Heavy Payload</li> </ul><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1737114/RackMultipart20180624-100200-1oldwy0-hr-manasa-malipeddi-04_inlinejpg1529868888" /><br /><br /><b>Name: DCO (Dev Console Override)</b><br /><br />Scope: Specified URL <br /><br />Notes &amp; Pros: <ul> <li>Convent For Development</li> <li>Can Kill Evergage Spew To Console</li><li>Can Replace Or Modify Any Served Asset (HTML, CSS, JavaScript etc)</li> </ul> Cons: <ul> <li>Setup Per User</li> <li>Somewhat Technical</li><li>Chrome Only At This Time</li> </ul> question 0 2 1 create 7754750 How To Create Dashboard Script Buttons? 2018-06-24T18:38:30Z 2018-06-24T18:38:30Z Ⲇanom the ultimate (Dan Diebolt) dandiebolt How To Create Dashboard Script Buttons?<br /><br />QuickBase does not make is easy to run script from the dashboard but here is a simple solution. <br /><br />First the demo:<br /><br />Just click one of the three buttons on the dashboard and the associated script file saved in a code page will run:<br /><br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1737105/RackMultipart20180624-38710-lqi713-screenshot_inlinejpg1529864843" /><br /><br /><b>Dashboard Script Buttons</b><br /><a href="" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bns3puc3s"></a><br /><br />To set this up for yourself just create three code pages:<br /><br /><b>Code Page: alert1.js</b><br /><a href=";pagename=alert1.js" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bns3puc3sadbpagepagenamealert1js">;pagename=alert1.js</a><br /><br /><b>Code Page: alert2.js</b><br /><a href=";pagename=alert2.js" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bns3puc3sadbpagepagenamealert2js">;pagename=alert2.js</a><br /><br /><b>Code Page: alert3.js</b><br /><a href=";pagename=alert3.js" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bns3puc3sadbpagepagenamealert3js">;pagename=alert3.js</a><br /><br />Make sure to give each of your buttons the <b>display text</b> using the <u>name</u> of the code page and include the<b> .js</b> suffix (ie alert1.js, alert2.js, alert3.js)<br /><br />Now add a button on the dashboard for each of these code pages using the same procedure you would to add a button to an HTML page.<br /><br />Finally, add a web page widget named <b>script.html</b> (this is a HTML page not a JavaScript page) to the <u>bottom</u> of your dashboard using the code in the pastie below:<br /><br /><b>Pastie Database</b><br /><a href=";rid=670" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bgcwm2m4gadrrid670">;rid=670</a><br /><br />When this <b>script.html</b> page loads (in its iframe)&nbsp;it will scan all your buttons and convert those buttons that point to code pages named <b>*.js</b> to load the associated script file rather than load the code page for viewing. This demo uses the new <b>Dashboard Widget Script </b>(DWS) technique.<br /><br />Once setup the file script.html will convert any new buttons you add that are named after the code page containing script.<br /><br /><b>Notes:</b><br /><br /><b>(1) </b>As a practical matter all of your code in the inject page should be included within a <b>closure </b>so it does not conflict with QuickBase's code.<br /><br /><pre><b>(function(){</b><br />&nbsp; alert("alert1&#46;js");<br /><b>})();</b></pre><b><br /></b> question 0 1 1 create 7754496 formula omits info from field all of a sudden 2018-06-24T07:01:43Z 2018-06-23T21:08:35Z John Ioane john_ioane i have a url formula in a field used in a form somehow now it omits information from a field i want display ed from that formula, the formula url i currently have is: <br /><br />URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dbpage&amp;pagename=" &amp; URLEncode("DME Chart.html") &amp; "&amp;clist=a&amp;rid=" &amp; [Record ID#] question active 1 2 1 comment 7754230 “Next” and “Previous” buttons on multi-tabbed forms 2018-06-24T05:30:54Z 2018-06-23T01:38:30Z Jeff Mickelsen jeff_mickelsen_gyhg3tiw6j55p I am trying to apply this to the current version of QuickBase and I am having problems. <br /> I am trying to put “Next” and “Previous” buttons on the bottom of a multi-tabbed form. I have tried the following. <br /><br /> 1. I created a Formula-RichText field named PageTwo and put the following in the formula box: <br /> a name=PageTwo <br /> (I had to remove the less than, greater than, and the /a from what I added to get the values to display <br /> 2. I then placed this as the first field on the second Tab of my form. <br /> 3. I then created a Formula-RichText field named GotoPageTwo and put the following in the formula box: <br /> "JavaScript:void(window.location.href='#PageTwo');" <br /> 4. I then placed this field as the last field on the first Tab of my form. <br /><br /> When I display the form, I get <br /> “GotoPageTwo <br /> JavaScript:void(window.location.href='#PageTwo');” (without the quotes) <br /> Displayed at the bottom of the first Tab with no button <br /><br /> And I get <br /> PageTwo <br /> Displayed at the top of the second tab <br /><br /> Is there anyway to add these buttons? If this is a really dumb question, please forgive my ignorance on this topic? question active 1 2 1 comment 7754589 Print Multiple Exact Form Records 2018-06-24T05:28:36Z 2018-06-24T05:28:36Z Mark Sylvers mark_sylvers Issue:<br /><br />We have a report that is run with beginning and ending dates that has an exact form field attached. It is cumbersome and time consuming for the user to print each exact form one record at a time.&nbsp; We would like the ability to print multiple exact form records in a batch at one time. Not 100's but maybe a dozen or so at one time would be helpful.<br /><br />By adding checkboxes to the report much like the record delete check box feature the user could simply check the records they wanted to print and the exact form would print in a batch. If not a record checckbox then maybe a select button would work as well.<br /><br />Any help would be appreciated. Thanks. question 0 2 1 create 7753486 Hide 'Sorting and grouping...' on More drop-list of a report 2018-06-23T12:25:39Z 2018-06-21T13:48:38Z Gary Boyd gary_boyd_1ihbn3ff0q29e Hi,&nbsp;<br />I am unable to suppress the 'Sorting and grouping' selection on the 'More' droplist at the top of all my reports. Clicking on it allows users to view field names which is a security issue, messy &nbsp;and not necessary. <br /><br />In roles, I have selected:<br />- Hide UI for creating or customizing reports<br />-&nbsp;Hide personal settings link<br />- In user interface, Hide UI for: all 6 options selected.<br /><br />Thanks. question pending 3 3 1 comment 7754350 Quickbase php api - how to group multiple conditions in do query 2018-06-23T12:20:51Z 2018-06-23T12:20:51Z Avinash Hiremath avinash_hiremath I need to query 2 multi select fields -<br />same field&nbsp; should be OR condition and the other field should be in AND condition<br /><br />As of now, it's working like&nbsp;<br />(fid1 = value1 OR fid1 = value2 AND fid2 = value3 OR fid2 = value4)<br /><br />I would like the query like<br />(fid1 = value1 OR fid1 = value2) AND (fid2 = value3 OR fid2 = value4)<br /><br />array(0) {<br />&nbsp; &nbsp; ["fid"]=&gt;<br />&nbsp; &nbsp; int(7)<br />&nbsp; &nbsp; ["ev"]=&gt;<br />&nbsp; &nbsp; string(2) "EX"<br />&nbsp; &nbsp; ["cri"]=&gt;<br />&nbsp; &nbsp; string(16) "Field Operations"<br />&nbsp; }<br />&nbsp; [2]=&gt;<br />&nbsp; array(1) {<br />&nbsp; &nbsp; ["fid"]=&gt;<br />&nbsp; &nbsp; int(7)<br />&nbsp; &nbsp; ["ev"]=&gt;<br />&nbsp; &nbsp; string(2) "EX"<br />&nbsp; &nbsp; ["cri"]=&gt;<br />&nbsp; &nbsp; string(7) "Finance"<br />&nbsp; &nbsp; ["ao"]=&gt;<br />&nbsp; &nbsp; string(2) "OR"<br />&nbsp; }<br />&nbsp; [3]=&gt;<br />&nbsp; array(2) {<br />&nbsp; &nbsp; ["fid"]=&gt;<br />&nbsp; &nbsp; int(7)<br />&nbsp; &nbsp; ["ev"]=&gt;<br />&nbsp; &nbsp; string(2) "EX"<br />&nbsp; &nbsp; ["cri"]=&gt;<br />&nbsp; &nbsp; string(17) "Global Operations"<br />&nbsp; &nbsp; ["ao"]=&gt;<br />&nbsp; &nbsp; string(2) "OR"<br />&nbsp; }<br />&nbsp; [4]=&gt;<br />&nbsp; array(3) {<br />&nbsp; &nbsp; ["fid"]=&gt;<br />&nbsp; &nbsp; int(7)<br />&nbsp; &nbsp; ["ev"]=&gt;<br />&nbsp; &nbsp; string(2) "EX"<br />&nbsp; &nbsp; ["cri"]=&gt;<br />&nbsp; &nbsp; string(30) "Human Resources/Communications"<br />&nbsp; &nbsp; ["ao"]=&gt;<br />&nbsp; &nbsp; string(2) "OR"<br />&nbsp; } question 0 2 1 create 7753682 date based on numeric month 2018-06-23T04:15:33Z 2018-06-21T20:13:17Z Dante Tognoli dante_tognoli_dkugspit4nfyt I am trying to calculate a date based on a month. We have certifications that expire not based on the date that the certificate was issued, but on a specific month of the year. This is called a "base month" if a certificate expires after one year and is given in march but the base month is February I need to generate an expiration date based on February (so given 3/15/18 returns 02/01/19). I was planning on converting the base month to it's corresponding number (jan=1, etc...) but I'm not sure how calculate a date based on a single number. question 1 1 1 create 7440898 Best way to add months (duration) to a date formula? 2018-06-23T00:50:11Z 2016-05-23T14:56:48Z Donnie donnie_ih54mnyvepv6s <p>Has anyone been able to establish the most elegant way of adding the duration in months to a date formula?</p><p>I know it's not straightforward because there are lots of variables in days in the month, and leap years etc. &nbsp;However, it would be great if someone has gone through this and was prepared to share their working?</p><p>[Date Agrmnt Signed] + [Agreement Duration (Months)]<br /></p><p>Thanks.</p> question complete 7 4 1 comment add, formula, duration formula, date, date formula 7435710 I have created a Pie Chart. All the information is pulling correctly. I have the colors set in the legend box but I am not able to change the name. It is showing a '3' and '4' next to the color blocks. How can I change these numbers to names? 2018-06-22T23:40:34Z 2013-10-19T02:54:23Z Daniel daniel_bce42crcls08o question complete 6 2 1 comment names, chart 7753969 Update formula variable 2018-06-22T23:05:16Z 2018-06-22T13:46:48Z Max Allen max_allen_4x7krmr9warb7 I want to do something along the lines of this:<br /><br /><pre>Var Number MyVariable = [MyField]<br />If ([AnotherField]=True, $MyVariable==$MyVariable * 2 ) If ([YetAnotherField]=True, $MyVariable==$MyVariable * 4) </pre><br />Hope fully being able to do this with as many if statements as I wish.<br /><br />Basically my question is, once I've defined a formula variable, is there a way I can edit or update it.<br /><br />Cheers for any help! question active 3 2 1 comment 7754009 Help with Formula Variable 2018-06-22T22:25:14Z 2018-06-22T15:02:25Z Ashley Asante ashley_asante I asked a similar question a while ago, but want to get in depth more. If anyone has any ideas on how to make this happen, or where I could learn more about how this works, I'd appreciate it.<br /><br /><br />I'm working on building a Vendor Application.<br /><br /><ul><li>A Table called Companies (Company Name, Location, Division)</li><li>A table called contacts (one company will have many contacts)</li><li>A Table called Material Categories (steel, aluminum, etc)</li></ul>I'd like to associate Material Categories to Companies (one company will have many material categories).&nbsp;<br /><br />But then I'd also like that information to somehow be related to the Contacts table.<br />Meaning, on the contacts table, I'd like the user be able to search "Steel", and QB would return the lists of contacts that are related to the companies that sell steel.<br /><br />is there a way to connect the Material Categories to the Contacts, and through use of a Formula Variable, make that searchable on the contacts table? question active 1 2 1 comment