new owner to google sheet, link to button broken.

[Rick Sutton]

Hello. I was added as new owner of a sheet and it had a script added to a button which was work fine before. we tired to run the script the button and get :  Script function copyOnlineDataToDb could not be found. script runs fine in editor.  any clues.

Thanks in advance

[Bennett, Scott]

This is just a guess.  Make sure you sign out of all accounts and then sign back into the one that you are using to run the script.  

On Fri, Oct 7, 2022 at 11:59 AM Rick Sutton <rsutto...@gmail.com> wrote:

Hello. I was added as new owner of a sheet and it had a script added to a button which was work fine before. we tired to run the script the button and get :  Script function copyOnlineDataToDb could not be found. script runs fine in editor.  any clues.

Thanks in advance

--
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/fec4d7b5-61e9-40c0-84d5-0a7d6698d68fn%40googlegroups.com.

--

Scott Bennett

[Rick Sutton]

lol thanks, but i am new to all this and it is one of those thing that are thrown in your lap to do.

so how would i kick everyone out and sign back in.  I am running it as me the owner and I also had another person try to run it.

they have editor rights.

[CBMServices Web]

I suspect the most likely cause is that the script calls on an external script library file that you do not have access to. Speak to the previous owner and ask him to ensure he enables access to the library for you.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/74e61ed8-a4f7-4aca-b8d5-d27526e083a5n%40googlegroups.com.

[Bennett, Scott]

No, you need to sign out of all the Google accounts of the person trying to run it.  

For example, I have people that are signed in to both their work account and personal account. 

Then when they go to run the function, the accounts are conflicting since only one account has the rights to do it.  

Whomever is trying to run it, make sure they are only signed into the google account that has access.  

Basically, click on the account at the top right and select sign out of all accounts, then sign in to the one that should run the code.

If they only have one account, then I am not sure what is going on.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/74e61ed8-a4f7-4aca-b8d5-d27526e083a5n%40googlegroups.com.

--

Scott Bennett

[Rick Sutton]

thanks.  they are all in with their work accts. the previous owner no longer works here he only had this one file which I transferred ownership.

I can edit all , add users etc but get the script to run with the button in the sheet.

the library is empty I didn't any call to (sendmail) in code or macros.  assign a script has a diff name. 

[CBMServices Web]

I can take a look for you if you want. Add me as an editor and I can let you know.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/33efbe10-51e6-4ed4-bdd4-4fba778765c7n%40googlegroups.com.

[Rick Sutton]

question does the code and macro function have to have the same name? the error msg ::::: Script function copyOnlineDataToDb could not be found when click on 

add to database button. I have closed and when back in and the same thing.  owner ship transferred to me .

No data in library and run fine with no errors in appscript. also in app script the project name is:::::sendmail.

Thank you for your help I will check back. 

[CBMServices Web]

No. the files code.gs and macros.gs should be different names and not the same.

The script specified by the button needs to be identical to the script function name. Superficially looking from the picture you posted, they look the same. But can't tell if there are any spaces added or not somewhere which may be causing problems..

 What you can do is remove the script function name from the button (right click button, then click on the 3 dots and choose assign script and then delete what is there). The double click the function name copyOnlineDataToDb from the code and then paste it into the button (Assign Script). Do not put any parentheses there. 

You can also look to ensure that the function defined in the code is being well defined by checking to see if Google recognizes it as a function (click the down arrow besides the run/debug and see if that function is present in the dropdown list.

 Good luck.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/0259ab55-c462-4ff1-bdd6-3b145431ed11n%40googlegroups.com.

[Rick Sutton]

Morning Hope you had a great weekend. I have done the above that Mr. George suggested and the following.

1. sheet and script, was owned by employee who left.   I logged into his google and changed the ownership of the sheet to me nothing else

2. it is a monthly back that I am assigned to do, so went to sheet did the back up and there is a step to data to database. (script)

3. click the button and no script found.  ran the script no errors completed fine.  add the script to button no spaces no parentheses.

still came back with error.

I saw somewhere where it said to have the script authorize.  Don't know if that was broken when I took ownership of the sheet.?

as it doesn't work for any of the 15 people who have edit rights including me. we can do it manually and it work fine also.