Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Python: how to create spreadsheet column with validation list #99

Open
framinlab opened this issue Dec 21, 2021 · 2 comments
Open

Python: how to create spreadsheet column with validation list #99

framinlab opened this issue Dec 21, 2021 · 2 comments

Comments

@framinlab
Copy link

On the website, you can create a Quip spreadsheet and set certain columns to present a popup with a validated list of items. For example, column A of each row could be "Yes" or "No" values and column B could be the names of US state. You can even assign colors to each menu item. Column three could be a free-form chunk of text.

I'm looking to programmatically take output from a database and create these via the Python API. Doesn't have to be python. Just wondering if this capability is exposed via the API.

Any way to do this?

@brownhoward
Copy link

Any updates on this issue? I am implementing a Python app that populates a Quip spreadsheet with rows that contain a cell that ideally should have Data Validation (Green, Yellow, Red). Is it possible to apply Data Validation to a cell via the API?

I setup a Quip spreadsheet that includes the required Data Validation, and then got the thread. Even then I did not see how the Data Validation is stored/applied. Is it even possible to view the Data Validation for a cell via the API?

@automaton-brandon
Copy link

Is anyone ever going to answer this question? I've seen it posted a few times on here...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants