Pipeline and Google Sheet: Append a Row Issue
Hi - Looking at the new Google Sheet Pipeline we have been able to successfully use a Quick Base trigger on a record to append a row on a Google Sheet. However, the issue is that when we append a...
Forum Discussion
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
------------------------------
Have 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/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- Unfortunately 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
------------------------------