Skip to main content
Question

How to use the API_EditRecord to make date field blank

  • Mar 31, 2019 7:22 PM UTC
  • 0 replies
  • 96 views
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
    This topic has been closed for replies.

    Here is an example.  You just end the = and say nothing else.

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


    • DeanOusterhout
    • Author
    • Qrew Corporal
    • Mar 31, 2019 7:30 PM UTC
    Well, operator error.  I specified the field incorrectly.  it needs to be _fid_44=NULL  ... this works.
    Terms & ConditionsAccessibility statement