Hi all,
I want to set a variable based on the current timestamp and date along with a prefix.
for example.
Set(UniqueID,"GB"+Today()+somethingaboutseconds)??
I assume it will be similar syntax for pre-populating a textbox with "Welcome" and appending an office 365 username to it?
If so, how do I do that too :)? At the moment I have two text boxes, one with 'Welcome' and another with the Office.365Users.Myprofile().Displayname in it. Would be great to have this in one box so I can align more reliably.
Thank you!
Set(
UniqueID,
"GB" & Value(Now())
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
That did it!
Thank you
Now I need to try and figure out how I would convert 'GB1238/29/2023 8:47 AM' into a string / so it looks more like
#GB1238292023847
Try:
Set(
UniqueID,
"GB " & Now()
)
And:
"Welcome " & User().FullName
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2