insert time and date to fields when name selected

[stuee]

Hi, in the same table i have 3 fields.

Name   (this is the drop down of names)

Timecompleted

Datecompleted

 

I want to have so when a person selects their name in the drop down to complete this task that the current time stamp is filled in.

I cant seem to get it to do that but ideally i would like just one field with timestamp   15:30  21/02/2019

 

I also have about 50 tasks which people can do so hoping a more simple way instead of a fll script for each one.

 

Hope that made sense

 

Cheers

[comment]

2 hours ago, stuee said:

ideally i would like just one field with timestamp 

So define a timestamp field. Then set it to auto-enter a calculated value:

Let ( trigger = Name ; Get ( CurrentHostTimestamp ) )

 

[stuee]

Thanks for that, it works perfect. I do have a couple of other little things im trying to sort too which are driving me nuts, can i pm you please.

Cheers

[comment]

6 hours ago, stuee said:

I do have a couple of other little things im trying to sort

Post more questions (in new threads).