When my form opens for input, I want to set a choice dropdown to user(). I actually have this working using the default parameter on the dropdown.
But two things make me want to change it:
1. It's actually a created by value and shouldn't ever change.
2. The dropdown control won't let me radius the corners so it's aesthetically less pleasing.
And as I'm typing this out, I think I have a solution.
On the new form, I can hide the entire datacard and set the value appropriately. Then on the edit form, I can add a Input control that shows the current value and disable it. And hide the dropdown based on form mode.
Heh. lol. Thanks for attending DC's SAT. That's Self-Assisted Tutorials. 😄
That's such an obvious thing I completely overlooked it. Partly because the UI hides those columns from an All Items view by default so I just forgot entirely. Functionally for me, there is no way for the Requested By user to be anything other than the User() that creates the record right now. BUT, knowing my users, there is a high likelihood I'll be asked to create the ability for one user to created a record for another user. So I'm going to keep using my solution of just hiding the datacard and setting it's Default and Update dynamically in the background. But I'll accept your solution as it's entirely valid.
hey @DCHammer
If sharepoint is your datasource, it tracks the created by and modified by and created and modified dates by default. Therefor you do not need to build anything for it
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional