Forum Discussion

FranciscoOjeda's avatar
FranciscoOjeda
Qrew Trainee
7 months ago

Completed task button

Hi, 

I am trying to do a button to mark as completed a task.

When I try this, the Status is changed to "Completed" but as text and not as the multiple choice option "Completed" of the field. This is a problem because if I colour the records that are completed, these ones are not coloured.

How can I solve this?

This is my formula:

If([Task Status]<>"Completed",URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_11= Completed" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()))

Thanks!



------------------------------
Francisco Ojeda
------------------------------

2 Replies

Sort By
  • MarceloBenavide's avatar
    MarceloBenavide
    Qrew Cadet
    7 months ago

    Hello Francisco. I think it is not a quckbase situation. It is a string situation.... try remove blank space after = symbol.

    &_fid_11= Completed

    Thank you

    Marcelo Benavides Torres



    ------------------------------
    Marcelo Benavides
    ------------------------------
    • FranciscoOjeda's avatar
      FranciscoOjeda
      Qrew Trainee
      7 months ago

      Thanks! 

      it was that, I could fix it. 



      ------------------------------
      Francisco Ojeda
      ------------------------------