Pipelines - Clear a Dropdown Selection

Question

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 dropdown to a null. What do I need to set the field value to be in order to effectly cancel any previous dropdown selections?

thanks

------------------------------
Pete James
------------------------------

michaeltamoush · Answer

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
------------------------------

michaeltamoush · Answer

Found it! Yes it's {{Clear}}The tip is all the way at the bottom of this linkhttps://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__you · Answer

One 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
------------------------------

markshnier__you · Answer

Thx for posting!------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

petejames · Answer

thanks for these anssers. much appreciated------------------------------Pete James------------------------------

Forum Discussion

Pipelines - Clear a Dropdown Selection

JINJA TIPS

Related Content

Three Words of Advice on Pipelines

Filter dropdown selection

Using multi select field in pipelines

Pipeline Not Triggering

Three Words of Advice on Building Pipelines - Brittany Scheid