Google code script convert to onEdit code

My google code script needs to be changed to onEdit code. Changed to " function onEdt" and its not working. Try to run the script on my cell phone app. Would appreciate any help. Thanks

Please Login or Register  to view this content.

Hi Mon Star,

It would be much easier for us to try to help if you can:
* provide a sample file with sample data included so that proper testing can be done, and with the apps script included.
* give a clear detailed explanation how the script is supposed to be triggered when an edit is done (because right now its not obvious in the script)


You can use this form to create a sample file for anonymous sharing:
https://docs.google.com/forms/d/e/1F...UvZ_Q/viewform

Alternatively, you can try posting to these platforms instead:
https://groups.google.com/g/google-a...ript-community
https://stackoverflow.com/questions/...le-apps-script

Here is a picture
Attachment 881660

Please Login or Register  to view this content.

The link to the picture seems to be invalid.

In any case, it will but much more useful if you can provide a link to a sample file so that we aren't expected to create a file in order to help you.

To post a link, because you have less than 10 messages in the forum, you will need to break up the link with some spaces so that it can be posted successfully.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however we recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I added them for you because you a new.

Hope this link will help.
https://docs.google.com/spreadsheets...gid=2089475861

For the script to work on mobile, you cannot use a button to run an apps script.

To allow the script to run on mobile when cell A1 is edited, you should use a checkbox.

Heres an apps script that will give the results you are looking for:

Please Login or Register  to view this content.

Of course.

Running it from the apps script editor will give the error because there is no edit event captured by the script.

You said you wanted a script to (a) run automatically when a "button" was pressed, and (b) that it must work on mobile.

To do that requires that you use a checkbox (or some other reasonable method of validating an edit, but a checkbox is by far the easiest), and an "On edit" trigger.

Great!

As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

Also, please click Thread Tools above the first post of your enquiry, then select [Solved]