Code Page with Pie Charts
Does anyone know how to code a page to display pie charts sized so that 7 fit across the screen in one row? I am using a code page with the following: <table> <tr> <td><embed src="h t t p s://XXXXX.quickbase.com/db/XXXXX?a=q&qid=13&ifv=0" width=14%></td> <td><embed src="h t t p s://XXXXX.quickbase.com/db/XXXXX?a=q&qid=11&ifv=0" width=14%></td> <td><embed src="h t t p s://XXXXX.quickbase.com/db/XXXXX?a=q&qid=9&ifv=0" width=14%></td> <td><embed src="h t t p s://XXXXX.quickbase.com/db/XXXXX?a=q&qid=15&ifv=0" width=14%></td> <td><embed src="h t t p s://XXXXX.quickbase.com/db/XXXXX?a=q&qid=10&ifv=0" width=14%></td> <td><embed src="h t t p s://XXXXX.quickbase.com/db/XXXXX?a=q&qid=12&ifv=0" width=14%></td> <td><embed src="h t t p s://XXXXX.quickbase.com/db/XXXXX?a=q&qid=14&ifv=0" width=14%></td> </tr> </table> The charts show up like this: The charts are there, they are just large and can only be partially viewed using the scroll bars: I get the same result using <iframe>. If i set the size to match the highcharts container (width: 588px & height: 600px), then the scroll bars go away and I see the whole chart, but that is too big to fit all 7 across the screen in one row. I can manually adjust width and height in the <svg> element and it changes the size of the pie chart, but have not figured out how to leverage that for my code page:8Views1like14CommentsNEED TO MANIPULATE CSV FILE PRIOR TO IMPORT
Hope dandiebolt wins the Hawaii trip. Maybe next one to Brazil. Think I am one of the few Brazilian happy quickbase customers.... My company imports 4 CSV files, regularly (Daily basis) to One table. We have to import to excel, format columns (Brazil uses Date format DDMMYYYY, and NUMBER 123.456,78), Add one column to create a [UNIQUE] field, add one column to create a [Related other table field], rename de headings, export to CSV, import to quick base. Time consuming and prone to errors (a lot), though easy to detect and reimport. One CSV, is comma separated, other is tab separated and two are ?;? separated Information is similar, but Headings are different (one of them has no headings), some have extra information that is not needed, one uses decimal numbers using ?,? the others use ?.?. Implemented successfully dandiebolt idea: HTML5 file reader, Parse with d3 which creates an Object :csv , Do a map of csv, which creates an ARRAY?? Csv_Blob, that can be imported using the API_ImportFromCSV. Now I am trying to learn: How to manipulate CSV_Blob (Array), prior to importing, or csv (OBJECT) prior to _map. Seems that underscore library has powerful tools to do that. It must be simple if you understand (which I am trying) arrays, objects, propriety?s, strings etc., cause from what I have read underscores deals directly with this creepy things. What I have accomplished (more o less) 1. - I can parse the file reader output with D3.js selecting different separators (tab, ?,?, ?;? other). That?s fine!! 2. - D3.js can manipulate date and number formats of the propriety?s of each objet. I was not able to correctly format Number 123456.00 to 123.456,00 and Date YYYYMMDD to DDMMYYYY (something related to iso xx which seems I have to buy to now the correct code). What I did is transform the data directly in quick base (creating a formula text, and a formula number to cover all possibilities). It is working. What I have not (still studying) and wishing some hints to make easier my process 1.- Create two new columns (Excel way). Think this can be done in csv object prior to map, or in csv_blob Array prior to importing. My understanding is I need to create 2 new propriety?s, in all the Objects included in the csv_blob array. Must be a direct underscore snippet that I haven?t found or understand. Lets say: Before [{Name: xx, Phone: 123}, {Name: yy, Phone: 456}......] After [[{Name: xx, Phone: 123, Newcol1: to_be 1, Newcol2: to_be 2}, {Name: yy, Phone: 456, Newcol1: to_be 1.1, Newcol2: to_be 2.1 }...] 2.- Automatically fill the values side of that propriety?s across the entire ARRAY, with two rules: Rule number one: New propriety must be a string resulting of concatenating two other propriety?s: Lets say [{Name: xx, Phone: 123, Newcol1: ?xx?+?123?}, {[{Name: yy, Phone: 456, Newcol1: ?yy?+?456?}...] This creates a UNIQUE field in my configuration, and avoids duplicate records Rule number two: Upon selection of a Button (think there are some ideas of how to do that in the community), some variable takes a value var Button. This value must go in all objects of the array in the newly created propriety Lets say say [{Name: xx, Phone: 123, Newcol1: ?xx?+?123?, Newcol2: var button}, {[{Name: yy, Phone: 456, Newcol1: ?yy?+?456?, Newcol2: var button}...] 3.- Thus there are different rules and different type of csv files I must implement a kind of button selection (do this or do that). What I am using now is have the snippets in different quick base code pages, and create a dashboard, with web url to those pages for simplicity. Long question (sorry) Appreciate some guidance8Views1like37CommentsNew RESTful API in Code Pages?
Hi, QB Folks! Anyone know if you can use the new API inside your Code Pages? I'm getting a CORS error when I try. I need to combine a few existing QB reports into a single table for reporting, and thought the new API's "reports" endpoint would work well. I'm hoping to use JS to fetch the data and generate a table. But when I try to pull the data into the page directly, using the JQuery code samples from the API Portal, I get a CORS error. <head> <script> var headers = { 'QB-Realm-Hostname': 'xxxxx', 'User-Agent': 'API-Explorer', 'Authorization': 'QB-USER-TOKEN xxxxxxxxxxxxxxxxxxxxxxxx', 'Content-Type': 'application/json' }; $.ajax({ url: 'https://api.quickbase.com/v1/reports/10/run?tableId=xxxxxxxxx&skip={skip}&top=10', method: 'POST', headers: headers, success: function(result) { console.log(JSON.stringify(result)); } }) </script> </head> <body> <h2>Table will go here.</h2> <table></table> </body> When the page loads, in the console: Access to XMLHttpRequest at 'https://api.quickbase.com/v1/reports/10/run?tableId=xxxxxxxxx&skip={skip}&top=10' from origin 'null' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. I'm hoping there is a workaround that I'm just missing. Any help is appreciated. Thanks, CD ------------------------------ Chris Dyroff ------------------------------7Views0likes3Commentsuse code page in web page widget
Hello, I have some code that runs a 3rd party dashboard that I want to embed in my homepage. I dropped the copied code into a code page in QuickBase and want to use the Web Page Widget on my home page to pull up that dashboard. How do I write the URL to view a specific code page (the one with my dashboard code)?6Views0likes2CommentsHow do you add links in your brand bar?
I know I saw how to do this in a post somewhere in the community, but now I can't find it! We have many users using many apps, but there is one main landing page. I would like to add a link to the landing page in the brand bar for ease of navigation.6Views1like5CommentsHTML Coding on Dashboards
I've been looking for ways to improve the look and feel of some of our dashboards. I was wondering is it possible to place an html coding layer on dashboards. If so, how? If no, how are some ways folks are enhancing the look and feel of their dashboards? ------------------------------ Wallace (DHS) ------------------------------5Views0likes2CommentsHow can I get a simple formula-generated number to display on my dashboard?
I have a report representing a number of records. All I want is to display that number on my dashboard. I don't want it to take up a lot of space. I'm pretty handy with the formulas & functions of the app, but I don't know anything about API, if that's the solution. I thought maybe I could put a formula into a text widget. It would be a pretty complex formula if I have to duplicate the report, but I could probably figure that out, but I don't know what format to use to get it to display, or if that's even possible with the text widget.5Views0likes7Comments