Topics in QuickBase 1970-01-01T00:00:00Z 9889 9884 0 0 0 71 7505066 Change to Table Home Page....Is there a way to make the Advanced Search Form the way it was in the Table Home Page? 2017-04-24T15:04:53Z 2017-04-24T15:04:53Z Rodman91 rodman91 Hello, I think there was a change over the weekend that did something to the Table Home Page and the Advanced Search Form. Please see OLD and NEW image to see the difference. I know the change I am talking about is very minor, but to some it is major.&nbsp;<br /><br />The new Table Home Page with the Advanced Search Form as the default requires the user to select something in the drop down. The old way already had "&lt;Some Field&gt; contains" already selected in which helps our customer service rep save a second or 2 when trying to search for an order. Is there a way to select a default selection in the drop down? question 0 1 1 create 7505033 QuickBase Actions Instructions 2017-04-24T14:33:33Z 2017-04-24T14:29:15Z Christine christine_4pmgl18xc8nzq Just wondering if there are detailed instructions for QuickBase Actions?&nbsp; I was curious about deleting records.&nbsp; I have successfully used the Added and Modified Actions and was wondering how records are deleted in the 2nd app when deleted in the "Parent".&nbsp; Thanks! question 1 2 1 comment 7502833 Formula URL or Formula Text Button that will perform an action, without the need to navigate away from the current dashboard/report/record? 2017-04-24T14:31:45Z 2017-04-20T18:21:23Z Carlos carlos_8uxm64gcmogms Can I create a Formula URL or Formula Text Button that will perform an action, without the need to navigate away from the current dashboard/report/record??<br /><br />I have several checkboxes/dates/users that are stored via a Formula-Text button (I like to put images on the buttons instead of the normal gray ones). However, when clicked these must navigate away and redirect somewhere.<br /><br />Is there a way to avoid this, being able to click the button and have it execute the command (API_EditRecord) without having to refresh the page.&nbsp; question 18 3 1 comment 7505025 Is there an API call I can put into a Formula URL To allow me edit record with a different form? 2017-04-24T14:20:34Z 2017-04-24T14:20:34Z Manny De La Cruz manny_de_la_cruz The issue I am having is that I am using GenAddRecordForm and specifying the form, but this creates a duplicate record. Any way of just editing the record in a different form?<br /><br />Here is my current formula, everything works except the fact that its adding a record instead of editing in a dif<b></b>ferent&nbsp;form<br /><br />URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;&nbsp; &nbsp; "&amp;rid=" &amp; [Record ID#] &amp;<br />&nbsp; &nbsp; "&amp;apptoken=buawcnbd5pjszvdimycfs3jdpzd" &amp;<br />&nbsp; &nbsp; "&amp;_fid_313=Assigned" &amp;<br />&nbsp; &nbsp; "&amp;rdr=" &amp;<br /><br />URLEncode(URLRoot() &amp; "db/" &nbsp;&amp; Dbid() &amp; "?a=API_GenAddRecordForm&amp;dfid=2&amp;_fid_260=" &amp; URLEncode ([Agency Name])&amp;&nbsp;<br /><br />"&amp;_fid_57=" &amp; URLEncode (User())&amp;<br />"&amp;_fid=313=" &amp; URLEncode ("Assigned")&amp;<br /><br />"&amp;z=" &amp; Rurl()) question 0 1 1 create 7504116 "Time of day" report 2017-04-24T13:37:33Z 2017-04-22T19:35:58Z Rani Khoury rani_khoury I have a field of type "Time of day" that captures minutes of an activity on daily basis and I would like to have a report (Line and Bar Chart) that can show the daily captured values on the line , thanks for any help. question 12 2 1 comment 7501253 Relationship Issue 2017-04-24T13:33:26Z 2017-04-18T20:36:36Z Hans Hamm hans_hamm For this question I have 3 Tables: Associates, Travel and Oracle. What I need to do is the following. The Associates to Travel is fully functional, so I have travel going to City ABC and X,Y,Z associates are traveling.&nbsp;<br />What I can't seem to do is get the Oracle Table to tell me how many hours associates X,Y, and Z worked in city ABC.<br /><br />Master Table - Associates<br />Employee ID (Key)<br /><br />Details Table - Travel<br />Related Associates (Reference)<br /><br />I must be obtuse today because I cannot seem to figure out to get the Oracle Table in the "mix"<br /><br /><img src="" title="Image:" /> question 4 2 1 comment 7504965 Date stamp formula for checkbox 2017-04-24T13:08:13Z 2017-04-24T12:59:46Z Jae L neve_leem Hello.<br /><br />I have a quick question regarding date stamps.<br /><br />I have two check-boxes on my form: import and export. For both, I hope to create a formula date stamp field to see when users ticked these boxes. <br /><br />We have a few older records to see when they were imported and exported. When they built this application, they did not anticipate the importance of these check-boxes.<br /><br />Is this at all possible?&nbsp;<br /><br />Thank you very much for all of your help! question 1 2 1 comment 7504359 validate date fields before saving 2017-04-24T02:37:19Z 2017-04-23T12:59:15Z Thommango thommango I want to record the dates on which a boat will be leaving and returning to their dock. &nbsp;I don't want the return date to predate the departure date. &nbsp;I see how I can use a dynamic message to warn the user of invalid dates, but it lets them save it anyways. &nbsp;(Seems to me that "prevent save" would be a good action to include in dynamic forms.) &nbsp;But that doesn't seem to be an option. &nbsp;I thought maybe a formula field holding the duration between the two dates would also work, but I don't see how the calculated field would be validated. &nbsp;Am I missing something, or is this a glaring gap in the product design? question 2 3 2 comment 7504636 Table to table relationships using Sync'd data 2017-04-24T00:39:59Z 2017-04-24T00:32:23Z Anthony anthony_8hc6652fswm0b Hi. I'm importing data directly from Qbooks into a new table in Qbase. This imported data contains invoices / debtor info. I have a field call [job number] that matches a field in our existing table "Projects".&nbsp;I'm looking to create a relationship between them so i can start to combine the data in existing status formulas etc.&nbsp;<br />Is this possible? or is it better to try and merge the data.&nbsp;<br />Thanks question 1 2 1 comment 7438596 Can we not use fields and markers in the Subject Line or body Email Reminders? 2017-04-23T22:18:31Z 2015-01-20T18:51:33Z Juan juan_617duwa7hzh1n <p>Can we not use fields and markers in the Subject Line or body Email Reminders?<br /></p> question complete 14 3 1 comment fields, email, reminders 7504559 Not Seeing New Quickbase Actions 2017-04-23T21:59:35Z 2017-04-23T20:49:18Z Drew drew_k9ya3lgui4xuu Received the notice that today's patch went through, but i'm not seeing 'Quickbase Actions' as an option under table settings. &nbsp; question 2 2 1 comment 7502119 Problem with one of Dan Diebolt's pasties for embedding a bar graph in a form 2017-04-23T17:04:40Z 2017-04-19T21:30:25Z Neil Shepard neil_shepard So I am not sure where I am wondering off the path, but I can't follow Dan's Pastie #492<br /><a href=";r=rn&amp;rl=czr" rel="nofollow" target="_blank" title="Link https//haversineconsultingquickbasecom/db/bgcwm2m4gadrrrnrlczr">;r=rn&amp;rl=czr</a> <br /><br />I created the newest version of IOL but in following these directions I had to make a change based on what I saw in the code-see below.<br /><br /><u>[iol] value is:</u><br /><br /><b>&lt;img qbu='module' src='/i/clear2x2.gif' onload="javascript:if(typeof QBU=='undefined'){QBU={};$.getScript(gReqAppDBID+'?a=dbpage&amp;pagename=</b><br /><br /><u>[/iol] value is:</u><br /><br /><b>module.js&amp;rand='+new Date().getTime())};"&gt;<br /><br /></b><u>I created a Chart field of formula-text type:</u><br /><br /><b>[iol] &amp; "module.js" &amp; [/iol]</b><br /><b>&amp;</b><br /><b>"&lt;div class='QBU_Chart'" &amp;</b><br /><b>"&nbsp; data-rid='" &amp; [Record ID#] &amp; "'" &amp;</b><br /><b>"&gt;&lt;/div&gt;"<br /></b><b><br /></b>I copy &amp; pasted the code from the site, changing the variables for dbid and dbidtable1 to reference my tables, plus created an app token and changed that variable.<br /><b><br /></b>In my table I created columns with the same fruit headings and populated them with numbers. Below is a shot of what I get back when I look at the records:<br /><img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1585084/RackMultipart20170419-49413-1eusvxr-iol_test_inlineJPG1492637339" /><br />I know it's blurry, but in the charts field I just get the formula back.<br /><br />Any help is greatly appreciated! question 2 2 1 comment 7493293 Is there a way to just display top 10 results in a bar graph? 2017-04-23T04:04:23Z 2017-04-06T13:14:54Z Sania amna_anwar question 8 5 2 comment 7503679 Need to create a button that advances the selection on a Text - Multiple Choice field to the next entry. 2017-04-22T20:22:15Z 2017-04-21T20:59:50Z Nick nick_3emd8rslmfzwx I want to add a button to a form, which when pressed advances the selection on a Text - Multiple Choice field (fid_9) question 11 4 1 comment 7501460 Save Button that keeps me on the same form. 2017-04-22T16:12:58Z 2017-04-19T03:56:08Z bgstatdex bgstatdex I'm having an issue trying to create a Save Button that returns to the form the Button is on. The Form ID I've placed the Button on is 17. When I click the Save Button it goes to the Main Form. I'm using this: <br /><br /> "<a class="Vibrant Success" href="http://#" rel="nofollow">Save</a>" <br /><br /> Is there a place in the code where I can put the Form ID#? I've looked at several articles and it doesn't answer this exact question. Although I may be missing something as I'm new to code. question 9 6 2 comment