Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

How to Clear the contend of a Muti Select field type with a URL Formula

I have a formula URL button and I'm trying to clear a Multi select field.

I always just use this type of syntax to clear either numeric, text, date, user et=c  fields.  But when I try to clear the field I get the API error message that I must supply a valid choice for field ID 357.

Is there some trick to clearing a multi select field type with a formula URL button?  Here is a portion of my button formula.

var text ClearSelectedPendings = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_357=";

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

7 Replies

  • Have you tried using 'null'? Or possibly a space after the =?

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      Before posting I tried

      & "&_fid_357= "; // space

      & "&_fid_357=null";

      & "&_fid_357=" & [Multi Select field with a blank formula];

      I also even tried putting a value in the field that WAS on the list of choices and that failed too . 

      In typing this, I just realized now that the list of choices is coming from a shared field. Maybe the system is looking just at that field on a stand alone basis and does not see the choices as they are from another table!   So it is probably assuming that there are in fact no valid choices as there are none on then field properties itself.   Therefore maybe my API is doomed to fail. ......

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • MichaelTamoush's avatar
        MichaelTamoush
        Qrew Captain
        I can confirm that your exact code does work for me, and it seems the only difference may be that shared field. Can you duplicate the multi-select field but not have it come from a shared field, to confirm? I would be curious to know.

        It would explain why you can't make a selection, but I am surprised you can't clear it either?!

        ------------------------------
        Mike Tamoush
        ------------------------------