trylock | trylock | Data Processing library

You can use google.script.run to trigger functions in your script and pass values. See this overhauled script.

As pointed out in the above comments by @FyodorSoikin, @DanielWagner and @chi, the reason this was not working as expected is that hookResult was not initialised correctly.

Setting the record field to an IO (TMVar a) will result in a new TMVar a every time hookResult is read, similar problem would occur if the field was set to an STM (TMVar a) using newTMVar. To make this work hookResult needs to be set to a TMVar a from within the IO or STM context.

From your question, I confirmed as follows.

• From But when I paste the URL https://script.google.com/macros/s/###/exec?spreadsheetId=@@@@@@@@@@@@@ directly into the browser and press ENTER, the message Done appears showing that the Web App is activated., it is considered that your Web Apps is correctly deployed.

• From When I click to run the code, the Web App is not activated., when you run the script of Spreadsheet1() by clicking a button assigned to the function, the script of Web Apps is not run.

From the above situation, I would like to propose the following confirmation.

1. Please confirm the setting of your Web Apps, again. From your situation, I thought that the following setting might be suitable.

   • Execute as is Me.

   • Who has access is Anyone.

   • If Who has access is not Anyone, it is required to access the Web Apps using the access token. In this case, when you access Web Apps by your browser under logging into Google, the script of Web Apps is run. On the other hand, when you run the script, the script of Web Apps is not run. Because the access token is required to be used. I'm worried about this.

2. After you confirm your setting as the above, please reflect your latest script and setting to your Web Apps again. (It's just in case.)

As the additional information, when the access token is used for the client script, it becomes as follows.

But in this case, please test this script by you who is the owner of your Web Apps.

Use getRemainingDailyQuota() to check the effective user remaining daily email quota.

Try using a different account or wait 1 day.

The above because the error message means that the account that you are currently using have exceeded the referred quota.

I figured this out actually. I used the code on the original guide with a modification. In my HTML I removed the previous

This fixed the issue and now everything is working correctly.

I thought that in your script, when the button is clicked, google.script.run.withSuccessHandler(openWebsite).getWebsite() is run and also google.script.run.setWebsite() is run in the function openWebsite. In this case, the LockService is used for each function of getWebsite() and setWebsite(). I thought that this might be the reason of your issue. So, in your script, how about the following modification? In this modification, one LockService is used for the functions of getWebsite() and setWebsite().

Please modify openWebsite(web) in your Javascript side as follows.

The ReentrantLock maintains a count of how many times it has been locked by the current thread. This count is decremented every time you call unlock() and the lock is release when the count reaches zero. Thus, to unlock the lock, you must call unlock() as many times as you have called lock() or tryLock().

In your code, you call tryLock() and if it is successful, you then call lock() inside the try/finally block and then you call unlock() once.

The first thread to lock the ReentrantLock will thus increment the count to two but only decrement the count to one, so the lock is never released. Therefore, no other thread can ever acquire the lock.

You should use tryLock() or lock() to the lock the ReentrantLock, not both.