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

9 Replies

JINJA TIPS

Related Content

Multi-Select Fields with Commas in Pipelines

Three Words of Advice on Pipelines

Using multi select field in pipelines

Filter dropdown selection

Three Words of Advice on Building Pipelines - Brittany Scheid