How can I read the User properties saved in the File/Project properties menu?
In the Google Apps Script editor, I can set a user property by opening the File > Project properties menu, and then selecting the "User properties" tab. However, it seems that the PropertiesService is unable to access the values set in this menu. Is there a way I can access the values set through this menu in my script?
Set {"propertyA", "valueA"} in "User Properties" tab (pictured below)
Run
PropertiesService.getUserProperties().getProperties()Output:
{}
If I were to then run PropertiesService.getUserProperties().setProperty("propertyB", "valueB"); and then getProperties() again, the output would update to show only {propertyB=valueB}.
Similarly, as my searches all direct me to the PropertiesService, where can I find documentation about these menu properties? (Specifically, I'd like to know when I should use the menu option versus setting the values programatically.)
No. The GUI for accessing user properties was never updated when the UserProperties class was deprecated in 2014. The issue was finally resolved with the redesigned Apps Script IDE in 2020, which removed the GUI for accessing properties altogether.
Although it is possible to access the legacy IDE and modify script properties via the menu, the only way to access user properties is programmatically with PropertiesServices.getUserProperties(). Google has also published a guide to the Properties service.
- How to identify whether Google Apps Script is launched as a Trigger or Manually?
- Google Script Select Partial Text in Docs
- Hide rows in google spreadsheet if Column A is empty?
- How to export all pages in Google Sheets tab page to PDF?
- How can I use Google Sheets Apps Script to Auto Generate today's date when an edit is made to a given column?
- Cannot completely rename Google Apps Script
- TypeError: Cannot set properties of undefined (setting 'FIRST_NAME') in Google Apps Script
- An explicit urlFetchWhitelist is required for all Google Workspace add-ons using UrlFetchApp error while deploying sheet add on
- How can I write a Google Sheets script that will clear some cells while setting others to zero?
- how to show instruction with image after install google workspace extension
- Regular expression to extract valid cell references from a spreadsheet formula
- My Google Apps script regex requires a match for either one expression or another.
- If checkbox checked set values
- Clarification on using the forEach() function
- Rank based on which column is being sorted by in a Table
- Auto border to a Dynamic Data
- How can I determine if a respondent's email address is unique in a list?
- Sum a number of range values; process and add to array
- Fill Google Form from Other Google Form Responses
- Downloading a PDF version of the open spreadsheet in Google Drive via scripts
- exporting spreadsheet to pdf then saving the file in google drive
- Convert a Markdown text file into a Google Document
- A Script to Simplify Creating a SO Table
- Archive a row after a dropdown status is selected on multiple sheets
- Get Google Sheet by ID?
- Google Sheets macro to copy a line of data to next empty row on another sheet
- Error 'Action Not Allowed' When Copying Content with a Vertical Line in Google Docs
- Remove an attachment of a Gmail email with Google Apps Script
- Google Apps Script switching html files
- How to make a simple authentication in Google Forms using Google apps script?