Topics in QuickBase 1970-01-01T00:00:00Z 9690 9686 0 0 0 61 7483476 Since I can't use form rules on API Add/Edit record are there any other options to trigger those rules? 2017-03-23T22:51:07Z 2017-03-23T22:35:27Z Karl karl_6wcg0w6xemr9a Since I can't use form rules on API Add/Edit record, are there any other options to trigger those rules after the records are loaded on a table without opening each one and saving? I'm manipulating and parsing data from a string field the API writes to, and need to update the UI fields.&nbsp; I'd prefer to keep the parcing logic in quickbase and I have all the rules working great when I edit as the API user. question 1 2 1 comment 7483331 Right clicking is not showing anything related to QuickBase 2017-03-23T22:38:03Z 2017-03-23T19:11:24Z Neil Shepard neil_shepard So this may be a computer issue versus a QuickBase issue, but in Chrome on Windows 10, I can't right click and have perform any a function in QuickBase except for cut &amp; paste. &nbsp;Is this an artifact of the Windows environment, Chrome, a new update, lack of some extension, etc?<br /><br />Thanks for any help to guide me. question 4 2 1 comment 7435135 how do i filter contacts that have empty fields? 2017-03-23T22:31:06Z 2013-07-18T19:31:03Z Kelly kelly_figpd4oh2mqcw I want to run a query and one of the parameters is that I need to find contacts that DO NOT have any information in one or more fields. They would be empty. How do I run that filter? question complete 11 2 1 comment query, fields, filter 7481926 Look up a drop down values from parent 2017-03-23T21:58:38Z 2017-03-22T04:40:00Z Arshad Khwaja arshad_khwaja_7166138 I have a parent stores table and and projects child table. &nbsp;In cases, where we have a project established with a view to close the project, we would like to nominate another closest store that can catch customers. &nbsp;So in my projects record, I would like to have a drop down to allow user to select a store from store table. &nbsp; I do have a relationship established. I created a new text field 'adjoining store' but stuck on getting the drop down to work. &nbsp;Will appreciate some help.&nbsp; question 6 3 1 comment 7483350 Repeating conditional lookup on a form 2017-03-23T21:17:55Z 2017-03-23T19:38:18Z Joey Zint joey_zint I have a form that I am trying to do multiple lookups on a form from the same source table<br /><br />I have a form that has six individual items that I need to make an entry on<br /><br />The process would be this<br /><ul><li>Select a refrigerant from the master refrigerant table...this table has a refrigerant list, a series of pressures and temperatures in three columns</li><li>Enter a pressure for each piece of equipment</li><li>This pressure entry needs to do a pressure to corresponding temperature lookup</li><li>The tech then enters a temperature reading and this does a calculation in another field to subtract the converted pressure to temperature from the temperature reading</li></ul>Example attached.<br /><br />I am thinking I need to split my Refrigerant PT Chart into multiple tables so that I can setup (6) individual lookups...<br /><br />Thanks in advance for any help possible<br /><br /><br /><img src="" title="Image:" /> question 3 2 1 comment 7483382 How do I get an Image (file attachment field) to appear on the list report of main table page? 2017-03-23T20:53:26Z 2017-03-23T20:16:57Z Priscila Cavalcante priscila_cavalcante How do I get an Image, which is currently a field in a form as a "file attachment", to appear as a much smaller version on a list report pertaining to that table? question 1 2 1 comment 7482632 How to get webhook to fire for all records not just the first one to change 2017-03-23T20:25:11Z 2017-03-22T22:05:25Z Stephen stephen_ikvesub40np73 I wrote a webhook and tested it by changing a flag field in a number of records (via gridedit). Unfortunately, only the first record was updated, all the rest were ignored. I assume my code is faulty, not repeating for all the changes in all the records? &nbsp;<br />1. The Source Table where the webhook resides is a connected CSV table<br />2. The Destination Table is also Connected CSV (a different source file)<br />3. I used EditRecord<img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1571342/RackMultipart20170322-3891-dt9d7y-Screen_Shot_2017-03-22_at_180423__inlinepng1490220315" /> question 9 4 1 comment 7483286 MS Excel style Sort & Filter plus Search 2017-03-23T20:11:23Z 2017-03-23T18:29:35Z Neil Shepard neil_shepard Is there a way to sort, filter and search a column like Excel? &nbsp;The arrow in the column only provides grouping. &nbsp;Some of my columns contain individual numbers, but I want to filter based on several columns. &nbsp;These choice of columns aren't always the same either.<br /><br />Please pardon the simplicity of the question. &nbsp;I am trying out QuickBase for the company to move out of Excel and into a better system, so I am not up to speed on all the possibilities or limits.<br /><br />Thanks!&nbsp; question 6 3 1 comment 7483063 Having a problem with the Dynamic Form Rules 2017-03-23T19:52:29Z 2017-03-23T14:24:05Z Jeannette Bagnoli jeannette_bagnoli I am having a problem with Dynamic Form Rules not "sticking". In a connected table (child) there is a field for "commodity" (from parent table) that when selected will show the price (in a snapshot field of a reference field) for that specific commodity. &nbsp;<br /><br />There is one commodity that the price changes day to day so I added a field for manual input. I set up a form rule to state that when this commodity was selected to "hide" the snapshot field and "show" the manual input field. <br /><br />In edit mode it works...the snapshot field is hidden and the manual input is shown. As soon as the record is saved it changes back showing the snapshot field and hiding the manual input field.&nbsp;<br /><br />I have never had a problem with dynamic form rules before. &nbsp;Is there something I am missing or doing wrong? question 5 2 1 comment 7442167 Search is not working properly 2017-03-23T19:45:36Z 2017-01-17T17:25:26Z Karen karen_j4v30ea3vgjqh <br /><br /> Hello! <br /><br /> I created a new app recently and have noticed something odd... The search function (the search box at the top of the report) only seems to work on fields that are in the report that I’m viewing.<br /><br /> <br /><br /> In my other apps, I can (for example) type in the Record ID and the record I’m searching for shows in the search results – this happens even when the Record ID is not a field in the report.<br /><br /> <br /><br /> This works for any field in my other apps. I can type in a word or phrase and any record that has that that word or phrase in it, shows in the search results.<br /><br /> <br /><br /> &nbsp;In the new app, it doesn’t work this way. I can only search within the fields that are on the report.&nbsp;&nbsp;<br /><br /> <br /><br /> I can’t find any global setting that would control this. I’ve checked the fields and they all have the “Include this field when searching/filtering this table” box checked.<br /><br /> <span><span>Do you have any thoughts on how/why this wouldn’t be working in my new app?<br /></span><span> Thanks very much!!<br /> <br /> </span></span> question complete 10 3 1 comment field, report, fields, record id, search, table, record id#, record 7483173 Add leading zeros to Form ID # to make even length 2017-03-23T18:33:12Z 2017-03-23T15:46:20Z Traci S traci_schefdore <p>I am using the following formula to add leading zeros to a request # field I created on a form. </p><p>"Request"&amp;Right("000" &amp; ToText([Record ID#]),5) </p><p>I would like to limit the number of characters to 11 and have the leading zero's be consumed as the record id # increases. </p><p>For example:</p><p>"Request00012" should be "Request0012"</p><p>Is there a way I can modify the field or form to do this?</p> question 3 3 1 comment 7482527 Combining multiple groups into few groups 2017-03-23T18:17:57Z 2017-03-22T19:42:03Z Anurag Sharma anurag_sharma_69tg5gksge2og Hi Guys, I wanted to combine data and group these 12 categories into 4 categories. How can i group together data, so that my report shows only 4 category colors instead of 12<img src="" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1571270/RackMultipart20170322-122596-qk8fg0-Capture_inlinePNG1490211577" /> question 3 3 1 comment 7483134 Is there a way to adjust the time that an automatic report email goes out from Quickbase to users? 2017-03-23T17:30:56Z 2017-03-23T15:11:34Z Jerrod Mills jerrod_mills I have reports that sent out of Quickbase on selected days to users. Is there a way to adjust the way the time of day that the subscription report is sent out? Currently all my reports go out around 4 am on the day they are to be sent.&nbsp; question 7 5 1 comment 7439264 Cannot add attachment in grid edit mode 2017-03-23T15:35:27Z 2015-07-14T14:24:04Z Bastien bastien_2e54sitgnh0i0 <p>Hi,</p><p>I am creating a form with a child table inside it and I want to be able to add attachment in grid edit mod but it seems that I can't...</p><p>Any thoughts ?</p><p>Thanks,</p> question complete 6 4 1 comment add, edit, grid edit, table, child table, form, child, attachment 7482342 How to Copy Record and Copy Children 2017-03-23T12:27:16Z 2017-03-22T16:08:16Z Sarah Wallis sarah_wallis_hfkalb3owf1d7 <p>My QB has a table of "Invoices". Each month the users "copy" the invoice for the new month. Most fields stay the same, including a list of children "Lines". When they copy an invoice, the child lines are not also copied. Why is this?</p><p>As per many-to-many rules, I created a "hidden" Invoice-to-Line table that is just the "Related Invoice" and "Related Line" (and the fields in the relationship). I guess I need to have QB create new entries in Invoice-to-Line&nbsp;when an Invoice is copied, with all of the Lines connected to the new Invoice.</p><p>Is this possible? (An Invoice can have up to 200 Lines, so this is a requirement for the users.) How do I implement this? </p><p>Thanks in advance!</p> question 13 4 1 comment