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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOne 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- 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
------------------------------- 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
------------------------------- MarkShnier__YouThx for posting!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - 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.
--------------------------------------
Original message:
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
------------------------------
- thanks for these anssers. much appreciated
------------------------------
Pete James
------------------------------
