Click each tab on this form to VIEW and/or DEMO the various features of XL Docs
Test Project ABC
321323
MEDIUM
Test Project ABC - (MEDIUM)
Ronkonkoma, NY
John Smith
07-01-2019
07-08-2019
In this example you can use different sheet for different subtables
We are also showing euipment image in second sheet for per equipment
3/7/2025 10:45:25 PM
 
Date
Account
Employee Name
Hotel Exp
Transport
Exp
Fuel Exp
Meals Exp
Phone Exp
Entertainment
Exp
Misc Exp
 
05-22-2021 H12900 Dana Wilkenson $200.00 $200.00 $150.00 $225.00 $16.00 $63.00 $55.00
05-23-2021 H12900 Edward Thompson $300.00 $150.00 $225.00 $200.00 $0.00 $59.00 $26.00
05-24-2021 T10894 Evelyn Morales $150.00 $300.00 $300.00 $150.00 $45.00 $63.00 $75.00
05-25-2021 M1899 Jim Johnson $200.00 $225.00 $225.00 $225.00 $12.00 $122.00 $62.00
05-26-2021 M1899 Joseph Wallace $200.00 $150.00 $300.00 $150.00 $25.00 $75.00 $75.00
08-02-2021 T10894 Edward Thompson $100.00 $120.00 $20.00 $50.00 $50.00 $75.00 $60.00
08-03-2021 H12900 Edward Thompson $60.00 $75.00 $150.00 $100.00 $100.00 $120.00 $120.00
08-03-2021 T10894 Edward Thompson $75.00 $56.00 $15.00 $120.00 $100.00 $100.00 $150.00
08-16-2021 H12900 Dana Wilkenson $200.00 $150.00 $230.00 $152.00 $120.00 $120.00 $100.00
10-10-2021 T10894 Edward Thompson $65.00 $565.00 $2.00 $656.00 $48.00 $3659.00 $23.00
11-01-2021 T10894 Edward Thompson $750.00 $350.00 $75.00 $800.00 $75.00 $2500.00 $250.00
11-04-2021 H12900 Evelyn Morales $895.00 $150.00 $50.00 $1200.00 $150.00 $500.00 $100.00
TOT       $3195.00 $2491.00 $1742.00 $4028.00 $741.00 $7456.00 $1096.00
 
Equipment ID
Item Name
Quantity
Unit Price
Total Cost
to Bill
Image
 
IN0001 Item 1 2 $51.00 $102.00
IN0002 Item 2 3 $93.00 $279.00
IN0006 Item 6 3 $11.00 $33.00
IN0017 Item 17 10 $97.00 $970.00
IN0016 Item 16 16 $90.00 $1440.00
IN0099 Item 99 150 $24.00 $3600.00
IN0013 Item 13 12 $26.00 $312.00
IN0007 Item 7 12 $56.00 $672.00
IN0011 Item 11 13 $59.00 $767.00
TOT     221 $507.00 $8175.00  
The Repository feature allows you to store any/all documents to 1 table.
Generate Report Summary (Repository)
 
Date Created
Project Name
Project Number
Project Summary FA
 
