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 use AppendRow
- How can I resolve this `Error: You must select all cells in a merged range to merge or unmerge them.` while merging cells through App Script?
- Casting method asTextItem throws error for Google form item
- Dynamically integrate data from Sheets into a Web App to feed a Graphic
- Draw and filter Charts in App Script Web app
- How can I cache an object in Google Apps scripts
- showModalDialog vs showModelessDialog
- What happens when you set a Month Timer Trigger to fire on the 31st for a month that doesn't have 31 days?
- Duplicate whole spreadsheet using Google Sheets API
- What is the purpose of the "access_token=" parameter when downloading a file from Google Drive?
- NAME error hiperlink function Apps Script Google Sheets
- Convert a Markdown text file into a Google Document using Appscript?
- Trying to get Google App Script Code to Acknowledge Cells In A Column in Excel to do Individual Math
- Condition if-else
- While iterating through a loop, Logger.log repeatedly prints the same value
- How to integrating Google Sign-In into your google script web app
- Get dropdown options in google sheets in table
- One-to-one assignment in Google sheets with data validation
- Revert all files in a Google Drive directory to old version
- Google Apps Script findtext searchpattern format?
- How to tell if a ListItem has any text that is italicized?
- How do i get all h1 headings in google doc with google apps script?
- If spreadsheet ID is not equal to and number of rows less than?
- AppScript throwing Exception error of Spreadsheets when trying to access Charts present in a Google Sheet
- Why is this 2D array filtering not working?
- Using a gs function with an input from a selection in html on appscript
- How would i fetch the data from a google apps script web app html form?
- Disable/Remove Signature from draft created with Apps Script / Google Card Service
- In Google Apps Script, how can I set the HTTP response code for a service I implement?
- Google apps script Selecting sheets from dynamic menu in google sheets