Date and Time Field

(0) Share

Report

Posted on by Community Member

We would like to have a field that our dispatches and either select a date and inputs the current time.

Currently the only option I get is the time is in 30 mins increments . We would like to have the ability to have a timestamp function that my we can just check a box and input the current date and time in the field in that field.

If anyone could please and thank you

Categories:

Other

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

moko33 1,788 on at

Like (0)

Report

Have you tried a combination of Business Rule and Calculated Field?

Otherwise JavaScript.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Do you have any suggesting on how to do that?

We wouldn't care if the date/time field would just fill in the current time once you pick the date. Cause the Customer Portal does exactly that and its using the same form and field that the Dynamic 365 CRM form( case - Web create Form) does and we you are input the date in the CRM form not through the portal it just has the time in increments of 30mins... So frustrating. Any suggest would help thank you!

Was this reply helpful? Yes No
Suggested answer

moko33 1,788 on at

Like (0)

Report

After having testet it I would recommend:

1. Create a new field as your checkbox: Two Option Set i.e. "Set Current Time". Put it on the form.

and then either with Business Rule:

2a. Create a Business Rule with Scope "Entity". Condition: if "Set Current Time" equals "Yes" AND "Time From Promised" (and/or other fields) does not contain data THEN Set "Time From Promised" to "Modified On".

If you want, ad Action(s) for other fields as well . Works also with "Date Window Start" and "Time Window Start".

or 2b) with Java Script: please search this forum for code examples on how to set now() via JS.

The difference is: with a) you're able to see the filled in timestamps on the form only after the record was saved the first time whereas with b) you would be able to immediately see the filled in timestamps.

A calculated field is uncomfortable because it gets calculated only when saving the record a first time. So you would need to savo your record even a second time then to copy its value into other fields.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

So, I don't think, it worked. It looks like it doing nothing different.

I would like when you pick the date it auto fills the time....

Was this reply helpful? Yes No
Suggested answer

moko33 1,788 on at

Like (0)

Report

For the business rule: have you set the Scope to: Entity? Also the field providing the date (ModifiedOn) should be on the form so that it gets loaded by the client.

However this would fill out the whole date and time, but not only the time field.

If you want to adjust only the time which is auto-populated, I'm not sure if you could address this field with JavaScript. However a Business Rule doesn't help here.

Maybe also a custom control (Canvas PowerApp) could do the job for you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

So the business rule is set to Entity:

I publish all customization and rule is activated

But for some reason very time a check the box it does not input the date and time.

Was this reply helpful? Yes No
moko33 1,788 on at

Like (0)

Report

Hi RolandR,

for me that works and my Business Rule looks exactly like yours.

The timestamp gets filled in only when you click Save after you had checked the checkbox. So that the filled timestamp is visible on the form only after the first time save.

Also I found out that the "Modified On" doesn't need to be on the form.

Was this reply helpful? Yes No