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”
Hey Nick! Is your “completed by” column generated by the createdBy() formula?
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
I think there’s just something missing in your formula … especially in the
Column part of
ModifyRows()… unless this is just a typo but this …
… should work and clear the people column .
The difference for the
thisRow.CompletedBy where yours just say
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?
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.