Create new columns on the destination: blank or new info from identifier data

HenriqueVieira · 2022-11-30T20:48:01+01:00

If a new column is added in the source, this new column is also added in the target files when the workflow is executed. Therefore, new columns can be added...

Willian from Sheetgo

HenriqueVieira Thanks for the idea! However, I’m not sure If I could get the whole perspective of it. Could please provide an example of how this could be useful for you? I’m really looking forward to understanding it so we can start leveraging it 😉

Karoline from Sheetgo What would be these new columns in the destination file?

Karoline from Sheetgo

Willian from Sheetgo Taking as an example one of Henrique’s connections:

They have a spreadsheet that is split by manager’s name

In each destination file, they need to add at least two blank columns.

What I thought was that we already have the option to identify the source by adding a column, wouldn’t it be nice if we had the option to include blank columns and still choose how many?

Willian from Sheetgo

Karoline from Sheetgo Got it! Thanks for the explanation.

In this case, we should change the scope here to a more broad feature request, like adding columns to the destination file, similar to what you’ve explained with the option to identify the source. So we provide a “builder” that users can “add” as many columns as they want, and select what is the nature of it, from the options we currently support (source file name, current date, etc) and some new useful options like a simple empty column!

What do you think about it?

Karoline from Sheetgo

Willian from Sheetgo That will be a great addition to our product! Great idea!

Btw, we have a new request about the identifier of the source. I’ll merge with this topic

PatricioSanchez

It would be great to have the opportunity to add custom data or a specific name to the rows in the new column.

For example: the name of an employee. Which is not related to the source file or destination name.

Karoline from Sheetgo

PatricioSanchez Hi Patricio, I’m really happy about your contribution!
I merged your post into this discussion. Our tech team @Willian from Sheetgo is studying new possibilities ;)

Willian from Sheetgo

PatricioSanchez We appreciate your request!

Would you like to be able to customize the name of the column that will be created?

Furthermore, kindly let us know if our current options meet your requirements, or, would you prefer to create a new option for the actual data for each row?

PatricioSanchez

Willian from Sheetgo hello!

I’m recommending to add a custom name for the column and each row of it. It can be the same.

PatricioSanchez

Willian from Sheetgo now I could read the whole conversation.

Now we can add a new column to identify the data with the source’s name, file name, date, tab name, and destination file name. But what if I want to name the new column (and the rows) with a different name, which is not included in the previous list? If the file was created by “John”, we can name the new column “John” and each row below will say “John”. There is no need to name the column different from the rows below. (it would be great to have the opportunity to name them differently, but it´s not 100% needed).

Another opportunity is to add a column with a custom formula. Like =A+B

I have been working with Sheetgo for 3 years already and I love it!

Willian from Sheetgo

PatricioSanchez Got it, thanks for elaborating!

So in this case, you want to identify the source with data that doesn’t exist either in the source or in the destination. Indeed you would need a sort of custom formula or at least the ability to create custom “data” on the fly in a way to enrich and complement the existing dataset.

I will continue keeping the track of this request and maturing it, until from our side we feel comfortable providing a useful feature but not least importantly, that our users can understand and extract value from it.

For now, would you like to support your request even more, and upvote this thread? In this way, we can leverage its visibility and more users can let us know that this makes sense and/or is needed. This also helps us measure priorities for our users.

Once more, thanks for sharing your ideas and for being with us for such a long time, it is very nice to know a bit more about who are your customers! I’m glad we could provide you with solutions for this long and that you love us.