In managing the access levels of a sheet, it is sometimes necessary to restrict users from manually adding new values. This can be achieved by setting the sheet’s access level to only allow imports, edits, and deletes. By omitting the "add" parameter, users will no longer be able to manually insert new data into the sheet.
Implementing Access Restrictions
To restrict access, you need to update your sheet blueprint to include the following parameter:
access: ["import", "edit", "delete"]
Including only these parameters ensures that the sheet accepts imports, edits, and deletions, but disallows manual additions. Please note that this modification will also disable the preview of the sheet in the background when the user opens up the new, empty space.
Allowing Additions After Import
If there is a need to allow users to add new rows after importing a file, you can adjust the access parameter dynamically. Here’s how you can do it:
Listen for the Mapping Job to Complete: Ensure that your system can detect when the import and mapping job is finished.
Update the Workbook Access Parameter: Once the import is complete, modify the access parameter to include "add" again. This can be done programmatically by using the PATCH workbook endpoint.
access: ["import", "edit", "delete", "add"]
//or
access: ["*"]
If there is no requirement for users to add new data after the initial import, no further changes are needed beyond the initial configuration. This setup provides a controlled environment where data integrity is maintained by limiting manual data entry.