ContributionsMost RecentMost LikesSolutionsRe: Backup entire Apps in QuickbaseTry QuNect Backup: https://qunect.com/products/QuNectBackup.html ------------------------------ Claude von Roesgen ------------------------------ Re: Sorting Bug? Mark Anyone using the Quickbase HTTP API will be very concerned about this sorting bug. The API is typically used to integrateQuickbase with othersystems including BI tools like Tableau. It also affects the UI that you are comfortablewith. Claude 978-405-2524 Re: Sorting Bug? Mark You should be able to try yourself. The original sort order is below: https://qunect.quickbase.com/db/bseh9b8mp?a=api_doquery&clist=10.6&slist=10.6&apptoken=deyvepi7e9qxxc95859bk2u6rb Your sort order is here: https://qunect.quickbase.com/db/bseh9b8mp?a=api_doquery&clist=10.6&slist=6.10&apptoken=deyvepi7e9qxxc95859bk2u6rb Claude 978-405-2524 Re: formula assistance - rich text w/dateCorrection IF([SAND DATE]<today(), "<img src=\"images.quickbase.com/si/ 24/204-warning.png\"title=\"delete\">", "<img src=\"images.quickbase.com/si/ 16/224-point_blue.png\"title=\"TO DO\">") ------------------------------ Claude von Roesgen ------------------------------ Sorting Bug?Has anyone noticed that on a two column sort with a text field and a numeric field that the sort order is incorrect? For example I am sorting on "numericField" and then on "Country". As you can see, in the image below, the sort order is incorrect. I filed a case with Quickbase and got this response: Good evening Claude, Thank you for contacting QuickBase support. I see what you are describing. Although, realistically speaking, normal applications won't have the country names you've input. I suspect the randomness of your country inputs is causing the issue (and likely the sorting is reading the Z in "IAMxEdvzZ". Are you able to replicate this same problem with real country names? Can you also please invite me to the application? I'd like to show this to my team for their input. ------------------------------ Claude von Roesgen ------------------------------ Re: formula assistance - rich text w/dateTry IF([SAND DATE]<today()), "<img src=\"images.quickbase.com/si/ 24/204-warning.png\"title=\"delete\">", "<img src=\"images.quickbase.com/si/ 16/224-point_blue.png\"title=\"TO DO\">") ------------------------------ Claude von Roesgen ------------------------------ Re: Oracle ImportOr you could create a Linked Server in your Oracle database: http://www.dba-oracle.com/t_heterogeneous_database_connections_sql_server.htm Re: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?Just discovered that if you have two or more relationships to the same parent table then PowerBI chokes if you try to use the application/table chooser UI. Instead you'll need to use advanced options. Please watch the following video to see an example of how to do this.http://qunect.com/appnotes/PowerBI.htmlRe: Has anyone successfully connected their Quickbase accounts to Microsoft Power BI?Please download the latest version of QuNect ODBC for QuickBase to get connectivity with Power BI. https://qunectllc.com/download/QuNect.exe Please call if you have any questions: 978-405-2524