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
MarkShnier__You
Qrew Legend
Qrew LegendTry this
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
------------------------------
| "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
------------------------------
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__Yousorry I believe this is the syntax
{{ 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
------------------------------
- Thanks everyone!
I started with Mark's initial post and found the correct syntax trough trial and error
------------------------------
Paul Peterson
------------------------------
