Forum Discussion

Qrew Legend

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

APIs and custom code

BlakeHarrison

Qrew Captain

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

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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    Mike, thx for the testing. I think I will put in a support ticket after all.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------