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"]+"'}^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=15");~

You'll need to replace

targetdbid

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

You'll have to replace the

12

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

15

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:

http://quickbase.intuit.com/developer/node/2027

http://quickbase.intuit.com/developer/node/2106

Reply

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.

© 1997-2014 Intuit Inc. All Rights Reserved.

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