How can I capture the "Last update Date" on Form submission

(0) Share

Report

Posted on by JC-04111302-0

Hello Community

I have a datetime field in my Sql database.

Before the SubmitForm command, I want to update the date and time ("Last Updated on ") to the value as at Now(). Can anybody help me based on the above/attached file on the codes. I thank you.

Categories:

General Questions

Screenshot 2024-1...

I have the same question (0)

All responses (4)

Answers (1)

timl 35,805 Super User 2025 Season 2 on at

Like (0)

Report

Need help Please

Hi JC-04111302-0

If you set the Default property of the card 'Last Updated On_DataCard3' to Now(), that should hopefully work.

Was this reply helpful? Yes No
JC-04111302-0 18 on at

Like (0)

Report

Need help Please

Hi Timl

Thank you. I did what you suggest before coming to the community. It does not answer to the problem. I explain. The default is set to Now() and say it displays 7:40 am on the screen. I leave the application open and come back after 10 minutes and submit the form. The Last updated field on the screen is still 7:40, and this is what get updated, whereas the update field should have been 7:50 am, the actual time.. This is why I want to refresh the time before the SubmitForm is executed. Any help?

Was this reply helpful? Yes No
timl 35,805 Super User 2025 Season 2 on at

Like (0)

Report
How can I capture the "Last update Date" on Form submission

Hi JC-04111302-0

You could do this with a variable. In the OnVisible property of your screen, you can assign Now() to a variable like so.

Set(varCurrentTime, Now())

You would then set the Default property of the 'Last Updated On_DataCard3' card to varCurrentTime.

Before you call SubmitForm, you can update the variable and that should then save the actual time.

Set(varCurrentTime, Now()); SubmitForm(YourForm)

Was this reply helpful? Yes No
Verified answer

ronaldwalcott 3,827 Super User 2025 Season 2 on at

Like (0)

Report

Need help Please

If you want the actual time before the submit you could set the update property of the datacard for the date to a context variable like (initialize the value elsewhere)

UpdatedDate

and then in the OnSelect for the Submit

UpdateContext({UpdatedDate: Now()});

This should record the actual data time that the record was updated

Was this reply helpful? Yes No