Navigation

    ask avan logo
    • Register
    • Login
    • Search
    • Categories
    • Unsolved
    • Solved

    How to get Google Script Code work on mobile?

    Spreadsheet Macros
    google-apps google-script google-sheets
    2
    3
    42
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • K
      Karl Müller last edited by

      Hey, I hope someone here can answer my this question. I am sadly a beginner and have the following problem.

      I have a table in Google Sheets in the format:

      A B C

      Day Date inventory demand

      Day2 Date2 inventory demand

      etc.

      Others are required to fill in inventory and demand every day. However, they should only fill out demand and inventory of the current day. They are also not allowed to change previous data or in advance fill in future days inventory and demand. Therefore, I want to protect the whole sheet from being edited by others, except the row with the current date. For example today (23.09) they should be able to edit the row where B is 23.09.2019 and nothing else.

      This works perfectly fine on desktop, however not on mobile. How do I get this to work in the Google Sheets App for Android (and maybe also iOS). Here is my question, which I also asked on Stackoverflow with the code and my current sheet: https://stackoverflow.com/questions/58060110/google-sheets-exclude-the-current-date-row-from-protection/58062250#58062250

      Thank you very much!

      Reply Quote 1
        1 Reply Last reply

      • avan
        avan last edited by

        Hey Karl (@Karl-Müller) I am not too familiar with macros but I would still love to look into it. Do you mind sharing the link to the google sheet?

        Reply Quote 0
          1 Reply Last reply

        • K
          Karl Müller last edited by

          Hey I am sorry I linked to a wrong post in my question. https://stackoverflow.com/questions/58286707/exclude-the-current-date-row-from-protection-in-the-google-sheets-app?noredirect=1#comment102941654_58286707 here you can find the question better formulated with the google sheet.

          Thank you very much!

          Reply Quote 0
            1 Reply Last reply

          • First post
            Last post