Forum Discussion
MCFNeil
8 years agoQrew Captain
You will need to set a "dynamic form rule" to populate that date, when your status field is changed.
If you are an Admin on the account and you open up one of the records
>
In the top right you will see "Customize This Form"
>
After opening up those settings, click on the "Dynamic Form Rules" tab
>
Create a new rule with the needed logic
>
Something to the affect of:
Condition
If [Status] is equal to "Complete"
Action:
Change [Completion Date] to the value in the field [Scheduled Date]
If you are an Admin on the account and you open up one of the records
>
In the top right you will see "Customize This Form"
>
After opening up those settings, click on the "Dynamic Form Rules" tab
>
Create a new rule with the needed logic
>
Something to the affect of:
Condition
If [Status] is equal to "Complete"
Action:
Change [Completion Date] to the value in the field [Scheduled Date]
- AndreonnaGarret8 years agoQrew Assistant CaptainI thought for sure this was going to work, however it just enters in todays date instead of the date from the field.
After conducting further research this may be because of how it is set up. I have on another table a URL button that when pressed, changes the [Status] field to complete. For some reason when this is pressed it enters todays date in the [Completion Date] field. If I manually on the record change the [Status] field to complete it works properly.
Any thoughts on how to fix this so the URL button will work? - ChrisChris8 years agoQrew Assistant CaptainCan you past the button code in here? It may be coded to populate the date field.
- AndreonnaGarret8 years agoQrew Assistant Captainvar text url =
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&apptoken=biyf682cpfpeqfbfpv8pida6k3gy" &
"&_fid_15=Complete" &
//"&_fid_57=true" &
"&_fid_17=" &Now();
If([Status]="Complete","",
"<a class=\"Vibrant Primary\" href=\"javascript:" & "$.get('" & $url &
"', function(){" & "location.reload();" & "});" &
"void(0);\">Complete</a>"
) - AndreonnaGarret8 years agoQrew Assistant CaptainField ID #15 = [Status]
Field ID #57 = Looks like a note, because I only have 30 fields
Field ID #17 = [Completion Date] - MCFNeil8 years agoQrew Captainthe portion that has "&_fid_17="&Now();
is already writing the date.
Any reason why you don't want to keep using the button to mark things complete.
I much prefer buttons over form rules. - ChrisChris8 years agoQrew Assistant Captain&_fid_17=" & URLEncode([Scheduled Date]);
- AndreonnaGarret8 years agoQrew Assistant CaptainMatthew,
I definitely want to continue using the button. I will try Chris' update to the button code to get it to populate the correct date. - ChrisChris8 years agoQrew Assistant Captain
It has occurred to me after reading over this thread that you may be trying to write a date field value to a date/time field value.
Now() is a function that gives you the current date 'and' time of day. Are both [Completion Date] and [Scheduled Date] Date/Time fields? Or, is one of them just a Date field?
- AndreonnaGarret8 years agoQrew Assistant CaptainSUCCESS!!! Thank you guys so much!!