When using the "Write to Other Table", do I need to manually recreate all the columns in the new sheet or can I just duplicate the column's names from the first sheet?
Also, 2nd question, if I forget a column and I need to re-push all the rows, will the existing rows get updated with the missing data, or is it repushing the entire rows again so I will have duplicates in my new sheet?
Hey Alex! Yep, it's probably easier to duplicate an existing table and edit it so you can quickly map it out. It's something we have to look into to see if new columns could be created this way when mapping it out though. (will check with the team)
For the second question, yeah, unfortunately, it doesn't detect the existing record to update, so it will create a new one at the bottom. You can use a Lookup Record integration instead to pull other missing fields if that helps though
Amazing thanks a lot Arturo O., let me know if it would be doable to automatically create the columns in the second sheet without having to do the matching