Forum Discussion
BlakeHarrison
Qrew Captain
When you take a look at the output of Step B, is it including the fields for N and O ? According to their documentation, Pipelines is supposed to require {{CLEAR}} to clear a field, but I'm wondering if maybe they are still passing the fields with a null value and maybe Google is accepting that null value as a request to clear the formulas?
Since you are not passing values for those fields, I would suggest removing those from the step altogether and see if that fixes the issue.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Since you are not passing values for those fields, I would suggest removing those from the step altogether and see if that fixes the issue.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
KenDavies
4 years agoQrew Trainee
Since nothing in mapped in the Pipeline for N and O there isn't anything to be shown in the Google Sheet. However, the formula and data validation requirement are cleared out after the other fields get populated.
I was under the impression that the {{CLEAR}} was also needed to clear a field which is why I was confused by what was happening.
In Step A I can select the fields from Quick Base that will be used in Step B, but I don't see a way in Step B to not bring in the columns from the Google Sheet that I don't want to be touched.
Thank you for the comment.
------------------------------
Ken D
------------------------------
I was under the impression that the {{CLEAR}} was also needed to clear a field which is why I was confused by what was happening.
In Step A I can select the fields from Quick Base that will be used in Step B, but I don't see a way in Step B to not bring in the columns from the Google Sheet that I don't want to be touched.
Thank you for the comment.
------------------------------
Ken D
------------------------------
- BlakeHarrison4 years agoQrew CaptainHave you tried removing those fields from Step A? I realize that it appears nothing is being sent for those fields in Step B, but I tend to try to eliminate as many options as possible when troubleshooting.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- KenDavies4 years agoQrew TraineeUnfortunately in Step A the only thing I do is pick which Quick Base fields that I will want to bring into Step B. I don't see an option then in Step B to remove / exclude those columns (fields) in the Google Sheet I don't want the Pipeline to touch. It seemed like the only option was to leave those columns blank and not map over a field from Quick Base.
------------------------------
Ken D
------------------------------