How to get the status of a checklist menu item with google script?

[J Y]

Hi,

Please see the example google doc below.  I would need to get the status of a checklist menu item.  I include a piece of code in the doc but it fails to get the status.  Can someone please help me out?  Thank you very much in advance.

Test3 - Google Docs

JD

[Michael O'Shaughnessy]

Well, in my quick research this is unfortunately not something that Google has exposed to GAS.  Now, what I am talking abou is the "checklist menu item" in Google Docs.  This is where a box can be checked and you can format the text as "strike through" when checked.  THIS is something that you can check for!!

My next question is, does this have to be a Document?  Can you switch to a spreadsheet?  The checkboxes in a spreadsheet show up as either true or false so you can definitely check for those.

AND as always... if anyone knows anything different PLEASE do not hesitate to let me know!!  This is how we all learn... sharing our knowledge as we know it!!

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/8ef71180-4909-4e9d-acec-2434f8d8444cn%40googlegroups.com.

[J Y]

Hi Michael,

Thank you very much for your attention.  Unfortunately, it has to be a document.  I am surprised that google doesn't provide an API function for a feature it supports.  It's just a wrapper function that calls its internal, corresponding, existing function.

JD

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/15Dm31rKwhk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAHNYQLhDjgJZoHsL-u%2BgxQAZjYrMW1%3DfLdpa7C%2BhD_03F91TXQ%40mail.gmail.com.

[Keith Andersen]

See TestDoc3

Tried every which way - app script will not read value of checkbox or dropdown in table in Google Doc. 

Work around - type in True

See my function for example.

Cheers

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAEr%2BM4bVXBviwp3%3D9S3%2BZxcMx9yvBTmZd5v%2B31QeKumvgDRseA%40mail.gmail.com.

--

My Site: https://www.sites.google.com/view/klaweb/

Passions: God, Family, Friends, Scripture, Data Management, Google Sheets + App Script, MS Access, Programing, sharing and much more.

[Michael O'Shaughnessy]

Yes, I agree that Google should "let us get to it" however it could be "new".  Since you said it has to be a document let's see if we can "emulate" a check box!!

Make a copy of this document: https://docs.google.com/document/d/1GWZOVBkBubWUFAn5rKhYT91cA9Gum6njnAFx5uQNkRQ/edit?usp=sharing

Look at the code and run it.  You will get a lot of info in the console. 

Users can type an X just as easily as clicking on a box.I also chose X just to make it look "checkboxy".  I am sure you can modify the code to check for "not empty" so they can put anything in that cell.

Just a thought... trying to help you think outside the box and give you something to work with.

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/CAFKgK%2BEvB0%2Bj%3D0ON%2BJTF3HHJy7iaY7-MR%3D8EdVbX3crTtyZ78Q%40mail.gmail.com.

[J Y]

Thanks to both Michael and Keith.  I appreciate that you have tried to find a workaround for google's limitation.  I will take them into consideration if I cannot migrate to google sheet.  Thank you again!!

[Keith Andersen]

Welcome. Good luck.

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/18bebbbc-efb9-435d-b4cc-a447098f7e9bn%40googlegroups.com.