I have a button on a report that is quite simple, it ticks the completed box. However, I'm wondering if the formula can be amended so that the completed button can tick OR untick the box (so that, in case you clicked completed but didn't actually complete the task, you can click the button again to untick).
Here is the formula
URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" &
"&rid=" & [Record ID#]&
"&rdr=" & URLEncode(URLRoot() & "db/" & "bjfwhnfx8" & "?a=dr&rid=" & [Related Checklist])
I'm thinking this is just an if formula, but not quite sure.