Allow User Field To Only Be the Current User

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a Form where as certain steps are completed the user signs off that step with their User Name.  The current sign off step is a drop down user list.  Is there a way to make the drop down as only the current logged in user.  I would like to prevent the logged in user(Bob) from signing off the step with a different user name(Bill). 

Thank You

Photo of PAUL

PAUL

  • 112 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Try a form rule like this

CONDITION:

When the User is not in the Role Administrator

ACTIONS:

Change the [User drop down field] to the "the current user" (note that should be offered as a choice, if not you can force in the phrase _curuser_ with that leading and training underscore.

Make [User drop down field] read only 
Photo of PAUL

PAUL

  • 112 Points 100 badge 2x thumb
I'm sorry but this wont work. Using this rule it automatically completes the fields.  The form is built as a checklist step by step. As a user completes a step they sign it off. These sign offs are also done during a period of several days.  Is there any other solution? I just want to make sure the current user can only sign their own name.
Thanks!
There are a few other choices.  One is to have a table of users as a separate table and then use that to drive a drop down list.  The form would be set to use a drop down report where the filer on the report is where the User is the current user.

But what I actually suggest is simpler.  I would just have a field that is multiple choice for each step called like [Step 1 completed], and set that yo log changes.  Then it will log who made the update and when.