Relationships
App can have relationship with other App via this feature. There are three types of external App relationship available.
Note: Only Column Name can be modified for existing Lookup field. You cannot change other details.
- Lookup
- Summary
- Common Column
Lookup
This feature allows you to Lookup or pick a field value from another app. E.g. In Time Tracker App, Title is a Lookup field from Tasks Manager.Summary
This feature allows you to get summary (Total Or Average) of Lookup field from another app. The App has to be connected to another App via Lookup field.Adding a Relationship Column
- Select a Site
- Click App Name on site menu
- Click "App - Settings" from "More..." drop down menu located on top right corner of page
- Click "Relationships" link in left hand menu
- Click "New Relashipship" button located on top right corner of page
- Provide "Column Name"
- Select the type of relationship you want to create.
- Select Site and App which has to be related to the current app
- Click "Save Column" button
Edit a Relationship Column
- Select a Site
- Click App Name on site menu
- Click "App - Settings" from "More..." drop down menu located on top right corner of page
- Click "Relationships" link in left hand menu
- Click "Edit" link next to the column you want to edit
- Change required details
- Click "Save Column" button
Note: Only Column Name can be modified for existing Lookup field. You cannot change other details.
Deleting a Relationship Column
- Select a Site
- Click App Name on site menu
- Click "App - Settings" from "More..." drop down menu located on top right corner of page
- Click "Relationships" link in left hand menu
- Click delete icon
located in "Edit" column
- Click "Confirm" button in the confirmation box to remove the Lookup field
[insert_php]
echo custom_database_side_menu("relationships");
[/insert_php]