Pipeline - clear date field?
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 conditi...
Forum Discussion
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.
Also tried "" and same error. I'll update when I find the solution.
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendsorry I believe this is the syntax
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
{{ CLEAR }}
with CLEAR in upper case.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- MarkShnier__Youhttps://help.quickbase.com/pipelines/transforming_data.html?Highlight=CLEAR#Clear_a_field_in_an_Update_pipe
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- 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
------------------------------- 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
------------------------------
what do you suggest to put in the pipeline to keep the first date entered but delete any subsequent date?
------------------------------
Lorrie
------------------------------- MarkShnier__You
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
------------------------------
- Thanks everyone!
I started with Mark's initial post and found the correct syntax trough trial and error
------------------------------
Paul Peterson
------------------------------
