# Projects

**URL:** <https://speciforum.org/t/projects/1338>\
**Category:** Specify 6 Documentation\
**Tags:** Specify-6\
**Created:** [September 30, 2023, 1:11am UTC](https://speciforum.org/t/projects/1338 "2023-09-30T01:11:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grant](https://yyz1.discourse-cdn.com/flex029/user_avatar/speciforum.org/grant/32/4255_2.png) [@Grant](https://speciforum.org/u/Grant)\
**Post date:** [September 30, 2023, 1:11am UTC](https://speciforum.org/t/projects/1338/1 "2023-09-30T01:11:00Z")

</div>

> [!warning]  
> The “Project” table is not currently available in Specify 7, though it is on our list of future enhancements to add: [#2928](https://github.com/specify/specify7/issues/2928)
> 
> Please feel free to ask for help in #Get Help or send an email to [support@specifysoftware.org](mailto:support@specifysoftware.org) for guidance on how to manage projects effectively in Specify 7.

# Projects

**Projects** :project: are groupings of collection objects linked together using a project name and other information. Each collection object can be in multiple projects and each project can have multiple collection objects.

The Project table contains the following fields by default:

- Project Name
- Project Number
- Start Date
- End Date
- Agent
- Grant Agency
- Grant Number
- Description
- Remarks

## Forms

Projects can be shown on the Collection Object form in one of two ways, as a button or as a subform. Projects **cannot** be shown as a query combo box.

> ⚠ **Note:** You cannot add a Collection Object to an existing Project from the Collection Object form.
> 
> If you wish to add a Collection Object to an existing Project, you must do so from the Project form.
> 
> ![Add existing Collection Object to a Project](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/c/c883a123f609161d6efeea06b5245064e075badd.png)

### Project Button

![Project Button](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/b/b9cccc05f55365eb05806f0f36cce85bea7a0f98.png)

This is an example of the Project form, shown when viewed in a dialog from the Collection Object form:

 ![Project Table](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/43be511a667d73dfd70defffcaf0f98d69e7887f.jpeg)

> **Button Form Definition**
>
> ```xml
> <row>
> <cell type="subview" viewname="Project" id="proj" name="projects" initialize="btn=true"/>
> </row>
> 
> ```

### Project Subform

This is an example of the _abbreviated_ Project form, shown when viewing the Collection Object form:

 ![Project Subform](https://canada1.discourse-cdn.com/flex029/uploads/specifysoftware/original/2X/4/49db1bebd3cf746d684311b3f73e8d662a6856e5.png)

You can add all fields from the Project table into this subform.

> **Subform Definition**
>
> ```xml
> <row>
> <cell type="subview" viewname="ProjectCO" id="pr" name="projects" colspan="13" rows="2"/> 
> </row>
> 
> ```

* * *

### Additional Details

- Projects have a unique `many-to-many` data model relationship, which make it unlike most other tables and links in Specify.
- Projects records cannot be uploaded in the WorkBench at this time
- Projects are only supported in Specify 6 at this time
