Forum Discussion

DeanOusterhout's avatar
DeanOusterhout
Qrew Assistant Captain
6 years ago

How to use the API_EditRecord to make date field blank

I need to set a Date/timedate field to blank using the APi_EditRecord and i have not figured it out.  I tried _fid44=0, ='', =' ', =NULL, etc.

What is the secret sauce?  

Thanks,
Dean
APIs and custom code
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Here is an example.  You just end the = and say nothing else.

    urlroot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID]
    & "&_fid_44="


  • DeanOusterhout's avatar
    DeanOusterhout
    Qrew Assistant Captain
    6 years ago
    Well, operator error.  I specified the field incorrectly.  it needs to be _fid_44=NULL  ... this works.