How to get Google Script Code work on mobile?
-
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!
-
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?
-
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!