Discussions

 View Only
Expand all | Collapse all

Pipeline - clear date field?

  • 1.  Pipeline - clear date field?

    Posted 09-22-2021 16:14
    Is there a way to clear the value of a date field in a pipeline?  I have am replacing my automations with pipelines and I have a couple automations that will clear a date field given a certain condition.  I tried using a null field I have in the table and leaving the value empty in the pipeline step.  Neither of those worked.

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Pipeline - clear date field?

    Posted 09-22-2021 17:10
    Try this

    "CLEAR"


    just like that in Quotes. I never tried it myself but my cheat notes said that's the way to do it. Please post back and confirm that it worked for you.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Pipeline - clear date field?

    Posted 09-23-2021 10:36

    Validation error: Invalid date/time value: "CLEAR"

    Input (Mapping)
    start_date:""CLEAR""

    Also tried "" and same error. I'll update when I find the solution.


    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------



  • 4.  RE: Pipeline - clear date field?

    Posted 09-23-2021 11:08
    sorry I believe this is the syntax

    {{ CLEAR }}

    with CLEAR in upper case.



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Pipeline - clear date field?

    Posted 09-23-2021 11:10
    https://help.quickbase.com/pipelines/transforming_data.html?Highlight=CLEAR#Clear_a_field_in_an_Update_pipe

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 6.  RE: Pipeline - clear date field?

    Posted 09-23-2021 11:23
    That is correct and functional. 
    I also pinged QB Support.

    Use {{CLEAR}} to empty the contents of a date type field in a pipeline recipe step.

    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------



  • 7.  RE: Pipeline - clear date field?

    Posted 11-22-2021 17:04
    Hi Jim, 
    What about clearing a value in a multiple choice field via update pipeline? I'm able to clear dates just fine. Thoughts? 

    Todd

    ------------------------------
    Todd Molino
    ------------------------------



  • 8.  RE: Pipeline - clear date field?

    Posted 11-22-2021 17:20
    @Todd Molino

    No idea.

    Please make a new post, this post is specific to one use case. Prolly a good idea to spearate out the solution for better search.


    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------



  • 9.  RE: Pipeline - clear date field?

    Posted 05-05-2023 14:11

    what do you suggest to put in the pipeline to keep the first date entered but delete any subsequent date?



    ------------------------------
    Lorrie
    ------------------------------



  • 10.  RE: Pipeline - clear date field?

    Posted 05-05-2023 15:54

    Lorrie, can you make a new question instead of adding to this thread. Please describe your use case more fully as I don't understand it.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 11.  RE: Pipeline - clear date field?

    Posted 09-23-2021 13:01
    Thanks everyone!

    I started with Mark's initial post and found the correct syntax trough trial and error

    ------------------------------
    Paul Peterson
    ------------------------------