Skip to Navigation

Reply to comment

If you place a view link field on your Exact Forms MS Word template this turns into a table with no grouping or subtotals. If you want grouping and subtotals you can use the following method:

~=qdb.GetURL("targetdbid", "API_GenResultsTable^query={'12'.EX.'"+ field["Source Field"]+"'}^^slist=15");~

You'll need to replace


with the database identifier of the table (details table) from which the embedded view will come from.

You'll have to replace the


with the field identifier of the target field (most often this is a reference field) in the details table.

You'll have to replace

Source Field

with the label of the source field (most often this is the key field) in the master table.

You'll have to replace


with the field identifier in the details table that you want to do the grouping on for the purpose of generating subtotals.

To learn about field identifiers and table database identifiers please read the following FAQs respectively:


The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit