Lock/Save random chosen single value


I am trying to create some sort of a game where people click a dice, a new row is added to a sheet and some columns are automatically filled with two random category’s (text) and an random image out of a column of another sheet. Then they go automatically to a new screen and see the result of the added row.

I managed to do this with the ‘single value’ option in some columns to search for a random value in another column. But the problem is that it keeps searching for random values again and again. So I want it to search for a random value and then save the value for that added row. Is this possible?

Thanks in advance!

Take a look here. I address the issue:

1 Like