google apps script - get the form attached to a spreasheet -

google apps script - get the form attached to a spreasheet -

i'm working "new" version of google ss.

i'd form attached spreadsheet i'm in, this:

function findformurl() { var ss = spreadsheetapp.getactivespreadsheet(); homecoming ss.getformurl(); }

however, function not work yet in new version.

anyway,it gives url of form, interesting, i'd have form id or object can work it, alter stuff etc. possible ?

this indeed annoying there possible way around missing feature using drive search capabilities... tested code below , worked.

i agree far ideal , requires have form has same unique name spreadsheet it's improve nothing.

function getformtest() { var ss = spreadsheetapp.getactivespreadsheet(); var nametosearch = ss.getname(); logger.log('title contains "'+nametosearch+'"'); var forms = driveapp.searchfiles('title contains "'+nametosearch+'"'); while (forms.hasnext()){ var formdoc = forms.next(); logger.log(formdoc.getmimetype()); if(formdoc.getmimetype()=='application/vnd.google-apps.form'){ break; } } logger.log('formdoc = '+formdoc); var form = formapp.openbyid(formdoc.getid()); var items = form.getitems(); for(var in items){ logger.log(items[i].gettitle()+' '+items[i].gettype()); } }

google-apps-script google-apps