http://m.getsatisfaction.com/companies/quickbase/topics?page=1 Topics in Quick Base 1970-01-01T00:00:00Z 13164 13029 0 0 0 371 http://m.getsatisfaction.com/topics/7808626 7808626 Add a record to one table through a form in another table 2018-10-23T23:13:26Z 2018-10-23T23:09:22Z Tami Campos http://m.getsatisfaction.com/people/9699607 https://www.gravatar.com/avatar/3b5996c4584c3af803e2ed8ef021ee83?d=identicon&s=55&r=PG tami_campos_1samqypzt1gns I am new to QuickBase and am not a developer but am trying to simply update one table by entering data into a form from another table. I have created a relationship between the two tables.&nbsp; Is it possible without using API?<br /><br />Details:&nbsp; I have an Events Table which has a form that includes the Related Artist Name field.&nbsp; I want to enter a new Event inculding the Artist Name and have it update the Artist Table.<br /><br />TIA question 1 2 1 comment http://m.getsatisfaction.com/topics/7808546 7808546 Displaying Linked Exchange Body Fields 2018-10-23T19:26:54Z 2018-10-23T19:26:55Z Andrew http://m.getsatisfaction.com/people/8808939 https://www.gravatar.com/avatar/817e0e680a7d2d84c13faff526a8ab55?d=identicon&s=55&r=PG andrew_4uud134wnj6o9 Hello All,<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I have a synced exchange table that pulls email records into a table. The purpose of this linked table will be to display email history relating to a specific candidate.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />The exchange fields it pulls in for the email body are [RawBody] and [Body]. [RawBody] is pure HTML and [Body] is text.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />The problem I am running into is if there is an email chain, these body fields contain all the reply history. Ideally I'd like to remove the reply history but can't seem to create a formula in Quickbase that can parse either Body field. I would think it would be easiest to work with the [RawBody] field.<br alt="" name="" rel="" target="" title="" type="" value="" /><br />Does anyone have a suggestion?<br /><br alt="" name="" rel="" target="" title="" type="" value="" />Example of an Email [RawBody] field from gmail (with the message I want displayed in bold):<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><blockquote>&lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8"&gt;&lt;div dir="ltr"&gt;<b>Thanks! I look forward to hearing from you!</b>&lt;div&gt;&lt;br&gt;&lt;div class="gmail_quote"&gt;&lt;div dir="ltr"&gt;On Tue, Oct 23, 2018 at 9:52 AM email @ &lt;a href="<a alt="" href="http://myCompany.com" name="" rel="nofollow" target="" title="" type="" value="">http://myCompany.com</a>" target="_blank"&gt;MyCompany.com&lt;/a&gt; (via Quick Base) &amp;lt;&lt;a href="mailto:<a alt="" href="mailto:notify@quickbase.com" name="" rel="nofollow" target="" title="" type="" value="">notify@quickbase.com</a>" target="_blank"&gt;<a alt="" href="mailto:notify@quickbase.com" name="" rel="nofollow" target="" title="" type="" value="">notify@quickbase.com</a>&lt;/a&gt;&amp;gt; wrote:&lt;br&gt;&lt;/div&gt;&lt;blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"&gt;&lt;u&gt;&lt;/u&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp;&nbsp;&nbsp;&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />&lt;div&gt;<br />&lt;table border="0"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td style="font-family:Helvetica Neue,Helvetica,Tahoma,Arial,sans-serif;font-size:10pt"&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Hello,&lt;br&gt;<br />&lt;br&gt;<br />This was the original message.&lt;br&gt;<br />&lt;br&gt;<br />Thank you again for contacting us. We appreciate your time.&lt;br&gt;<br />&lt;br&gt;<br />Sincerely,&lt;br&gt;<br />Us&lt;br&gt;<br alt="" name="" rel="" target="" title="" type="" value="" />&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;<br />&lt;/div&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /></blockquote><blockquote alt="" name="" rel="" target="" title="" type="" value="">&lt;/blockquote&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;<br alt="" name="" rel="" target="" title="" type="" value="" /></blockquote><br alt="" name="" rel="" target="" title="" type="" value="" /> question 0 1 1 create http://m.getsatisfaction.com/topics/7808051 7808051 Automatic website import to QB field 2018-10-23T17:44:31Z 2018-10-22T20:53:37Z Andrew Hagaman http://m.getsatisfaction.com/people/9827820 https://www.gravatar.com/avatar/5006d1a4716c8a4bfffa5ff11902e08f?d=identicon&s=55&r=PG andrew_hagaman We are trying to create a field/fields that will pull rates from <a alt="" href="http://www.snaprates.com" name="" rel="nofollow" target="" title="" type="" value="">www.snaprates.com</a>&nbsp;into Quickbase that can be automatically update. Any help on this would be great. Thank you.&nbsp;&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question active 6 4 2 comment http://m.getsatisfaction.com/topics/7791153 7791153 Lookup and fill field values based on the content of another table 2018-10-23T15:38:42Z 2018-09-11T13:51:32Z Tyler Parker http://m.getsatisfaction.com/people/9611054 https://www.gravatar.com/avatar/43792c0add24635647e7b61a40a96df6?d=identicon&s=55&r=PG tyler_parker_es9d6qjxj9duk I have two tables:<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Table A holds records for daily delivery routes, two of its fields are the [Driver Name] and [Van ID].<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Table B holds records of every stop completed on all daily routes, it also has the fields [Driver Name] and [Van ID].<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />The stop records in Table B are imported via an API call to a platform which records GPS tracking data for each van. The [Van ID] is obtained with the call, but the [Driver Name] cannot be.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />What I want to do is for every record in Table B, where the [Van ID] = "123", for example, I want to lookup in Table A which delivery route had [Van ID] = "123" and find the associated driver name, and show it in the Table B record(s).<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Has anyone had any experience with a problem like this? Thanks question complete 9 2 1 comment http://m.getsatisfaction.com/topics/7808365 7808365 Create New Record Button Only Works for Admins 2018-10-23T14:07:02Z 2018-10-23T13:53:40Z Meagan http://m.getsatisfaction.com/people/9828732 https://www.gravatar.com/avatar/9d94d8a18d0a93b344668189825fd51f?d=identicon&s=55&r=PG meagan_bryan Hi all,<br alt="" name="" rel="" target="" title="" type="" value="" />I'm very new to QB. I have inherited a simple app. We have a button on a dashboard to create a new record in a table. But a user with any role other than Admin (from the User Roles) gets an access denied error message when they click the button. If I make that same person an Admin, they can create a new record without issue.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />There are 2 forms for that table: "quick entry" and "main form". When defining how roles use the forms, all roles are defined the same way: Add is set to quick entry form and View/Edit is set to the main form.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Other notes: I don't have full/create authorization in QB and am not the official App Owner. I have full admin access but I am finding there are some things I can't do. I've requested access but I don't have it yet. In the mean time, I really need to get this button working and I am hoping you all can help me. Thanks so much in advance!<br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 2 2 1 comment http://m.getsatisfaction.com/topics/7808328 7808328 formula text - floating decimal places 2018-10-23T12:52:23Z 2018-10-23T12:52:23Z Lori Armstrong http://m.getsatisfaction.com/people/9828670 https://www.gravatar.com/avatar/343be0846e2c8b50150169692f44927a?d=identicon&s=55&r=PG lori_armstrong Currently converting a numeric field to a text field, but i need to be able to display the decimal places properly. Sometimes there are 3 or 4.. Thinking an If statement will take care of it, nut not sure where to start with the conversion.<br /><br />Currently using the below.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />-----<br alt="" name="" rel="" target="" title="" type="" value="" />var number Value = Round([Rate 1],0.01);<br alt="" name="" rel="" target="" title="" type="" value="" />var text Decimals = "." &amp; Right(ToText(Int($value * 100)),2);<br alt="" name="" rel="" target="" title="" type="" value="" />var text Thousands = If(Abs($Value)&gt;=1000,ToText(Int(Abs($Value)/1000)));<br alt="" name="" rel="" target="" title="" type="" value="" />var text Hundreds=Right(ToText(Int($Value)),3);<br alt="" name="" rel="" target="" title="" type="" value="" />var text Millions = If($Value&gt;=1000000,ToText(Int($Value/1000000)));<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />If($value&gt;=1000000,"$" &amp; ToFormattedText($value, "comma_dot") &amp; $decimals,<br alt="" name="" rel="" target="" title="" type="" value="" />//If($value&gt;=1000000,"$" &amp; ToFormattedText($value, "comma_dot"),<br alt="" name="" rel="" target="" title="" type="" value="" />If($Value=0,"$0.00",<br alt="" name="" rel="" target="" title="" type="" value="" />If($Value&lt;0, "- ")<br alt="" name="" rel="" target="" title="" type="" value="" />&amp;<br alt="" name="" rel="" target="" title="" type="" value="" />"$" &amp; List(",",$Millions,$Thousands,$Hundreds) &amp; $Decimals))<br alt="" name="" rel="" target="" title="" type="" value="" />//"$" &amp; List(",",$Millions,$Thousands,$Hundreds)))<br />------ question 0 1 1 create http://m.getsatisfaction.com/topics/7682784 7682784 How can I troubleshoot Quick Base performance? 2018-10-23T12:15:58Z 2018-02-07T14:15:42Z Brian Cafferelli http://m.getsatisfaction.com/people/8730830 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11092450/brian_cropped_medium.jpg brian_cafferelli <img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1701136/17154-16uyj70_inline.png?1518012754" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1701136/17154-16uyj70_inlinepng1518012754" /><br /><br /><br /> <i>[The Quick Base Knowledge Base is your library of frequently-asked questions that help you better customize your apps to solve your business problems.]</i><br /><br /><br /> The Quick Base team takes performance very seriously. We constantly monitor the software and we use the information we gather to tune our software. We currently monitor our systems in the following ways:<br /><br /> <ul><li>We have geographically dispersed systems that monitor Quick Base performance and report back to our operations team daily.</li><li>We have an independent firm testing multiple Quick Base operations from multiple sites across the United States every hour.</li><li>Our data center team monitors our machines, the internal network performance, and the bandwidth to and from our data center continually.</li></ul> If you are experiencing a slowdown or delays, we suggest you take the following steps:<br /><br /> <b>1) Test your internet connection speed.&nbsp;</b>You can do this by running the test at&nbsp;<u><a href="http://www.speedtest.net/" rel="nofollow" target="_blank">http://www.speedtest.net/</a></u>. You can see varying performance of your connection throughout the day.<br /><br /> You can also check the overall health of the Internet at&nbsp;<u><a href="https://www.akamai.com/us/en/solutions/intelligent-platform/visualizing-akamai/real-time-web-monitor.jsp" rel="nofollow" target="_blank" title="Link https//wwwakamaicom/us/en/solutions/intelligent-platform/visualizing-akamai/real-time-web-monitorjsp">https://www.akamai.com/us/en/solutions/intelligent-platform/visualizing-akamai/real-time-web-monitor...</a></u><a href="http://www.internetpulse.net/" rel="nofollow" target="_blank" title="wwwinternetpulsenet/">/</a><br />Here you can see if there are latency or availability problems currently being experienced throughout the net.<br /><br /> Also, if a Quick&nbsp;Base page's header appears quickly before the page is completely displayed, then Quick&nbsp;Base has processed your request, but you are constrained by your internet connection and/or the speed of your computer.<br /><br /> <b>2) Compare the performance of Quick Base to other Internet sites that use HTTPS encryption.&nbsp;</b>For example, visit the Amazon.com account info page at&nbsp;<a href="https://www.amazon.com/gp/css/homepage.html" rel="nofollow" target="_blank" title="https//wwwamazoncom/gp/css/homepagehtml">https://www.amazon.com/gp/css/homepage.html</a>&nbsp;and compare the performance of that page versus Quick&nbsp;Base. Make sure that the address bar contains "HTTPS" (not HTTP). Many reported Quick&nbsp;Base performance issues are due to customer firewall problems that affect all HTTPS sites.<br /><br /> <b>3) Monitor performance to help isolate the issue.</b>&nbsp;Pay attention to:<br />- When delays happen – specific days or times of day.<br />- Delays using a specific Quick&nbsp;Base application, and not others.<br />- Specific actions that seem to take longer<br />- Specific groups or roles that experiences longer delays<br /><br /> <b>4) Review your application.</b><br />There are times where slowness can be attributed to applications and the amount of data they contain or the way they are setup and used. Here are some tips and tricks that should help you ensure you are getting the best performance possible out of your applications:<br /><br /> <b>a) Minimize which fields are searched.</b><br />Whenever someone attempts to find records by clicking the&nbsp;<img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1701125/17154-12tplia_inline.jpg?1518011490" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1701125/17154-12tplia_inlinejpg1518011490" />&nbsp;icon at the top of the page, Quick Base needs to figure out which fields to search for the information. For example, if you use the search function and haven't done anything to limit the search, Quick Base will search every field in every table across all records. The smaller the number of fields Quick Base searches, the faster the response from Quick Base. Here are some ways you can limit the number of fields searched:<br /><br /> - Create a report that uses matching criteria that is setup to ask the user for the information they want to search for and then Quick Base searches that specific field only. For example, if your team generally brings up contact information by searching for names, you can have the report ask and then search for the contact name in that one field.<br /><br /> - You can exclude certain fields from being included in Quick Find searches. Each field has a property called “Include this field when searching/filtering this table."&nbsp;By default, Quick Base searches every field; however, if you uncheck this property for any field, you can tell Quick Base to skip over this field when performing a Quick Find or any search that uses &lt;Some field&gt; as search criteria.<br /><br /> Note that you can access this property for an individual field on its field properties page. You can also exclude several fields at a time using the field listing page. (To learn more, please see our&nbsp;<a href="https://help.quickbase.com/user-assistance/#prevent_searching_in_field.html" rel="nofollow" target="_blank" title="Link https//wwwquickbasecom/user-assistance/defaulthtmlprevent_searching_in_fieldhtml">Prevent QuickBase from Searching Fields</a>&nbsp;help topic.<br /><br /> -You can also exclude entire tables from Quick Find searches using property called "Include this table while searching." This property lets users choose whether Quick Base should include the table in Quick Find searches. Excluding one or more tables from Quick Find searches forces users to use the Find Record functions from the table menus and can significantly improve performance. Combining this with the suggestions above and below can be very effective.<br /><br /> <b>b) Minimize the number of Embedded Reports</b><br />Each time a form is rendered with embedded reports, Quick Base needs to do a fair amount of work to apply any security and report logic (matching, sorting, etc) for the embedded report(s). If an application has complex custom rules for roles and large numbers of records, it can improve performance if you cut back on the number of embedded reports because each one has overhead associated with the logic required to display that report. Instead, if you can display one embedded report that shows all the appropriate records with sorting and grouping.<br /><br /> <b>c) Archive Data.</b><br />The more data in an application, the more work Quick Base has to do to apply any application logic you have built (e.g. custom rules, report criteria, etc). If you can automate the export of data so that applications only contain relevant information, applications will perform better.&nbsp;<br /><br /> <b>d) Review Field Usage. </b>Here are a few things to consider about the fields and their usage:<br />- Prefer formula fields over a report-specific custom column. Formula fields have better performance characteristics than a custom column in a report.<br />- Reduce the creation of summary and lookup fields: If you find that you do not need some formula, lookup or summary fields, delete them.<br /><br /> <b>e) Limit Use of Custom Rule Permissions</b><br />When creating roles, the use of "custom rules" (aka "custom permissions") significantly slows an application's report generation performance. This is especially true when the custom rule depends on a formula, summary or lookup field.<br /><br /> <b>f) Design Reports for Speed</b><br />When you are creating reports and filtering records, filter for user input fields BEFORE filtering for derived fields. User input fields are fields that you enter data into. Derived fields are fields like formula fields, lookup fields and summary fields whose values are "derived" from user input fields. Derived fields take longer to compute because the data needs to be "updated" for every request. Including user input fields before derived fields is faster because Quick Base can "skip" certain records without having to evaluate the values of the derived fields since the user input fields might already exclude the record from matching the query. In some cases, doing this can result in significant performance gains.<br /><br /> Here is a short example:<br /><br /> Suppose your report's matching criteria looks like this:<br /><br /> [A summary field] IS 10 AND<br />[A text field] IS 'Auto'<br /><br /> Rewrite this to be:<br /><br /> [A text field] IS 'Auto' AND<br />[A summary field] IS 10<br /><br /> For those records where the value of the "A text field' is not Auto, Quick Base will not need to compute the value of the [A summary field].<br /><br /> Along these lines, try to exclude as many derived fields from your reports as possible. In other words, even if you do not use the derived fields in your matching criteria, if they need to be displayed in the report, they need to be calculated. If you do not need to show these fields, exclude them from the report.<br /><br /><br /> 5) If you have gone through the above steps and you are not able to isolate the problem any further, then please help us understand your specific situation by submitting a support case and answering the questions stated above. You can open a case by clicking&nbsp;<img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1701125/17154-12tplia_inline.jpg?1518011490" title="Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1701125/17154-12tplia_inlinejpg1518011490" />&nbsp;icon at the top of the page while you're logged into Quick Base, clicking&nbsp;<b>Manage Support Cases</b>, then click&nbsp;<b>+ New Support Case</b>. article 2 3 2 comment http://m.getsatisfaction.com/topics/7806767 7806767 How to display report by applying filters using dropdown lists on the form ? 2018-10-23T05:48:05Z 2018-10-19T12:05:10Z Murali Krishna Gangineni http://m.getsatisfaction.com/people/9820546 https://www.gravatar.com/avatar/a45d30efee0005a8920cee098a8d309b?d=identicon&s=55&r=PG murali_krishna_gangineni I have a table named <b alt="" name="" rel="" target="" title="" type="" value="">Table1</b> .&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />I want to give the USER the dropdown list options on a form to apply filters on columns <b alt="" name="" rel="" target="" title="" type="" value="">Column1, Column2, Column3, Column4 </b>.<br alt="" name="" rel="" target="" title="" type="" value="" />When the user selects a value from the <b alt="" name="" rel="" target="" title="" type="" value="">dropdown list of Column1</b>, The related values should popup in the <b alt="" name="" rel="" target="" title="" type="" value="">Column2</b>. If the user selects a value from Column2 then show the related values in Column3, Like wise in Column4.<br alt="" name="" rel="" target="" title="" type="" value="" />So after the user selects the values from the four dropdown lists i want the report to be shown.<br /><br />How to do this in QUICKBASE ?<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /><b>Note:</b> If the user selects only one dropdown list and dont selects remaining three dropdown lists , then also i want to apply filter on that particular column only and show the report.<br alt="" name="" rel="" target="" title="" type="" value="" /> question active 4 3 1 comment http://m.getsatisfaction.com/topics/7808196 7808196 How to show filtered report on a form after filtering using four drop-down lists using the form 2018-10-23T05:37:36Z 2018-10-23T05:37:36Z Murali Krishna Gangineni http://m.getsatisfaction.com/people/9820546 https://www.gravatar.com/avatar/a45d30efee0005a8920cee098a8d309b?d=identicon&s=55&r=PG murali_krishna_gangineni I want to filter a table using four drop-down lists on a form and show the filtered report on the same form based on user selection of the drop-down lists<br />How to achieve this in QuickBase ? question 0 1 1 create http://m.getsatisfaction.com/topics/7806593 7806593 Creating a daily sales report that also has a column for YTD cumulative values 2018-10-22T22:52:51Z 2018-10-18T23:18:44Z Casie Masters http://m.getsatisfaction.com/people/9624625 https://www.gravatar.com/avatar/3a9b4f425922a709e05274ab6cca9d1b?d=identicon&s=55&r=PG casie_masters I have monthly report that summarizes GM $$ amounts by day.&nbsp; I need to add a column that has the YTD GM total next to it and have it be the YTD for just that day.&nbsp; So for instance if viewing April's reports, the YTD would only display YTD as of that day in April and not of the true current YTD amount as of Oct 18th.&nbsp; &nbsp;I'm not sure how to create the field and have it summarized by the day.&nbsp; question active 7 4 1 comment http://m.getsatisfaction.com/topics/7807799 7807799 can we call macro and automation anywhere in quikbase? 2018-10-22T20:36:09Z 2018-10-22T13:03:11Z Tejasvita Dhuri http://m.getsatisfaction.com/people/9827124 https://www.gravatar.com/avatar/a381f035f03bf7015049ec497153f2d2?d=identicon&s=55&r=PG tejasvita_dhuri I want to perform some operation on SAP in middle of quick base project. question active 2 4 1 comment http://m.getsatisfaction.com/topics/7807868 7807868 How to Hide or Disable 'Search for Address' field in Forms 2018-10-22T19:03:33Z 2018-10-22T15:04:26Z Brad Lemke http://m.getsatisfaction.com/people/9680382 https://www.gravatar.com/avatar/ee7961abd53719c82bcbc91d59a89586?d=identicon&s=55&r=PG brad_lemke My app is designed for workorder entry in the construction industry, and the vast majority of addresses entered do not exist yet.&nbsp; The 'search for an address' field does not help, and is even a liability at times.&nbsp; How can I hide or disable this part of the 'Address' type field? question complete 11 3 1 comment http://m.getsatisfaction.com/topics/7806787 7806787 Use New/Updated Flag in Report Filter 2018-10-22T17:35:25Z 2018-10-19T13:24:49Z Tate Forgey http://m.getsatisfaction.com/people/9652236 https://www.gravatar.com/avatar/7f4a705bbd79c9197aba3b225f414cfc?d=identicon&s=55&r=PG tate_forgey I realize that many people don't want to see the new/updated flag, but I've got some people who LOVE it.&nbsp; In fact, I have created reports on all the tables in their app that shows only new/updated records so it can be displayed on their homepage, which is easy enough using the checkbox to do that at the bottom of the report definition.&nbsp; <br /><br />However, we have hit the 9 report limit on their homepage and they want more. It seems to me that these new/updated reports are largely wasted space most of the time or sometimes duplicate other reports that are showing "In Progress" records, for instance.<br /><br />So, what I'd really like to do is have those flag values as an actual field.&nbsp; That way, I wouldn't just have to show only those records I could create an "any" filter to show status = in progress OR flag = updated or new.&nbsp; Can you access these values in any way?&nbsp; For instance, could I create a calculated field that somehow had a value set based on what the flag value was?<br /><br />In lieu of that, if there was a way to use the results of one report in another report I could keep the new updated report and use that as a condition in an "any" filter.&nbsp; I don't really see a way to do that either, though. question active 4 4 1 comment http://m.getsatisfaction.com/topics/7807716 7807716 Has anyone tried a way of getting outside data into Quickbase via REST or SOAP? 2018-10-22T14:52:19Z 2018-10-22T08:31:30Z Jack Fretwell http://m.getsatisfaction.com/people/9751973 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11309419/me_medium.jfif jack_fretwell We'd like customers to zap orders directly to our company via an API.<br alt="" name="" rel="" target="" title="" type="" value="" />What success have people had with either SOAP and XML or even JSON and REST.<br alt="" name="" rel="" target="" title="" type="" value="" />My background is SQL so nothing of this stuff.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /> question active 1 2 1 comment http://m.getsatisfaction.com/topics/7807000 7807000 Not Null 2018-10-22T14:50:13Z 2018-10-19T21:12:00Z Stephanie http://m.getsatisfaction.com/people/8807459 https://www.gravatar.com/avatar/5cfe6b3ce7c26b308b9795f27de16010?d=identicon&s=55&r=PG stephanie_i8u2r0tcf4r78 I am writing a formula Rich Text field that is getting a bit complicated.&nbsp; I am combining 4 text fields together, making the contents bold and italicized.&nbsp; <br alt="" name="" rel="" target="" title="" type="" value="" />Original formula:"&lt;i&gt;&lt;b&gt;" &amp; [CT - Q1 Comments] &amp; "&lt;br&gt;" &amp; [CT - Q2 Comments] &amp; "&lt;br&gt;" &amp; [CT - Q3 Comments] &amp; "&lt;br&gt;" &amp; [CT - Q4 Comments]<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Then I saw when some of the comments are blank, there was extra space (I assume this is the breaks even though there is no text.&nbsp; So I feel like I need to adjust the formula to contain nested If/And statements:<br alt="" name="" rel="" target="" title="" type="" value="" />If [CT - Q1 Comments] = Blank and&nbsp;[CT - Q2 Comments],&nbsp;[CT - Q3 Comments],&nbsp;[CT - Q4 Comments] are Not Blank then&nbsp;"&lt;i&gt;&lt;b&gt;" &amp; [CT - Q2 Comments] &amp; "&lt;br&gt;" &amp; [CT - Q3 Comments] &amp; "&lt;br&gt;" &amp; [CT - Q4 Comments]<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I believe this is going to end up being a pretty long formula since I would need to have every variation of each comment being blank.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I believe since these are text fields I would want&nbsp;[CT - Q1 Comments] = null however I don't know how to say&nbsp;[CT - Q2 Comments] Is not null.&nbsp; I tried the&nbsp;not IsNull( ) but it didn't like that.<br /><br />Any suggestions?<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 6 3 1 comment