Hello!
I have a tasks DB, and a column called “Completed By” which sets the user of the person who completes the task.
My question is, how do I make a button to clear the cell when the task is “un-completed”
ModifyRows(thisrow,CompletedBy,"") does not work, nor does “Blank”
Thank you!
Hey Nick! Is your “completed by” column generated by the createdBy() formula?
Hi Scott!!!
The Created By column is type: People and set by using the value for new rows function to user()
The Completed By column is type: People and is set by a “Mark Complete” button in each row. It uses ModifyRows(ThisRow,CompletedBy,user())
What I’m failing to do is CLEAR the completed by field with a button
clearing a row by putting ‘nothing’ via
thisRow.ModifyRows(thisRow.Name,"")
cheers, Christiaan
Pch
5
This should work for you, seems like you are doing it right
Can you shared your doc or an example if you keep having issues?
system
Closed
7
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.