Topics in Quick Base 1970-01-01T00:00:00Z 13843 13684 0 0 0 472 7520040 How to create a Global Filter that will filter all reports and charts in one Home Page. 2019-02-24T00:29:22Z 2017-05-16T17:59:37Z Rohit Agarwal rohit_agarwal_5ie6ccs0ql4s6 I have a dashboard with multiple charts and reports coming from different source tables. I want a Global Filter that will filter all charts and reports on click. question active 16 5 1 comment 7854245 Formula Syntax Error 2019-02-24T00:17:37Z 2019-02-14T15:46:51Z Dirk Ruana dirk_ruana Hello:<br /><br />I am having difficulty with a formula syntax.&nbsp; I am pretty green, and sadly my skillset has some "developmental opportunities."<br /><br />I am trying to do some calculations for equipment rental based on days utilized (creating a minimum, daily, weekly, and monthly rates).<br /><br />Attached is my formula.&nbsp; I know I have made a bonehead mistake.<br /><br />Help please?<img src="" title="Image:" /> question active 17 4 1 comment 7851814 Text Field showing different values depending on the calculation 2019-02-23T21:00:35Z 2019-02-08T01:29:31Z Katrina E katrina_e I want a field to show&nbsp;value of "LT1" if it is less than 1 day late than the expected start of the program and other values depending on how many days it is late, I have this formula but it doesn't show the values when I test it<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />If(<br alt="" name="" rel="" target="" title="" type="" value="" />not IsNull([Started]),"NA",([Active Dif Calc]&gt;1),"LT1",([Active Dif Calc]&gt;7),"LT7")<br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 19 2 1 comment 7603275 URL to edit record and refresh to same spot on the report 2019-02-23T19:26:52Z 2017-09-30T19:16:35Z Robin CC robin_cc I have a table report with hundreds of records.&nbsp; If I scroll down the report, let's say 2/3 of the way down, and I press the URL button to edit one of the records down there, I want it to REFRESH to the SAME SPOT on that report such that I will not have to scroll down again.&nbsp; As it is, I always have to scroll down after each button press and this is painful when I am editing many records in this manner.&nbsp; <br /><br />I did use the following within my URL formula, and while it does refresh the page it does not go back to the same spot on the report.&nbsp; In fact, it was not anywhere close to the same spot on the report.&nbsp;<br /><br />"javascript:" &amp;<br />"$.get('" &amp;&nbsp;<br />$URL &amp;&nbsp;<br />"',function(){" &amp;<br />"location.reload(true);" &amp;<br />"});"&nbsp;<br />&amp; "void(0);" question active 2 3 1 comment 7857542 Is it possible to open File Attachment permissions to all users in Realm? 2019-02-23T16:04:51Z 2019-02-23T16:04:51Z Jacob Bailey jacob_bailey I have multiple apps for different departments within our organization, and all of our customers are viewable through sync tables with a central app storing the source data.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I have another table holding anywhere from 5-20 File Attachments per customer&nbsp;as individual records, and logging data tied to the file attachments. This table is also synced to each app. Any app can upload file attachments to the source Files table by adding a record to a hidden table within their own app which then posts a copy of that record to our source table through an API_EditRecord webhook, which then updates the connected table in their own app. They do not realize the hidden table even exists.&nbsp;The goal is that our end-users only appear to interact with the sync table in their related app for simplicity of use, however, they are really funneling data through the central app.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I have a button linked to the file on each record, and a user can download the file by clicking this button. This looks like the following:&nbsp;<a alt="" href="" name="" rel="nofollow" target="" title="Link httpsdrivegooglecomfiled1gLZOyzZjV3euCiVY2FEF0A70ZplgIaVrviewuspsharing" type="" value=""></a><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />The problem is that this only works for users with roles in the central app. All of the other users in our realm cannot download through the link, as they don't have access to that app.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I see that I'm able to open file attachment permissions to anyone without a login, but we are storing company-sensitive information that I do not want to open permissions for. I would like to open permissions for anyone in our realm to download file attachments from the Files table in our central app. Is this possible?<br alt="" name="" rel="" target="" title="" type="" value="" /> question 0 1 1 create 7857461 I need a text field that will yield different values depending on different conditions. 2019-02-23T12:42:35Z 2019-02-23T07:23:33Z Katrina E katrina_e I have posted about this a few weeks ago but I still need the right formula to it.&nbsp; I need a text field that will yield different values depending on different conditions.&nbsp; I need a field that will prompt "NA" if a project has been started on time, and them it will prompt L1 if the project is less than one day before the assigned start date and L7 if it's 7 days before the due date.&nbsp; This is what I have currently&nbsp;<br /><br /><br alt="" name="" rel="" target="" title="" type="" value="" /> question 1 2 1 comment 7700462 Automate Table CSV Export To SFTP Location 2019-02-23T02:25:23Z 2018-03-08T18:03:59Z Quincy Adam quincy_adam I am looking for a solution where I can export a table in a CSV format in some type of frequency (e.g. every 24 hours, or after x action takes place). What I'm trying to achieve is basically the same as Quickbase Sync, but exporting a file to a specified location rather than importing a file from a location.&nbsp;<br /><br />I can write an API to download the file locally, but it would be preferred if there's an option of doing the above without any manual intervention. question 3 3 1 comment 7857235 Record Creation Delayed 2019-02-22T23:38:30Z 2019-02-22T16:24:10Z Moses Blumenstiel moses_blumenstiel I have a URL which creates two related records, via an automation, and returns the user to a page.&nbsp; It definitely seems as if there is a small delay between clicking this button and when one of the records shows up in a report.&nbsp; For instance, if I click the button and land on the page, and then immediately click a link to go to a report the new record does not appear.&nbsp; But if I wait a moment it does appear.<br /><br />This is problematic.&nbsp; Any suggestions? question 6 4 1 comment 7857379 Table has no Date Modified Field? 2019-02-22T23:29:31Z 2019-02-22T22:53:18Z Malcolm Daniels malcolm_daniels_4vr3o995f8afq So my Table has no Date Modified field. How do I add one? question 3 2 1 comment 7857343 Enable users to choose whether or not to use conditional dropdown logic 2019-02-22T22:42:32Z 2019-02-22T20:47:16Z Alex Gale alex_gale_ch3tgjix8rnc1 A multiple choice reference field called "Contact" on one of my tables is set up as a conditional dropdown field. 90% of the time this works great for our purposes. Sometimes however, users would like to select a contact that isn't covered by the conditional dropdown logic. Is there a way for those users to manually activate an option or something to ignore the conditional dropdown logic at need? question 1 2 1 comment 7566448 Showing a child form in Parent Form 2019-02-22T22:02:01Z 2017-08-02T05:30:15Z Arshad Khwaja arshad_khwaja_7166138 Just wondering if we can actually embed the child form onto the parent rather than looking up values?&nbsp; question complete 6 7 1 comment 7857340 Issue with creating a Text formula with dates 2019-02-22T21:15:57Z 2019-02-22T20:36:00Z Matt Gill matt_gill_adkhtf5rt9ycs &nbsp;I am trying to set an alert that lets me know that it's 30 days or less until the [Effective_Date] ends. I cannot seem to get the formula or formula type to work. <br /><br />&nbsp;If ([Effective_Date]-Today()&lt;=30,"Renew","Good")&nbsp;<br />Any assistance would be greatly appreciated. question 2 2 1 comment 7857337 Text To Proper Case 2019-02-22T20:26:32Z 2019-02-22T20:26:32Z Printmark mark_corcoran_5o61f6xdaev2r Is there a way I can make text entered into a text box convert to Proper Case before saving?<br /><br />This sounds like it should be a very easy thing to do, but I searched and didn't find anything about it. I did see where functions for Upper and Lower can be applied, but not Proper Case. question 0 1 1 create 7857330 Changing order of conditional drop down selection 2019-02-22T20:17:00Z 2019-02-22T20:17:00Z Xenia Watterson xenia_watterson We are trying to build out an inventory database that shows products available and the stores you can buy them at.&nbsp; I understand how to set up Conditional drop downs (Manufacturer limits Make limits Model) but what if you want to be able to search by more than one starting point.&nbsp; So you can see that XXX Company makes 3 types of TVs (36", 55" and 70").&nbsp; The 36" inch TV can be purchased from Vendor A or Vendor B, the 55" TV is available from Vendor C and Vendor A, and the 70" TV is available from Vendor B and Vendor C.&nbsp; But could you start by selecting Vendor A and seeing that they sell TV and stereo equipment and the TVs they sell are available in 36" or 55".&nbsp; Think using the Filter function on Excel and selecting any column on your spreadsheet and seeing the rows drop down from there. question 0 1 1 create 7857172 Color Coding a report that is displayed in a form to indicate which workorder you're currently in. 2019-02-22T19:52:51Z 2019-02-22T14:03:53Z Brad Lemke brad_lemke Scenario:&nbsp; In my [WorkOrders] table, I am tracking deliveries to addresses as well as managing the various projects that these deliveries are for.&nbsp; There are times where I make multiple deliveries to the same address, all to different sub-projects of the same overall project.&nbsp; As a result, I have a report displayed in the project actions tab of the form to displays all orders to the address referenced in this workorder.<br /><br />I would like to know if there's a way to color-code, highlight, or in some other way indicate which workorder I'm currently in/editing so I (and my collegues) can quickly identify it. question 4 3 1 comment