Discussions

 View Only
  • 1.  How to use the API_EditRecord to make date field blank

    Posted 03-31-2019 15:22
    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


  • 2.  RE: How to use the API_EditRecord to make date field blank

    Posted 03-31-2019 15:25
    Here is an example.  You just end the = and say nothing else.

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




  • 3.  RE: How to use the API_EditRecord to make date field blank

    Posted 03-31-2019 15:30
    Thanks Coach.


  • 4.  RE: How to use the API_EditRecord to make date field blank

    Posted 02-23-2024 11:02

    This approach worked best for my application. Thanks Coach!



    ------------------------------
    Jon Froderberg
    PRIME Developer
    Harder Mechanical Contractors
    https://www.harder.com
    Portland, OR
    801.946.0576
    ------------------------------



  • 5.  RE: How to use the API_EditRecord to make date field blank

    Posted 03-31-2019 15:30
    Well, operator error.  I specified the field incorrectly.  it needs to be _fid_44=NULL  ... this works.


  • 6.  RE: How to use the API_EditRecord to make date field blank

    Posted 03-31-2019 15:31
    I suppose that works as well.