Forum Discussion

KenDavies's avatar
KenDavies
Qrew Trainee
5 years ago

Re: Pipeline and Google Sheet: Append a Row Issue

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
------------------------------

2 Replies

  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    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/
    ------------------------------
    • KenDavies's avatar
      KenDavies
      Qrew Trainee
      5 years ago
      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
      ------------------------------