10-02-2024 10:18 AM Test Project ABC 321323 Project Expense Report_7.xlsx
10-02-2024 10:17 AM Test Project ABC 321323 Project Expense Report_7.xlsx
09-20-2024 09:45 PM Test Project ABC 321323 Project Expense Report_7.xlsx
09-18-2024 11:39 AM Test Project ABC 321323 Project Expense Report_7.xlsx
09-18-2024 10:23 AM Test Project ABC 321323 Project Expense Report_7.xlsx
07-21-2024 08:19 PM Test Project ABC 321323 Project Expense Report_7.xlsx
06-28-2024 02:31 PM Test Project ABC 321323 Project Expense Report_7.xlsx
06-28-2024 02:29 PM Test Project ABC 321323 Project Expense Report_7.xlsx
06-26-2024 10:02 PM Test Project ABC 321323 Project Expense Report_7.xlsx
06-18-2024 08:42 AM Test Project ABC 321323 Project Expense Report_7.xlsx
04-19-2024 10:45 AM Test Project ABC 321323 Project Expense Report_7.xlsx
04-13-2024 06:57 PM Test Project ABC 321323 Project Expense Report_7.xlsx
04-02-2024 05:30 PM Test Project ABC 321323 Project Expense Report_7.xlsx
04-02-2024 03:09 PM Test Project ABC 321323 Project Expense Report_7.xlsx
03-28-2024 03:57 AM Test Project ABC 321323 Project Expense Report_7.xlsx
03-02-2024 12:52 AM Test Project ABC 321323 Project Expense Report_7.xlsx
02-07-2024 11:39 PM Test Project ABC 321323 Project Expense Report_7.xlsx
12-24-2023 06:05 PM Test Project ABC 321323 Project Expense Report_7.xlsx
12-13-2023 02:01 PM Test Project ABC 321323 Project Expense Report_7.xlsx
08-31-2023 08:21 AM Test Project ABC 321323 Project Expense Report_7.xlsx
08-30-2023 05:26 PM Test Project ABC 321323 Project Expense Report_7.xlsx
08-21-2023 10:58 AM Test Project ABC 321323 Project Expense Report_7.xlsx
08-09-2023 02:24 PM Test Project ABC 321323 Project Expense Report_7.xlsx
07-03-2023 05:50 PM Test Project ABC 321323 Project Expense Report_7.xlsx
04-03-2023 09:12 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
03-23-2023 04:55 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
03-15-2023 03:08 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
02-11-2023 04:34 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
01-26-2023 05:14 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
01-16-2023 10:09 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
12-28-2022 04:29 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
09-30-2022 10:38 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
08-29-2022 12:26 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
07-28-2022 01:05 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
07-21-2022 02:09 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
06-24-2022 08:18 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
06-17-2022 01:08 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
06-08-2022 04:56 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
04-08-2022 05:27 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
04-08-2022 04:18 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
03-31-2022 02:00 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
03-24-2022 05:27 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
03-23-2022 11:16 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
02-12-2022 03:21 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
01-15-2022 10:35 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
01-15-2022 10:35 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
12-22-2021 01:51 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
12-17-2021 02:56 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
11-24-2021 12:12 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
11-24-2021 09:38 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
11-22-2021 12:01 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
11-22-2021 11:59 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
11-18-2021 09:52 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
11-18-2021 09:50 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
10-23-2021 09:57 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
10-21-2021 02:18 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
09-01-2021 12:07 PM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
08-27-2021 09:30 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
05-22-2021 05:02 AM XL Docs Test Project test 321323 Project Expense Report_7.xlsx
03-15-2021 05:19 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
03-15-2021 05:18 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
01-22-2021 05:54 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
01-13-2021 06:46 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
01-13-2021 06:45 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
01-05-2021 02:13 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
12-03-2020 11:45 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
11-15-2020 08:49 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
10-12-2020 10:29 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-25-2020 10:03 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-22-2020 03:06 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 03:27 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 03:26 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 03:25 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 03:25 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 03:07 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 02:57 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 02:48 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 02:18 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 02:16 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-07-2020 12:27 PM XL Docs Test Project 321323 Project%20Expense%20Report_7.xlsx
07-07-2020 11:49 AM XL Docs Test Project 321323 Project%20Expense%20Report_7.xlsx
07-07-2020 11:49 AM XL Docs Test Project 321323 Project%20Expense%20Report_7.xlsx
05-17-2020 01:26 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
05-04-2020 05:38 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
04-19-2020 11:34 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
04-02-2020 10:29 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
03-13-2020 02:37 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
02-24-2020 04:13 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
02-19-2020 11:53 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
12-15-2019 01:45 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
11-24-2019 04:29 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
11-15-2019 03:37 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
10-09-2019 10:01 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
10-03-2019 12:56 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-24-2019 05:02 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-09-2019 01:56 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-09-2019 01:53 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-09-2019 11:55 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-09-2019 11:04 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-04-2019 05:00 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-04-2019 05:00 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-04-2019 04:58 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
09-04-2019 04:55 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-29-2019 11:54 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-14-2019 03:26 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-12-2019 03:59 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-05-2019 09:56 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-05-2019 09:56 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-02-2019 11:58 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-02-2019 11:54 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
08-02-2019 11:54 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
07-01-2019 06:22 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
06-27-2019 03:21 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
06-27-2019 10:31 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
06-27-2019 09:36 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
06-14-2019 01:47 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
06-14-2019 01:46 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
05-18-2019 01:49 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
05-01-2019 09:49 PM XL Docs Test Project 321323 Project Expense Report_7.xlsx
04-17-2019 05:57 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
04-13-2019 09:02 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
03-28-2019 09:26 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
03-28-2019 09:20 AM XL Docs Test Project 321323 Project Expense Report_7.xlsx
In this example we are skipping 2 rows for each subtable.
We are splitting one subtable record into three rows.
For one employee record we have three subtables
Subtable 1 is displaying employee's name and their double time hours
Subtable 2 is displaying time and half hours for that employee
Subtable 3 is displaying employee's standard time
03-10-2025 03:05 AM
 
