[Bug] OpenChallenges Data spreadsheet automated code does not work for everyone

[tschaffter]

Is there an existing issue for this?

• [X] I have searched the existing issues

What product(s) are you seeing the problem on?

OpenChallenges

Current behavior

I added the name of a new challenge. The ID was successfully generated but not the slug. The slug used to be automatically generate for me in the past.

~Interestingly, the fields createdAt and updatedAt have been successfully populated, which was not the case for me in the past.~

UPDATE: I realize that the createdAt and updatedAt are from Aug. 25 so they have not been generated by me today.

I opened the Apps Script tool as suggested by @vpchung and ran the script Code.gs, which generated the following error:

Expected behavior

The cell in the column slug should be automatically generated when entering a value in the column name.

Anything else?

I'm signed in with my Sage Google account.

Commit ID

No response

Are you developing inside the dev container?

• [X] I am using the dev container

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[tschaffter]

Now the field slug is automatically generated for 4 additional challenges, but this time the values in the fields createdAt and updatedAt are not generated. 🙃

[tschaffter]

The issue was that the value of a read-only cell for a given user could not be set using a function or script. The solution was to give me write access to the cells that were not being updated automatically.