Pipelines - Clear a Dropdown Selection
When adding an order item the user can select a profile from a dropdown. I have a scenario where I need to clear this selection for all items in the order. Using pipelines it won't allow me to set the...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOne way is to have a formula field of the same type with no formula. For example [Null date]. It will calculate to null. The copy that field into your real field to be cleared.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- I believe it is {{CLEAR}}. I once found this in the actual literature, if no one can confirm I'll try to see if I can find it again.
------------------------------
Mike Tamoush
------------------------------- Found it! Yes it's {{Clear}}
The tip is all the way at the bottom of this link
https://help.quickbase.com/pipelines/about_jinja.html
JINJA TIPS
- Pipelines ignores fields with empty values in pipe's mapping, i.e. it does not send them to the remote service, to avoid clearing a remote field accidentally. This, however, is a problem when you want to explicitly clear this field in an Update pipe. Solution: use template value {{CLEAR}} to clear a fieldthis is not bold in the rendered value
------------------------------
Mike Tamoush
------------------------------- MarkShnier__YouThx for posting!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- thanks for these anssers. much appreciated
------------------------------
Pete James
------------------------------
