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
------------------------------
Original Message:
Sent: 11-23-2022 12:58
From: Edward Hefter
Subject: Pipelines - Clear a Dropdown Selection
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
Original Message:
Sent: 11-23-2022 01:41
From: Sini Wickramasinghe
Subject: Pipelines - Clear a Dropdown Selection
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
Original Message:
Sent: 11-17-2022 20:34
From: Edward Hefter
Subject: Pipelines - Clear a Dropdown Selection
I know this is an old topic, but I am having trouble with both the {{CLEAR}} and the blank field. I have a lookup text field that is pulling values from another field. This field is a list of parent record candidates to copy children records from. After the pipeline copies the children records to the new parent, the pipeline is supposed to clear the field that had the parent record to copy from. I have tried to update the field with a blank text field and I get the message:
"Skipped because set values are the same as in source object."
This is the YAML line:
- a<>ACTION quickbase record update -> f: inputs: part_name_to_copy_sub_components_from: '{{a.blank_text_field}}'
When I try to blank it out with the {{CLEAR}} option, I don't get the warning, but I also don't get the field cleared. Here's that YAML:
- a<>ACTION quickbase record update -> f: inputs: part_name_to_copy_sub_components_from: '{{CLEAR}}'
I can manually clear the field when I am in the form and it is not set that it must be unique or that it must be filled in.
Any thoughts or suggestions???
------------------------------
Edward Hefter
www.Sutubra.com
Original Message:
Sent: 04-02-2021 13:24
From: Michael Tamoush
Subject: Pipelines - Clear a Dropdown Selection
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
Original Message:
Sent: 04-02-2021 13:23
From: Mike Tamoush
Subject: Pipelines - Clear a Dropdown Selection
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
Original Message:
Sent: 04-01-2021 08:33
From: Mark Shnier (YQC)
Subject: Pipelines - Clear a Dropdown Selection
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
Original Message:
Sent: 04-01-2021 05:46
From: Pete James
Subject: 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
------------------------------