Cannot find Apps Script !

[Alan Harris]

Hi. Desperate of York , UK here.
I am creating an online spreadsheet for a charity competition I'm running for Brain Tumour Research as we lost our daughter Rachael to a tumour.
I have zero knowledge of apps script as I'm sure this post will confirm
I wrote the spreadsheet in Excel and all has been ok.
Entry to the competition will be online so that anyone in the UK or world for that matter can enter
The main thing I wanted to do was create a script that when the entry form was completed it copied the contents to the database and cleared the form.
It works and I put it on a button in the relevant tab.
However when the file is put in Google drive and shared the button  doesn't work.
I googled this and I'm guessing the issue is I don't seem to have apps script in my browser and as a result in Google drive when I open Google sheets it isn't where everyone on Google says it will be.
I don't have extensions in the menu or Apps script in tools. When I look at the store to install extensions I cannot see that extension.
Any thoughts or help with this would be very much appreciated.

Alan

[Andrew Roberts]

Share your sheet and we can take a look.

--
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 on the web visit https://groups.google.com/d/msgid/google-apps-script-community/fb925db5-26b7-4b03-8270-fd3fe45415c2n%40googlegroups.com.

[Keith Andersen]

Alan,

Is there a reason you aren't using a Google form connected to the spreadsheet for your project?  This would eliminate a need to write any script nor problems where two people are in the same sheet form at the same time.

Keith 

Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAN1QPJRnDvhSf5wAUgCf74uer21gH3WBkxz-Vj5WM-ukAe5E%2BA%40mail.gmail.com.

[Alan Harris]

Hi

Thanks for getting back to me. I actually worked out what it was. I was trying to use an xlxs file on Google drive. Once I converted it to Google sheets it was OK (with a few tweaks)

However I was wondering if someone might be able to help with another (hopefully last)problem.

It's now working for laptop/PC and can view on tablet /phone. Not essential but would be nice if the buttons worked on a tablet. I have watched videos on this and did try once but its beyond my knowledge really. Any help with that would be much appreciated 

Alan

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/jmq44_svBkk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAN1QPJRnDvhSf5wAUgCf74uer21gH3WBkxz-Vj5WM-ukAe5E%2BA%40mail.gmail.com.

[Keith Andersen]

Alan,

Macros by buttons do not work on tablets or phones.  There is a work around using onEdit() and drop downs but it is neither reliable or intuitive for the user.

Which brings me back to my original suggestion- use a Google form that you can make publicly available as a link on social media, email and on a website.  Google forms are easy and post all submissions directly to a spreadsheet for you - no code needed.

Keith

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

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAASUMxdfzKcvxuO%2BoikNh0Qv97ZN_jH4hGwPp_e51WsmfZxhog%40mail.gmail.com.

[Alan Harris]

Hi Keith thanks for reply.

As you can tell I'm no expert.  Have not used Google forms.

Below is the link to what I have done. Would it be possible to have a quick look at the entry form tab and let me know if it's possible in Google forms

https://docs.google.com/spreadsheets/d/1Y26q80Zsnz9fPxB6fpatpQAmzi2wNpKjh3da9mJDVDE/edit?usp=drivesdk

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAFKgK%2BHap4tPc9YrsF8vEFpMWR%3DUSVCsMOZGBELwMDtDQK1x1Q%40mail.gmail.com.

[Keith Andersen]

Alan - what is the name of your organization?

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

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAASUMxdfxgKLevMc8_e2skiO5k4DQAsmgQrjnWeWvrVBjq8yQg%40mail.gmail.com.