Home / QIN / Formulas

Formulas

Syndicate content
More
How do I erase the contents of a field?

There are two techniques. The first technique is to convert the field from what ever type (i.e. numeric, text, date) it is to a formula field of the same type (i.e. formula-numeric, formula-text, formula-date). Then convert it back to the type it was. This erases the contents of the field. To learn how to change the type of a field please read the following:

February 5th, 2009 - 6:02 PM
0 comments
Tags:
More
How do I get a report with subtotals and grouping embedded on my Exact Forms custom record presentation?

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

February 5th, 2009 - 6:02 PM
0 comments
Tags:

© 1997-2013 Intuit Inc. All Rights Reserved.

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