In This Topic
Permissions and krewSheet (Pivot Table)
Permission settings of kintone are also valid in pivot table. This section describes specific behaviors of configured permissions.
![](images/appset_menu_permission.png)
Permissions for App
- If you do not have the "View records" permission, an error would occur when you try to access the app.
- If you do not have the "Add records" permission, blank cells with no records in the pivot table will be read-only.
- If you do not have the "Edit records" permission, all cells are locked.
- "Delete Records" is not possible in the pivot table.
- If you do not have the "Export to file" permission, the Export button on the command bar is disabled.
![](images/appset_permission_app_xross.png)
Permissions for Record
- If you do not have the "View" permission, the records are not fetched.
For example, the record permission is set as shown below, the records whose number is 2 or larger are not fetched.
![](images/appset_permission_recordview.png)
- If you do not have the "Edit" permission, you can still fetch and edit the records. However, you can edit it in the Value's field, but when you click the Save button, an error appears to prevent saving.
For example, the record permission is set as shown below, the records whose number is 2 or larger can still be edited. However, when the Save button is clicked, an error appears in the status bar to prevent saving.
![](images/appset_permission_recordedit.png)
- Record cannot be "Delete" on the pivot table.
Permissions for Field
- If you do not have "View" permission, a message will be displayed. For example, when you use a field with the following permissions,
![](images/appset_permission_field1.png)
The following message "You do not have permission for Fields Updated by to view." is displayed and the pivot table is not displayed.
![](images/appset_permission_field1_xrossruntime.png)
- If you do not have the "Edit" permission, the fields are locked at runtime to protect from editing.
![](images/appset_permission_field2.png)
List of Permissions
The following tables summarize the above descriptions.
kintone Standard
|
No "Add" permission |
No "View" permission |
No "Edit" permission |
No "Delete" permission |
No "Export to file" permission |
App |
Add button gets hidden |
Error message is displayed |
Edit button gets hidden |
Delete button gets hidden |
Export to File gets hidden |
Record |
- |
Applicable records get hidden |
Edit button of apllicable records get hidden |
Delete button of applicable records get hidden |
|
Field |
- |
Applicable fields get hidden |
Applicable fields are uneditable |
- |
|
krewSheet (Pivot Table)
|
No "Add" permission |
No "View" permission |
No "Edit" permission |
No "Delete" permission |
No "Export to file" permission |
App |
Uneditable blank cells with no records |
Display error mesaage |
Non-editable |
- |
Disable "Export" button |
Records |
- |
Hide target record (※1) |
Display error message when saving |
- |
- |
Fields |
- |
Display error message |
Target field cannot be edited |
- |
- |
※1. If you have enabled the display of items with no data in the following fields, all items are displayed in row and column.
- Radio button
- Check box
- Multi-choice
- Drop-down
- User selection
- Department selection
- Group selection
krewSheet(詳細(集計元データ))
|
No "Add" permission |
No "View" permission |
No "Edit" permission |
No "Delete" permission |
No "Export to file" permission |
App |
"Add" button gets disabled |
Error message is displayed |
Uneditable |
"Delete" button gets disabled |
"Export" button gets disabled |
Record |
- |
Applicable records get hidden |
Display error message when saving |
Display error message when saving |
- |
フィールド |
- |
Display error message |
Target field cannot be edited |
- |
- |