Skip to main content
Question

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

  • June 21, 2021
  • 0 replies
  • 106 views

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------

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