KenDavies
5 years agoQrew Trainee
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:
------------------------------
Ken Ken
------------------------------
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.
------------------------------
Ken Ken
------------------------------