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

Question

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
------------------------------

blakeharrison · Answer

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 · Answer

Before posting I tried&amp; "&amp;_fid_357= "; // space&amp; "&amp;_fid_357=null";&amp; "&amp;_fid_357=" &amp; [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 .&nbsp; 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!&nbsp; &nbsp;So it is probably assuming that there are in fact no valid choices as there are none on then field properties itself.&nbsp; &nbsp;Therefore maybe my API is doomed to fail. ......------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

michaeltamoush · Answer

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 · Answer

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() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord&amp;rid=" &amp; [Record ID#]&amp; "&amp;apptoken=xxxxxxxxxxxxxxxxxxxxxx"&amp; "&amp;_fid_226="&amp; "&amp;rdr="&amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl());$URL------------------------------Mike Tamoush------------------------------

markshnier__you · Answer

Mike, thx for the testing.&nbsp; I think I will put in a support ticket after all.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

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