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
@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
------------------------------
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
