What is Append?

Follow

Comments

6 comments

  • Avatar
    André Lyra

    Using Append feature in "Export mode", the field "Connection Name" stands for the destiny sheet tab name but that is not what happens when one chooses the second tab and so on. It only reads data from the first tab of the source sheet. 

    Is that a bug or am I misunderstanding?

    Thanks in advance,

    Andre.

  • Avatar
    Robert Orzanna (Sheetgo)

    Dear Andre,

    This is what should happen on export append:

    The name of the connection becomes the name of the new sheet tab inside the destination spreadsheet.

    Yours,

    Robert

  • Avatar
    André Lyra

    Robert, first of all, thank you for very fast reply.

    I guess I was not too clear about my issue.

    I think it´s about "Source Sheet" field instead. I´d like to be able to export data from the 2nd tab of a sheet of mine to another 1st tab sheet. Every time Import Sheet runs, it reads from the 1st tab of the source sheet, not from the second. It´s ignoring the field "Source Sheet' holding the 2nd tab of the entire source sheet file.

    Thanks in advance again!

  • Avatar
    Robert Orzanna (Sheetgo)

    Andre,

    Can you please confirm that this is what you want?

    https://youtu.be/Rak6ZbgNULw 

    Yours,

    Robert

  • Avatar
    André Lyra

    Yep, Robert!

    That is exactly what I want. The only difference is that in my case I am exporting to an already existent tab of destination sheet. I don't know why, but I've just tested the procedure and it's working now. Have you updated something in the system about this?

    Again, I am very thankfull for your time, pacience and support!

    Now I am facing another issue to my export needs. The registries in the destination sheet are modified between two exports, so the second export execution considers nothing about de first and takes all the registries again from de source sheet. Can Import Sheet use some column in the source tab sheet to flag what lines was already syncked in order to not sync them again?

    Andre.

  • Avatar
    Robert Orzanna (Sheetgo)

    Andre, 

    Basically, you are requesting a feature to append only the data that has changed?

    Yours,

    Robert

    :-)

Please sign in to leave a comment.