Forum Discussion
EdwardHefter
Qrew Cadet
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:
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:
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:
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
------------------------------
SiniWickramasin
2 years agoQrew Cadet
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
------------------------------
*****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
------------------------------