Console Script
[Content] is a script intended to be entered through the Developer Tools Console tab
Content types
 
PastieURL
Forum Title
OldPostUrl
Notes
Demo URL
Public?
Date Modified
 
  When exporting to CSV via URL, how can i specify the output filename before the export? PostURL The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: Image Onload Technique The old image onload technique is document here: Old Image Onload Technique   Yes 11-05-2018 10:14 AM
  How Do "Download All The Things" Your QuickBase?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: Image Onload Technique The old image onload technique is document here: Old Image Onload Technique Demo Yes 11-05-2018 10:14 AM
  How to get the Qid of the reports present in a table through API? PostURL All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: Image Onload Technique The old image onload technique is document here: Old Image Onload Technique   Yes 11-05-2018 10:14 AM
  Number of bytes an API_Doquery can return PostURL All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT Demo Yes 11-05-2018 10:14 AM
  What is the "Clear the Swamp" Technique? PostURL All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT Demo Yes 11-05-2018 10:14 AM
  Formula Parser In JavaScript   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  How Do Obtain HighChart Insight?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  How To Copy File Attachments  Between Tables Without Download?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Limiting size of files a user can upload   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  How to install BOL (Branding On Load)?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Executing JS numbering code   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Help with List-User field and reporting   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  What is the Async / Await Technique?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT Demo Yes 11-05-2018 10:14 AM
  Create a Button to Change a Date Field   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT Demo Yes 11-05-2018 10:14 AM
  How To Filter The Summary Column   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  How to renumber a set of records?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  How to pull field types and info from field page in console (Should be an export function in QB hack through console...)   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  import records from excel with different user names   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Alert sent to specific role(s)   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onload techique which you can read about here: https://community.quickbase.com/quickbase/topics/how-do-i-setup-the-image-onload-technique-iol, and https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294. The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Geolocation and form fields   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  When I download a spreadsheet from a report, can I include the Report's name in the title of the .csv so I can trace it?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Is there a way to create a recursive query in QuickBase to return all items from a table with relationships that may be several layers deep?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Median of Field Entries   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Automatic website import to QB field   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Exciting feature for integrators – new mergeFieldId in API_ImportFromCSV   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Can I access system variables through javascript?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Batch Update "Display As" Property   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Batch Update "Display As" Property   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Need to create email button on a form that sends the form fields (or form) to QB User directly.   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Deleting tables of Data through Automation?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-05-2018 10:14 AM
  Bulk Add Fields Via Script   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-25-2018 01:47 PM
  Is it possible to customize the file name when exporting a report from a table?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 11-29-2018 01:32 AM
  Recursive Relationships: Our Gang Demo   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT Demo Yes 11-29-2018 09:07 AM
  Surprising Use For API_ImportFromCSV with mergeFiledID   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT Demo Yes 12-05-2018 01:04 PM
  report totals not showing in Excel when saving as spreadsheet   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT   Yes 12-05-2018 05:55 PM
PastieURL Entity Relationship Diagrams in Quickbase? PostURL used Northwind Traders to test updated pastie code old pastie was: http://pastie.org/2400518 Demo Yes 03-11-2018 10:11 AM
PastieURL Where Can I See More Async / Await?   All rights reserved. The code in this page is copyright by Dan Diebolt and may not be used without including my phone number (773-312-8131) and email address (dandiebolt@yahoo.com) in the footer of where you may want to use it. This snippet of code is not a complete solution and only represents the essential code to address the question. You may have to modify the code to suit your specific needs. There is a good chance that this code uses the image onlaod techique which you can read about here: https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294 The old image onload technique is document here: http://pastebin.com/hbeXXmTT Demo Yes 11-05-2018 10:14 AM
Created on March 11, 2018 at  9:28 AM (CST). Owned by Diebolt, Dan.
Dan Diebolt
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

We're glad you're interested in doing more with Quickbase!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quickbase with others in your company.

Your work email
Your company