Script
[Content] is a script (might be the body of a closure for IOL)
Content types
 
PastieURL
Forum Title
OldPostUrl
Notes
Demo URL
Public?
Date Modified
 
  Is there a way to have a Multiple-choice field allow you to override the choices and put in a value that is not in the list. But not using the add new choice option. I want to be able to input an item that is rare and not make it a permanent choice. 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.   Yes 11-05-2018 10:14 AM
  Mass edit "Searchable" field for 1,000+ fields 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.   Yes 11-05-2018 10:14 AM
  How can you add an aggregating row number to a report? 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. dbid0 is the application dbid dbid1 is the source dbid dbid2 is the target dbid importid is the id associated with the saved import   Yes 11-05-2018 10:14 AM
  How to select a specific number of records from a table 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. Demo Yes 11-05-2018 10:14 AM
  API_RunImport with Summary table 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. Demo Yes 11-05-2018 10:14 AM
  How Can I Show A User's "Last Access Date" from the billing account page in an application ? 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.   Yes 11-05-2018 10:14 AM
  How do I display a hyperlink in a text field from my javascript code. 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.   Yes 11-05-2018 10:14 AM
  Set New Tables to Default to Hidden for Roles 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.   Yes 11-05-2018 10:14 AM
  Median and Percentiles using Java script 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.   Yes 11-05-2018 10:14 AM
  How do I get my "Save & Next" ticket function to auto populate certain fields based on the previous ticket info? I have 100 different users on my ticketing system and they each have to enter their name, location name, phone number, etc. for every ticket. 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.   Yes 11-05-2018 10:14 AM
  Javascript Prompt + Edit record for Decline button 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.   Yes 11-05-2018 10:14 AM
  Sampling report? 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. Demo Yes 11-05-2018 10:14 AM
  Retrieving Field Value 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.   Yes 11-05-2018 10:14 AM
  Need to populate a summary field with the previous record from the same table. 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.   Yes 11-05-2018 10:14 AM
  Need help in completing a script 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.   Yes 11-05-2018 10:14 AM
  Summary from multiple tables 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.   Yes 11-05-2018 10:14 AM
  Can you test a URL formula to determine if a web page is valid? 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.   Yes 11-05-2018 10:14 AM
  Formula for date field to display only first day of each week? 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.   Yes 11-05-2018 10:14 AM
  How would I specify a form rule to make all fields in a record read only on fulfillment of a condition, without specifying each field individually? The record has about a 50 odd fields. 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.   Yes 11-05-2018 10:14 AM
  How can I export my user lists? 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.   Yes 11-05-2018 10:14 AM
  API Add record is not populating destination 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.   Yes 11-05-2018 10:14 AM
  How to Convert Euro To Dollar In Real Time? 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. Demo Yes 11-05-2018 10:14 AM
  How to Determine Proxy Field Using API 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. Demo Yes 11-05-2018 10:14 AM
  How to Determine Proxy Field Using API 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. Demo Yes 11-05-2018 10:14 AM
  Form Rule Message Box - Dismiss With Enter Rather Than Click 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. Demo Yes 11-05-2018 10:14 AM
  how to add record using Jquery 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.   Yes 11-05-2018 10:14 AM
  How To Integrate Google's Angular? 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. Demo Yes 11-05-2018 10:14 AM
  How do I total results from multiple lines in a DoQuery? 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.   Yes 11-05-2018 10:14 AM
  Suggested parent record based on value range 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. Demo Yes 11-05-2018 10:14 AM
  API to another software program 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. Demo Yes 11-05-2018 10:14 AM
  How to base a new field value off an old field value. 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.   Yes 11-05-2018 10:14 AM
  I have two tables companies and applicants, each company has associated applicants. Is there a way to generate a specific number of randomly selected applicants by selecting the company? 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.   Yes 11-05-2018 10:14 AM
  Delete File Attachment with API_EditRecord 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.   Yes 11-05-2018 10:14 AM
  How to create a view or maybe report combine the items from 2 tables? 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.   Yes 11-05-2018 10:14 AM
  Report from multiple tables 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.   Yes 11-05-2018 10:14 AM
  Report from multiple tables 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.   Yes 11-05-2018 10:14 AM
  how do I create a secondary counter? 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.   Yes 11-05-2018 10:14 AM
  csv export report without field names on first row of data 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.   Yes 11-05-2018 10:14 AM
  Automatically check and verify files 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. Demo Yes 11-05-2018 10:14 AM
  Text formatting (especially italics) not working in fields 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.   Yes 11-05-2018 10:14 AM
  Restrict a field to a fixed character length 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.   Yes 11-05-2018 10:14 AM
  Restrict a field to a fixed character length 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.   Yes 11-05-2018 10:14 AM
  Remove hyphens, extra spaces from field value 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.   Yes 11-05-2018 10:14 AM
  How to create dynamic text page and query issue 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. Demo Yes 11-05-2018 10:14 AM
  How to Hide a coloumn in a table? 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. Demo Yes 11-05-2018 10:14 AM
  how can i edit multiple fields' properties at the same time? 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.   Yes 11-05-2018 10:14 AM
  Logging edits to a record 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. Demo Yes 11-05-2018 10:14 AM
  API_SetFieldProperties HTTP Request. Why doesn't work? 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.   Yes 11-05-2018 10:14 AM
  How to dynamically filter map reports based on user's current location? 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.   Yes 11-05-2018 10:14 AM
  JQuery not retrieving information 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.   Yes 11-05-2018 10:14 AM
Result Pages:  1  2  3  4  5    
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