Skip to main content
Question

Date field to return original date of order

  • October 29, 2019
  • 0 replies
  • 16 views
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
------------------------------
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Registered
  • October 29, 2019
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
------------------------------
    Terms & ConditionsAccessibility statement