Forum Discussion
- ShawnRenn2Qrew Traineehow 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!Shawn M. Renn, Jr.
Certified Quick Base Platform Developer / Sales Engineer
440-201-6050 Ext. 307
MCFTech Solutions | Business Wise, Technology Savvy - RyanStanford1Qrew CaptainThe dynamic form rule would be pretty straight forward... add a criteria where if [user] is in the [Assigned User] make editable the complete checkbox.
I will say that either one of these methods will work. - NathanAllan4Qrew CadetThank you both of you. It worked out when I created a custom rule for a role to modify certain records only when the assigned to Dropdown field was equal to the user.
Ryan, unfortuantely I couldn't figure out your solution. When I go to create a dynamic form rule. I can select when user, but the only option at that point is to select "is in the role" or "is not in the role". It's not possible to relate the user to the value in "Assigned To" Field. Also true the opposite way when Assigned to "is equal to" the next field doesn't give me an option of user. This would have been my preferred solution, but since it didn't work out. The other way works too.
Thanks for your help!- RyanStanford1Qrew CaptainHey Nathan... I tested the exact way to do this, as I know we've done it with Dynamic form rules...
The way to do this is as follows:
Condition:
[Assigned User] includes [The current user]
Action:
[Make editable] [Checkbox]