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