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 curre...
Forum Discussion
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:
------------------------------
Adam Keever
------------------------------
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
------------------------------
@Adam Keevers solution should give you the desired results. if you are using form rules and button, use the 'API_Editrecord' function in formula url button to update the date field value with current date.
------------------------------
Babi Panjikar
------------------------------
------------------------------
Babi Panjikar
------------------------------
- I am using a formula URL field which is:
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=cpaz2k7njc4ifc24muhvc749ast&rid=" & [Record ID#]
& "&_fid_112=Approved"
& "&_fid_113=Yes"
& "&_fid_874=Yes";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);”
Where Field 113 is the field that triggers the date field when it is changed to “yes”
------Original Message------
@Adam Keevers solution should give you the desired results. if you are using form rules and button, use the 'API_Editrecord' function in formula url button to update the date field value with current date.
------------------------------
Babi Panjikar
------------------------------- I am getting confused. From your two problem statements I see that your needs are as follows:
- Click "order" button
- Change order status to "Approved"
- Change date ordered to today's date
- Change "copy to Dealers orders" to sent
You should try using the formula rich text solution and it will automatically change the date with no need for the dynamic form rule.
There is one other thing to check for what you have in place now. Look at the bottom of the form rules page and see if toggling the fire changes box to the opposite of whatever it is now fixes your problem:
------------------------------
Adam Keever
------------------------------ - Click "order" button
