Is this possible anyone?
Row A has a 4 digit PIN saved in the record
Row B is empty, waiting for a 4 digit PIN that matches Row A
Which then shows Rows C, D, etc.
The question is, after a user types the PIN into Row B, and shows Rows C, D, etc. is there a way to reset the column B to empty, or anything other than what was entered?
The idea is (and i’m pretty familiar with security filters, slices, etc) when a user is looking at a record, or showing another person the record on their device, certain rows need to stay hidden until a pin is entered, but then, reset, so it needs to be entered each time the record is called on.
Or, is there a better way?
Thanks in advance!