Employee Name
Total Regular
Hours Day 1
Total Regular
Hours Day 2
Total Regular
Hours Day 3
Total Regular
Hours Day 4
Total Regular
Hours Day 5
Total Regular
Hours Day 6
Total Regular
Hours Day 7
Total 1.5
Time Hours
Day 1
Total 1.5
Time Hours
Day 2
Total 1.5
Time Hours
Day 3
Total 1.5
Time Hours
Day 4
Total 1.5
Time Hours
Day 5
Total 1.5
Time Hours
Day 6
Total 1.5
Time Hours
Day 7
Total Double
Time Day 1
Total Double
Time Day 2
Total Double
Time Day 3
Total Double
Time Day 4
Total Double
Time Day 5
Total Double
Time Day 6
Total Double
Time Day 7
Total Regular
Hours
for Week
Total  1.5
TimeHours
for Week
Total Double
Hours
for Week
Create Report Employee Expense Sheet
Expense Sheet File Name
Report/Employee Expense Sheet
Report/Employee Expense
Sheet created date
# of Time
Sheet
records
Grand Total
Hours
for Week
 
Joseph Wallace 10 12 25 7 0 0 5 0 0 8 0 0 0 0 0 0 0 0 13 14 0 59 8 27 My_Project_Expenses_03-16-2025-Joseph Wallace My_Project_Expenses_02-14-2025_8.xlsx 03-13-2025 10:48 AM 5 94
Dana Wilkenson 22 16 27 20 0 0 9 0 0 0 0 0 0 0 0 0 0 0 14 26 0 94 0 40 My_Project_Expenses_03-16-2025-Dana Wilkenson My_Project_Expenses_02-14-2025_6.xlsx 03-13-2025 10:48 AM 6 134
Evelyn Morales 9 20 5 5 0 0 15 0 0 0 0 0 0 0 0 0 0 0 18 10 0 54 0 28 My_Project_Expenses_03-16-2025-Evelyn Morales My_Project_Expenses_02-14-2025_4.xlsx 03-13-2025 10:48 AM 5 82
Edward Thompson 15 3 24 11 0 0 12 0 0 0 0 0 0 0 0 0 0 0 17 7 0 65 0 24 My_Project_Expenses_03-16-2025-Edward Thompson My_Project_Expenses_02-14-2025_9.xlsx 03-13-2025 10:48 AM 5 89
Jim Johnson 10 9 16 16 0 0 9 0 0 4 0 0 0 0 0 0 0 0 14 6 0 60 4 20 My_Project_Expenses_03-16-2025-Jim Johnson My_Project_Expenses_02-14-2025_7.xlsx 03-13-2025 10:48 AM 5 84
TOT   66 60 97 59 0 0 50 0 0 12 0 0 0 0 0 0 0 0 76 63 0 332 12 139         26 483
In this example we are showing multiple subtables on one Excel sheet.
03-07-2025 10:45 PM
Report Details
 
Record ID#
Description
Add Time Sheet
 
1 Preparations for Project
2 Equipment Instalalition
3 Replacing building installation
4 Painting walls and carpet replacing.
5 Cleaning and touch ups
 
Date
Account
Employee Name
Hotel Exp
Transport
Exp
Fuel Exp
Meals Exp
Phone Exp
Entertainment
Exp
Misc Exp
 
05-22-2021 H12900 Dana Wilkenson $200.00 $200.00 $150.00 $225.00 $16.00 $63.00 $55.00
05-23-2021 H12900 Edward Thompson $300.00 $150.00 $225.00 $200.00 $0.00 $59.00 $26.00
05-24-2021 T10894 Evelyn Morales $150.00 $300.00 $300.00 $150.00 $45.00 $63.00 $75.00
05-25-2021 M1899 Jim Johnson $200.00 $225.00 $225.00 $225.00 $12.00 $122.00 $62.00
05-26-2021 M1899 Joseph Wallace $200.00 $150.00 $300.00 $150.00 $25.00 $75.00 $75.00
08-02-2021 T10894 Edward Thompson $100.00 $120.00 $20.00 $50.00 $50.00 $75.00 $60.00
08-03-2021 H12900 Edward Thompson $60.00 $75.00 $150.00 $100.00 $100.00 $120.00 $120.00
08-03-2021 T10894 Edward Thompson $75.00 $56.00 $15.00 $120.00 $100.00 $100.00 $150.00
08-16-2021 H12900 Dana Wilkenson $200.00 $150.00 $230.00 $152.00 $120.00 $120.00 $100.00
10-10-2021 T10894 Edward Thompson $65.00 $565.00 $2.00 $656.00 $48.00 $3659.00 $23.00
11-01-2021 T10894 Edward Thompson $750.00 $350.00 $75.00 $800.00 $75.00 $2500.00 $250.00
11-04-2021 H12900 Evelyn Morales $895.00 $150.00 $50.00 $1200.00 $150.00 $500.00 $100.00
TOT       $3195.00 $2491.00 $1742.00 $4028.00 $741.00 $7456.00 $1096.00
 
