pre

Syndicate content

You will need (at least) two related data tables to achieve this result. Assume that you already have a table called Projects with a User field called 'Assigned To'. This article will show you how to use this field in a relationship to a resources table, allowing you to bring one or more additional data values into your Project based on the fact that one of your users is assigned to the Proje

February 5th, 2009 - 6:02 PM

Create two summary fields in the Projects table (To learn how, please see our Create a Summary Field help topic). The first summary field will be labled "Number of Tasks". It should be configured to count the number of Tasks. The second summary field should be labeled "Number of Completed Tasks".

February 5th, 2009 - 6:02 PM

Create a formula field of type "Formula URL - (Link)". Let's assume the first application is a list of action items, and the related application is a list of related files. Then you need to create a formula like the one below:

URLRoot() & "db/6k7gvdyw?act=API_GenAddRecordForm&_fnm_issue_id="
& URLEncode(ToText([Record ID#]))

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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