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

MarkShnier__You
Qrew Legend
4 years ago
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
  Qrew Captain
  4 years ago
  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
  ------------------------------
  - MichaelTamoush
    Qrew Captain
    4 years ago
    Mark,
    
    Something else must be going on. You may want to contact customer support. I just tried making a multi-select coming from a shared field, and it worked as expected. My code is below. I also tried specifically setting the multi-select field, and that also worked.
    
    Any chance it is something simple, like field 357 is not actually the field number you want?
    
    var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]&
    "&apptoken=xxxxxxxxxxxxxxxxxxxxxx"
    & "&_fid_226="
    & "&rdr="
    & URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl());
    
    $URL
    
    ------------------------------
    Mike Tamoush
    ------------------------------

Forum Discussion

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