Forum Discussion
ShawnRenn2
6 years agoQrew Trainee
how do users mark the task as complete. Is this a dropdown/checkbox? or are you using a magic button to do this?
If the user is directly editing a field to mark this as complete, your only option is a form rule.
I'd recommend making a "Complete Task" magic button that changes whatever field/value you're using now, and you can limit that button to only display for the assignee.
We'll say for this example your users have a checkbox called "Complete".....
om the example below, xx is the field id for the tasks tables record ID, and zz is the field ID for your "Complete" checkbox. For convenience, this example has a js string to allow this button to reload the page the button was pressed on so it can be placed in reports, dashboards etc.
var text URL=URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_EdotRecord&AppToken=yourapptokengoeshere&_fid_xx=" & URLEncode ([Record ID#])& "&_fid_zz=1" & "&z=" & Rurl();
var text jsAction="javascript:"&"$.get('" &$URL& "',function(){" &"location.reload(true);" &"});" & "void(0);";
If(User()=[Assignee], $jsaction , "")
Hope this helps!
If the user is directly editing a field to mark this as complete, your only option is a form rule.
I'd recommend making a "Complete Task" magic button that changes whatever field/value you're using now, and you can limit that button to only display for the assignee.
We'll say for this example your users have a checkbox called "Complete".....
om the example below, xx is the field id for the tasks tables record ID, and zz is the field ID for your "Complete" checkbox. For convenience, this example has a js string to allow this button to reload the page the button was pressed on so it can be placed in reports, dashboards etc.
var text URL=URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_EdotRecord&AppToken=yourapptokengoeshere&_fid_xx=" & URLEncode ([Record ID#])& "&_fid_zz=1" & "&z=" & Rurl();
var text jsAction="javascript:"&"$.get('" &$URL& "',function(){" &"location.reload(true);" &"});" & "void(0);";
If(User()=[Assignee], $jsaction , "")
Hope this helps!
Shawn M. Renn, Jr.
Certified Quick Base Platform Developer / Sales Engineer
440-201-6050 Ext. 307
MCFTech Solutions | Business Wise, Technology Savvy