How can I create a button which shows in other columns the user who clicked on it and their email address in a way that it is not possible to edit after the user clicked on the button.
I am looking for a solution where the column which shows the name (and email) of the person who clicked contains somehow a formula so in this way you can not edit the actual name and email address.
It is okay to be able to delete, just not edit.
Please have a look on this little embed document.
When a user click the button, it modifies an HIDDEN column with the user who clicked
Also, you have a DISPLAYED column with a formula, with value equals to the hidden column.
Then, people wont be able to modify the displayed column. Finally lock it if you have a team plan. If not, please keep in mind that people still can show column.
Please let me know if this answer your wish.
Quentin
Yep. The moment I wrote the message here I realized this solution as well.
So I am wondering if it is possible to use only 1 formula at the button options so to reduce columns number. And also to avoid that a user would find the hidden column.
Maybe with Formulamap?
Unfortunately, I dont think so. The action run by a button will be to modify rows, with a value JUST ONCE.
What do you have in mind using formulamaps ?
I don’t really know. I think I will just go with this solution for now. 
OK, if that can help you that’s great 
That’s the easier solution I’ve in mind for now.
Cheers.
Q.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.