If the "order" button is in a form, this is very simple to do using dynamic form rules. There is an option to change a date field to current date from a trigger:
You can use this in a formula rich text field if you want to use the button from table reports or in emails:
//This is the button styling:
"<a style=\" text-decoration: none; background: #00ff00; border: 10px solid #00ff00; border-radius: 3px; color: #000000; display: inline-block; font: normal 700 20px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;
//This is the button code for your database; be sure to add your app token
href='"& URLRoot() & "db/" & Dbid() & "?\n\na=API_EditRecord&apptoken=XXXXXXXXXXXXXXXXXXXXXXXXXX &rid=" & URLEncode ([Record ID#])
//Change 20 to your field ID for status
& "&_fid_20=Approved"
//Change 19 to your field ID for approval date
& "&_fid_19="& ToText(Today())
//This is a redirect to report with ID of 2; change 2 to the ID of the report you want to display
&"&rdr=" & URLEncode(
URLRoot() & "db/" & Dbid() &
"?a=q&qid=2"
)
&
"&ifv=20'>Approve</a>"
------------------------------
Adam Keever
------------------------------
Original Message:
Sent: 10-29-2019 09:14
From: Mike Klausing
Subject: Date field to return original date of order
I have a date field that I need to show the date an order was sent in. Right now my formula is:If([Order Status]="Approved", Today())
But this returns todays date and updates each day with the current date. I need a date of when the "order" button was originally clicked and order status was changed to "approved" Is the Today function proper in this case?
------------------------------
Mike Klausing
------------------------------