App Relationship Field
The App Relationship Field can be used to connect two Apps together. The App Relationship Field is most commonly used to store:
- Related Projects (e.g: the Client’s Related Projects)
- Related Tasks (e.g: the Project’s Related Tasks)
Note: You can also check the step by step process that goes into detail on how you can set up App Relationships in Fusioo.
Adding a App Relationship Field
To set up an App Relationship, navigate to the Fields page for your App and click on + New, in the App Relationships section:
Here are some of the App Relationship Field’s additional options:
| Field on the connected App | The name of the Field that will be added on the other side of the relationship. |
| Filter |
You can filter which records can be selected in a relationship. There are two options when filtering records. The first option is to filter based on a constant value. For example, lets say you want to connect a Tasks and Projects Apps. 
When adding a new Task and selecting a Related Project, you want to exclude Archived Projects from the list and only display Open Projects. To do this, we can filter out projects that have been completed or archived, as shown below: 
The second option is to set the filter based on the value of another Field. To continue with the example above, lets say you add a Milestones App to group related Tasks together. The Milestone App will be connected to both the Projects and Tasks App. When creating a new Milestone and selecting a Project, you want to limit the Tasks that can be selected to those related with the selected project. 
The dynamic (based on another Field's value) and constant filters can be combined. Using the two examples above, you can set a filter to display only Tasks that are currently In Progress and related to the selected project. 
|
Here’s how the Field will appear when you are:
-
Creating a new record
-
Viewing a record
-
In the List View
-
In the Badge View
Note: In the List View and Badge View, the Field set as Badge Heading is used to represent the record. Find out how you can configure the Badge and change the Field used as Badge Heading.
Additional Information
| Can be used for searching? | Yes |
| Can be used to sort records? | Yes |
| Can be used as a Badge Heading? | No |
| Can be used for grouping in the Kanban Board? | No |
| Filtering options |
When using an App Relationship Field, you will be able to create filters using Fields from the connected App. For example, if you expand the Related project Field, you will see all the Fields in the Projects App which you can use for filtering. 
|