Show fields from Show fields from Show fields from a related table


Available Date
3.5 02-25-2009 - Added the ability to generate PDF files
3.6 03-25-2009 - added the ability to generate a single Merged PDF for for multiple records.
- added filename as metadata to the Amazon S3 upload process
- removed requirement of specific input parameters, repository,rlfn,amazons3.  These can be omitted if not being used
3.7 04-01-2009 - added new parameter for detail data table - "noborder".  This will suppress the borders from printing for all cells of a detail table.

use:  noborder
No value needed, pass it in as is.
3.7.1 04-15-2009 - fix issue when "noheader" was being used.  the table was not centering in the document properly
3.7.2 05-15-2009 - added ability to save the merged pdf file to Amazon S3 
- added some validation of parameters in subtable parameter list
- fixed subtotal row issue whe a date column showed in the table.  A default date was showing up when subtotalling was requested
3.8 06-30-2009 - changed the way data is being retrieved in subtables. More efficient data retrieval process now.  
- use the clist parameter instead of the default report to determine which columns to return from a query.
3.8.1 07-15-2009 - added ability to show a checkbox image when displaying a checkbox field in a document.
- added ability to display images in the detail table of the document.
- change the file naming process so that when generating more than 1 file the user will have more control over the 
file name.  Pass fn=~3.4.5~ and the file will be named with the values in these fids.  If no ~~ are found in the fn parameter then old file name process is used.
- fixed issue related to a text field that contains a "$" character.
3.8.2 08-01-2009 - merge pdf process - fixed issue internally when processing individual pdf files. - clean up issue, no user impact
3.8.3 10-01-2009 - ability to display images that are not file attachment fields.  So it is now possible to display an image if it is referenced in a formula text field with a <img src> tag.
(must us the "I" format parameter with the field id in the clist)
3.8.4 11-29-2009 - efficiency changes
- added "clist" as a parameter to the main URL string so if using the msqry parameter you can specify the columns to return within the new clist parameter.
3.8.5 12-01-2009 - fixed issue when noheader is being used.  A blank row was appearing at the top of the subtable when noheader with a border was being used.
3.8.6 12-10-2009 -internal upgrade
3.8.7 12-18-2009 - added 2 new main URL parameters, appid and tpdbid
tpdbid - you can now pass in the dbid of the table that stores the document template files.  So you can have multiple tables if you want.
appid - the dbid of the application should be passed in with this parameter.
3.8.8 01-25-2010 - fixed issue with merged pdf process when only 1 document was being created.  The merged pdf was not being created if only 1 pdf was created.  This is now fixed.
- added new parameter so you can control the name of the merged pdf file, "mrgfn"
3.8.9 02-16-2010 - changes to handle displaying images for the master record even if they are not in file attachment fields.  So if the image file is referenced within a text/html field or in a URL field it will dispaly in the document properly.
- also added the ability to size the images in the master.  New format option...~i:fid:200~
(must use the fid and not the field name)
- added s3 parms to the URL so they can be passed in.  They are optional, if not passed in then use values from the webconfig (s3key and s3bkt)
3.8.10 02-23-2010 - change so if the "Record ID#" field was renamed it can be used with the new field name.  Older versions require the Record ID# field as is and now you can use a renamed key field.
- fixed issue with float decimal fields displaying as 2 decimal digits instead of the actual number defined in quickbase
Report Name *
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
This report will be listed only for you, in the group Mine.
Only you can see the report in the panel. You can't ever list it for other users. You can still let others open it by sending them links.
Please wait while your new report is saved...
Field label
Column heading override
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