Feed column based on header instead of letter
Tanguy MEREL
When updating a row in Google Sheets, we get to target columns based on a letter, while the module displays the current corresponding header. The first cell's value in a column stands as the header, but I suppose it's only shown for convenience/readability when setting up the module. This header won't get updated until clicking refresh.
Unfortunately, if a column is added later on to that Sheet, then the data will still be sent to the original column... number. In other word, if some data is set to be sent to column C, if later someone adds a column before C (included), then the data will be sent to the newly third column, instead of sticking to the one where it used to go. And so will it be for the following colums. As a consequence, the process gets compromised, and the data go to the wrong columns, until we realize something's wrong.
Best thing would be to monitor columns adds and deletions, but I understand it's probably difficult for the Make process to get informed when a column is added. However, I suppose it's possible to feel data based on the header, rather that column number/letter.
I feel it'd be much more consistant for users to work that way. Or maybe should this be a setting?
I hope my request makes sense. Feel free asking should you need clarification.
Thanks
Log In