Employee Name
Total Regular
Hours
for Week
Total  1.5
TimeHours
for Week
Total Double
Hours
for Week
Report/Employee Expense Sheet
Report/Employee Expense
Sheet created date
 
Joseph Wallace 59 8 27 My_Project_Expenses_02-14-2025_8.xlsx 03-13-2025 10:48 AM
Dana Wilkenson 94 0 40 My_Project_Expenses_02-14-2025_6.xlsx 03-13-2025 10:48 AM
Evelyn Morales 54 0 28 My_Project_Expenses_02-14-2025_4.xlsx 03-13-2025 10:48 AM
Edward Thompson 65 0 24 My_Project_Expenses_02-14-2025_9.xlsx 03-13-2025 10:48 AM
Jim Johnson 60 4 20 My_Project_Expenses_02-14-2025_7.xlsx 03-13-2025 10:48 AM
TOT   332 12 139    
 
Equipment ID
Item Name
Quantity
Unit Price
Total Cost
to Bill
 
IN0001 Item 1 2 $51.00 $102.00
IN0002 Item 2 3 $93.00 $279.00
IN0006 Item 6 3 $11.00 $33.00
IN0017 Item 17 10 $97.00 $970.00
IN0016 Item 16 16 $90.00 $1440.00
IN0099 Item 99 150 $24.00 $3600.00
IN0013 Item 13 12 $26.00 $312.00
IN0007 Item 7 12 $56.00 $672.00
IN0011 Item 11 13 $59.00 $767.00
TOT     221 $507.00 $8175.00
In this section we are showing examples to create MULTIPLE excel documents
--- > We are generating below documents for every report record in table
--- > We are storing each document to its own file attachment field in the record (except for sameworkbook option)
--- >At the end of the process we creating workbook and in each sheet you can see details or weekly time sheet for each report

>> First 2 buttons are using the "sameworkbook" parameters which creates document one document with each excel tab representing a Quickbase record.
>> Second 2 button are using the "merge" parameters which creates files at each record and then creates on consolidated PDF file of all records.

04-02-2024 05:35 PM
In some cases you may have multiple records that should be grouped/summarized/totaled together into a report.
Generate Summary Demo
XL_with_ReportName_7.xlsx
03-07-2025 10:45 PM
Generate Summary Demo
This example illustrates outputting data to multiple tabs and the first tab includes subtotals and grouping as well...
In this example we are showing a cool way to view your data as a Schedule / Gantt.
We are getting the data from the Reports and Tasks tables to display the Report Schedule in a Gantt style view.
Click to View the .xlsx Template for this example
03-07-2025 10:45 PM
03-14-2025 06:10 AM
In this section is an example of creating an Excel document and automatically sending out via email
--- > After entering your email address and saving the record, our "batch" process will run in the background and generate the excel document and email via our Courier Add-on.
--- > You should see an email within 30 seconds with a sample Expense sheet attached.
minals@juicedtech.com 03-06-2025 04:19 PM
03-06-2025 04:19 PM PROCESS COMPLETED_3/6/2025 4:19:09 PM
 
Yes  
clientid=Q2 appid=bj446yrpq dbid=bneztjaka tpdbid=bj447itad tpid=17 fn=XL_EXP msid=7 faid=146 fnrid=N xlddte=188 docfmt=xlsx apptoken=dj75rihdn9i2phb9fke8w4hxuqp xldbrid=7 xldbtfld=295 xldbdbid=bneztjaka

To Demo Graphs and Charts Please click the link below
Demo Graphs and Charts using XL Docs

Line Items
 
Project Name
Stage
Type
Cost
 
Construction  (2 Line Item records) 
Test Project ABC Construction Labor $1000.00
Test Project ABC Construction Materials $1600.00
TOT       $2600.00
Renovation  (2 Line Item records) 
Test Project ABC Renovation Labor $9000.00
Test Project ABC Renovation Materials $2500.00
TOT       $11500.00
Demolition  (2 Line Item records) 
Test Project ABC Demolition Labor $9693.00
Test Project ABC Demolition Materials $1500.00
TOT       $11193.00
TOT       $25293.00
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.