Gam adv Sheets Data validation

[Keith Burtt]

I know this prob cant be done atm but in the sheets is there a wat to create a Data validation rule. I know I can do it with Google Apps script but i would like to do it all in one place. the reason being is I export the data from admin panel to a google sheet with restricted permisions so people can select yes or no the issue is when I write to it it deletes the current data valadation. Any help would be great.

Keith

[Keith Burtt]

I have been using gam user email@mail clear sheetranges id range 'google check!L2:L2000' but it clears values as well as Data valadation any ideas would be great.

Keith

[Ross Scroggs]

Keith,

I'm in California (PDT), I'll be available tomorrow after 10:00AM PDT if you'd like to have a Meet/Zoom session to discuss the issue.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/0e5ea5ce-d375-4f64-aa8d-5a5893bf706an%40googlegroups.com.

[Ross Scroggs]

Keith,

You can use GAM to define Data Validation rules.

$ more YesNo.json 

{

    "requests": [

        {"setDataValidation": {"range": {"sheetId": 0, "startRowIndex": 0, "endRowIndex": 3, "startColumnIndex": 0, "endColumnIndex": 1},

                               "rule": {"condition": {"type": "ONE_OF_LIST", "values": [{"userEnteredValue": "Yes"}, {"userEnteredValue": "No"}]},

                                        "inputMessage": "Enter Yes or No", "strict": "True", "showCustomUi": "False"}

                              }

        }

    ]

}

$ gam user us...@domain.com update sheet <SheetFileID> json file YesNo.json

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Sep 16, 2023, at 1:38 AM, 'Keith Burtt' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

[Yehuda Alexandroff]

Sorry to bring this back up, but is there a way to write a Data Validation rule that uses "Dropdown (from a range)" on another sheet? If so, what would that look like? Here is what I'm looking for:

Thanks,

Yehuda

[Ross Scroggs]

It doesn't look like it.

Here is the API dicumentation for data vavidation:

https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/other#ConditionType''

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On May 20, 2025, at 7:46 AM, Yehuda Alexandroff <yalexa...@bialik.ca> wrote:

Sorry to bring this back up, but is there a way to write a Data Validation rule that uses "Dropdown (from a range)" on another sheet? If so, what would that look like? Here is what I'm looking for:

<Screenshot 2025-05-20 at 10.44.56.png>

To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/c3bdcad9-776a-4a63-be14-9f34cd6d725bn%40googlegroups.com.
<Screenshot 2025-05-20 at 10.44.56.png><Screenshot 2025-05-20 at 10.45.33.png>