User() in a formula

Question

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------------------------------

AustinK · Answer

Does changing it to be UserToEmail(User()) help at all? You should probably also wrap that in an URLEncode just in case.

Sign up

Login to the community