Forum Discussion

PeteJames's avatar
PeteJames
Qrew Cadet
4 years ago

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

9 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
    ------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      4 years ago
      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's avatar
        MichaelTamoush
        Qrew Captain
        4 years ago
        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
        ------------------------------
    • PeteJames's avatar
      PeteJames
      Qrew Cadet
      4 years ago
      thanks for these anssers. much appreciated

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