Topics in QuickBase 1970-01-01T00:00:00Z 10068 10063 0 0 0 77 7441180 Refresh Current Time before Creating or Editing Records 2017-05-24T15:26:07Z 2016-07-13T00:07:26Z gmcroberts gmcroberts <p>I have a set of URL formulas that run in a Formula -Text field when a button is clicked.</p><p>I'm invoking 2 sets of URLs in an HREF from pre-defined variables as follows:</p><p>&amp;$URLeditlast&amp; "&amp;rdr=" &amp; URLEncode($URLnew)&amp;&nbsp;<br /></p><p>The URLeditlast URL puts a stop time in on a current record, the URLnew creates a new record with a start time. &nbsp;This is the basis of a time tracking system</p><p>The problem is if the user leaves the page sitting&nbsp;idle the time doesn't' refresh.&nbsp;</p><p>For example, if I create my new time entry at 4:49pm and the leave the page sitting for 10 minutes then click the button to create a new entry, the times recorded is still 4:49pm, not 4:59pm. &nbsp;</p><p>I know if the user refreshes the page before they click the button this would solve the problem, however I do not want the user to have to do this (i have over 100 users in this quickbase&nbsp;all day long and there would be risk of time errors if people forget to refresh). &nbsp;I would like the QuickBase self-refresh when the button is clicked and then run the two URLs above to perform the actions with hopefully a refreshed&nbsp;time value<br /></p><p>I've tried many things and cannot get this to work, i'm hoping someone has some ideas. &nbsp;Thanks!</p> question complete 6 2 2 comment field, text field, button, user, formula, record, formulas, users, url 7517821 is there a way that we can export Quickbase data to an Oracle DB. 2017-05-24T15:09:34Z 2017-05-12T18:45:00Z Marco Pece marco_pece We use Quickbase as a CRM app. Is there a way that we export Quickbase data to Oracle DB? We could export the data to CSV and import into Oracle. But was wondering if there is an automated way to do this? Say have Oracle run a night job to read data from QuickBase. question 4 6 3 comment 7525113 Javascript throwing error in IE. Works ok with Chrome. 2017-05-24T14:49:40Z 2017-05-24T14:49:40Z Angel as111 I am calling the DoQuery() and AddRecord() APIs from the JavaScript. It works like a charm in chorme, However, its throwing me error in IE.The error it throws on the console: : 'XPathEvaluator' is undefined. Any ideas on how to get this working?<br /><br />&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<a href=";&gt;" rel="nofollow">"&gt;</a>;<br />&lt;html&gt;<br />&nbsp;&lt;meta http-equiv="X-UA-COMPATIBLE" content="IE=Edge,chrome=IE8,IE10"&gt;<br />&nbsp;&lt;body&gt;<br />&nbsp;&nbsp;<br />&nbsp; &lt;script type="text/javascript" src="/js/QuickBaseClient.js"&gt;&lt;/script&gt;<br />&nbsp; &lt;script type="text/javascript"&gt;<br /><br />&nbsp; &nbsp;var qdb = new QuickBaseClient();<br />&nbsp; &nbsp;qdb.SetAppToken("apptoken");<br /><br />&nbsp; &nbsp;var fun= function() {<br />&nbsp; &nbsp;<br />&nbsp; &nbsp;var rrid= qdb.parseQueryString();<br />&nbsp; &nbsp;<br />&nbsp; &nbsp;if((rrid['rid'] == "")) {<br />&nbsp; &nbsp; &nbsp;alert("Error, undefined variables present");<br />&nbsp; &nbsp; &nbsp;return;<br />&nbsp; &nbsp; }<br /><br />&nbsp; &nbsp;var rid=rrid['rid'];<br /><br /><br />&nbsp; &nbsp;var queryString &nbsp;= "{fid.EX."+rrid['rid']+"}";<br />&nbsp; &nbsp;<br />&nbsp; //Do Query<br /><br />//Add Query<br /><br /><br />&nbsp;<br />&nbsp; &nbsp;};<br />&nbsp; &nbsp;<br />&nbsp; &nbsp;fun();<br /><br /><br />&nbsp; &nbsp;<br />&nbsp; &lt;/script&gt;<br /><br />&nbsp;&lt;/body&gt;<br />&lt;/html&gt; question 0 3 2 create 7525046 URL Button to check/uncheck a check box 2017-05-24T14:34:08Z 2017-05-24T13:29:31Z Jordan Beatty jordan_beatty Is it possible to use conditional logic with an api call? I would like to create a URL button to check or un-check a checkbox depending on the state it is in&nbsp; question 12 3 2 comment 7514419 Special characters in e-mail notifications 2017-05-24T14:24:17Z 2017-05-08T09:47:13Z Spyros spyros_gqnly0z9198yi Hi,<br />since Saturday all my mail notifications with special characters or even an apostrophe (German letters like ΓΌ etc) are replaced by a "?" symbol.&nbsp;<br />The mail preview looks ok, but when the mail is sent it is received with this question mark.&nbsp;<br />I tried to create new notifications but the problem remains.&nbsp;<br />All mails are HTML enabled.&nbsp;<br />Can you please help?&nbsp;<br />Thanks,&nbsp;<br />Spyros<br /><br /><img src="" title="Image:" /><img src="" title="Image:" /> question 7 5 1 comment 7525075 Announcing QuickBase Service Worker Council and QuickBase Crank 2017-05-24T14:10:42Z 2017-05-24T14:07:01Z Danimal dandiebolt The newly formed QuickBase Service Worker Council met this morning for breakfast at the annual QuickBase Empower conference in Boston to welcome new members, clarify it's charter and review new applications that incorporate Service Worker technology into QuickBase. I am happy to announce the the Service Worker Council has unanimously voted to implement and release the QuickBase Crank proposal which will allow QuickBase users to significantly speedup their QuickBase applications. <br /><br /> QuickBase Crank allows a user to configure a custom Service Worker which can modify the caching policy of critical assets such as JavaScript and CSS files, substitute a minimized and faster loading version of an asset or even block the loading of subordinate assets that are not critical to the performance of a QuickBase application. Initial testing of QuickBase Crank have demonstrated a twofold increase in page loading times as well as the potential for offline usage of a QuickBase application with later synchronization when network connectivity is regained. <br /><br /> In addition to its technical capabilites - which are quite impressive - QuickBase Crank requires no external services or subscription fees and is widely supported in modern evergreen browsers. <br /><br /> The QuickBase Service Worker Council is also announcing a call for new members and new features to implement with Service Worker technology. If you would like to participate in the Service Worker Council meetings and deliberations or have a suggestion for using Service Worker technology with QuickBase feel free to reply to this message or contact me off-line using the information in my profile. question 1 2 2 comment 7493068 Show a numeric field from a different table without creating a releationship 2017-05-24T13:06:04Z 2017-04-06T05:04:54Z Gaurav Sharma sharma_gaurav Hi Team,<br /><br />I have a scenario where I have to show a numeric field without creating a relationship.<br /><br />I have done the same thing for showing an attachment like this and it's working fine:<br /><br /><pre>If([Country]="A", "&lt;a href="&amp;URLRoot() &amp; "up/" &amp; [_DBID_TEST] &amp; "/a/r100/e8/v0"&amp;"&gt;Test 1 Link&lt;/a&gt;", If([Country]="B", "&lt;a href="&amp;URLRoot() &amp; "up/" &amp; [_DBID_TEST] &amp; "/a/r42/e8/v0"&amp;"&gt;Test 2 Link&lt;/a&gt;", If([Country]="C", "&lt;a href="&amp;URLRoot() &amp; "up/" &amp; [_DBID_TEST] &amp; "/a/r28/e8/v0"&amp;"&gt;Test 3 Link&lt;/a&gt;", If([Country]="D", &lt;a href="&amp;URLRoot() &amp; "up/" &amp; [_DBID_TEST] &amp; "/a/r36/e8/v0"&amp;"&gt;Test 4 Link&lt;/a&gt;" ))))<br /></pre><br />Any workaround for this?<br /><br />Thanks in advance.<br /><br />Regards,<br />Gaurav Sharma question 2 2 1 comment 7524960 Show color legend on top of report 2017-05-24T12:12:39Z 2017-05-24T10:22:41Z Yoel Kuliasko yoel_kuliasko Hi,<br />I'd like to achieve what is described in&nbsp;<a href="" rel="nofollow"></a><br />but need more explanation. What is a hack? How exactly do I use it?<br /><br />Thanks, question 3 2 2 comment 7524938 how to use API_ImportFromCSV in php code? 2017-05-24T09:16:55Z 2017-05-24T09:16:55Z Hashmi V J hashmi_v_j how to use API_ImportFromCSV in php code?how to import csv file to &nbsp;quickbase table using php&nbsp; question 0 1 1 create 7438869 Concat Multiple Values from Child Records into Single Field in Parent 2017-05-24T05:43:34Z 2015-03-05T17:58:55Z gmcroberts gmcroberts <p>I want to be able to take multiple values from field SOMETHING from many records in my Child table and store in a single field SOMETHINGS in my Parent table.</p><p>For example in the Child I may have the following:</p><blockquote> <p>Record#1 - SOMETHING = A</p> <p>Record#2 - SOMETHING = B</p> <p>Record#4 - SOMETHING = C</p> <p>etc....</p> </blockquote><p>Then in my Parent table my SOMETHINGS field would read A,B,C etc...</p><p>I know I can do this with lookup fields however my SOMETHING field could have over 500 different values in different records and so this would take a lot of lookup fields.</p><p>I am looking for an easier way to do this, maybe using Dan Diebolts Image Onload Technique?</p><p>Any help will be greatly appreciated.</p> question complete 2 3 2 comment field, fields, parent, lookup fields, table, child table, child, parent table 7441792 creating a pop up box 2017-05-24T05:30:47Z 2016-11-01T19:51:16Z Shontay shontay <p>I want to create a pop up box and the user will answer the question and populate the field on the form</p> question 2 3 2 comment field, user, form 7440106 How to use JavaScript to concat child records into a single field? 2017-05-24T05:25:21Z 2015-12-16T15:49:09Z Justin justin_ake9dd5t4ki3h <p>I'm trying to learn how to concatenate multiple child records into a single field on a report. I have spent a lot of time searching google and the help forums and have come up with nothing. I don't want to use reverse look up because there could be a lot of records I'm returning or only 1. I figured the best way to accomplish this would be JavaScript. Maybe some tutorials on how to implement JavaScript functionality with QuickBase would help.</p> question complete 6 4 2 comment field, report, concatenate, javascript, child 7524410 Add Year (if Not Current) to MM/DD 2017-05-23T21:16:10Z 2017-05-23T15:55:56Z Amber amber_e74cfekf3phnp How would I change the formula to display the year IF it is not the current year?<br /><br />var text MM = Right(ToText(Month([Date])),2);<br /><br />var text DD = Left(ToText(Day([Date])),2);<br /><br />If(IsNull([Date]), "",<br /><br />$MM &amp;"/"&amp; $DD)<br /><br />Also, if records are sorted highest to lowest by the (new) field, will higher (more recent) dates appear ABOVE the dates for the previous years?<br /><br />I could sort by the [Date] field, but I concatenate the field above with another with some text details.<br /><br />Thanks! question 6 2 1 comment 7524645 Need to extract Active User list from Manage my Billing automatically & place it to a share point location.Kindly help? 2017-05-23T21:15:57Z 2017-05-23T21:15:57Z Ayush Jain ayush_jain_clhslmk9qk0og question 0 2 2 create 7524618 Can you change default page based on user? 2017-05-23T20:39:27Z 2017-05-23T20:30:41Z Jordan Beatty jordan_beatty I know I can set default pages based on user role, though is there an option I am missing where I can set the default page based on user?&nbsp; question 2 3 2 comment