Discussions

 View Only
Expand all | Collapse all

Pipelines - Clear a Dropdown Selection

  • 1.  Pipelines - Clear a Dropdown Selection

    Posted 04-01-2021 05:47
    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
    ------------------------------


  • 2.  RE: Pipelines - Clear a Dropdown Selection

    Posted 04-01-2021 08:34
    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
    ------------------------------



  • 3.  RE: Pipelines - Clear a Dropdown Selection

    Posted 04-02-2021 13:23
    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
    ------------------------------



  • 4.  RE: Pipelines - Clear a Dropdown Selection

    Posted 04-02-2021 13:25
    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
    ------------------------------



  • 5.  RE: Pipelines - Clear a Dropdown Selection

    Posted 04-02-2021 13:26
    Thx for posting!

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 6.  RE: Pipelines - Clear a Dropdown Selection

    Posted 11-17-2022 20:35
    Edited by Edward Hefter 11-23-2022 15:44
    RESOLVED: The {{CLEAR}} works just fine, but I was trying to clear a formula field rather than the actual text field. Quickbase tech support helped me troubleshoot it.




  • 7.  RE: Pipelines - Clear a Dropdown Selection

    Posted 11-23-2022 01:42
    Edited by Sini Wickramasinghe 11-23-2022 02:23
    Same here.... spent hours trying different things. Still cant find a solution....


    *****EDITED*****Just fixed the issue. Confirming that {{CLEAR}} did work for clearing values from dropdown lists. My issue was an error in the IF ELSE statements.

    ------------------------------
    Sini Wickramasinghe
    ------------------------------



  • 8.  RE: Pipelines - Clear a Dropdown Selection

    Posted 11-23-2022 12:58
    Were your multiple choice options coming from a list or from a different field? I've had it work when clearing from a list of options, but I can't get it to clear when the options are from a different field.

    ------------------------------
    Edward Hefter
    www.Sutubra.com
    ------------------------------



  • 9.  RE: Pipelines - Clear a Dropdown Selection

    Posted 11-23-2022 17:22
    Hi Edwards,

    The multiple choice options are coming from a different field linked to the field (from a different app) I was trying to clear the values in. Here's a snapshot of the field properties:


    What I found out was that I hadn't considered all possible conditions in my if-else statements. Once that was fixed it worked.

    ------------------------------
    Sini Wickramasinghe
    ------------------------------



  • 10.  RE: Pipelines - Clear a Dropdown Selection

    Posted 04-09-2021 02:08
    thanks for these anssers. much appreciated

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