User() in a formula
Hello,
I have a URL formula showing as a button on a form. When clicked, I have the formula populating a Date/Time field with now(). I would also like to populate a user field with User() to capture who clicked the button, but I am receiving an error when I put this into my formula that says "The operator & can not be applied on user." (See image below; fid 534 is a User field)
I also tried creating a field that just holds user() and setting field id 534 (user type field) to that field in the formula: "&_fid_534=" & [CurrentUser] & .... but get the same error.
Is there another way I can achieve this?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
I have a URL formula showing as a button on a form. When clicked, I have the formula populating a Date/Time field with now(). I would also like to populate a user field with User() to capture who clicked the button, but I am receiving an error when I put this into my formula that says "The operator & can not be applied on user." (See image below; fid 534 is a User field)
I also tried creating a field that just holds user() and setting field id 534 (user type field) to that field in the formula: "&_fid_534=" & [CurrentUser] & .... but get the same error.
Is there another way I can achieve this?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
