Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
9 years ago

Auto Fill Date Field Based Off of Another Field

Hello,  I would have three fields that I would like to work together, [Status], [Scheduled Date] and [Completion Date]. Essentially I want the [Completion Date] field to auto fill with the same dat...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
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]
AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
9 years ago
var 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>"
)