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 row any columns that have some type of pre-existing information in it is wiped out. This includes data validation requirements or/and formulas even when we do not specifically map over Quick Base fields to those columns.

Example:

• Our Google Sheet action maps out fields to populate data from Quick Base into columns A - L.
• In Columns M - O we do not map any fields over from Quick Base and leave it blank.
  • On the Google Sheet Column M is a Data Validation field showing a list of options our client completes (dropdown list showing Yes, No, NA)
  • On the Google Sheet Column N is blank (for our client to provide their response)
  • On the Google Sheet Column O is a formula field (an If statement based on information in Column A vs. what client places in Column N).
• After the Pipeline runs the dropdown and formula in Column M and O are now cleared.

Looking at the Quick Base Pipelines Help page, About Jinja, I read it to indicate that if the field is empty it will not over-ride data. However I'm experiencing something different and was hoping there may have been something I missed to prevent clearing out fields in Column M and O.

------------------------------
Ken Ken
------------------------------