change table header

  • Resolved pugsugus

    (@pugsugus)


    8 years, 1 month ago

    Hi, Anyone could help.

    I have tried to retrieve data from google sheet publish to website automatically. I used periodic auto publish plugin. The problems are:

    1. When I retrived data from publish to web (google sheet function) the header is gone. I tried manually edit, but when it is auto update. The plugin retrived data with empty header again (example in the first table in the link.)
    2. So I tried another one using google sheet link (instead of publish to web) to import data from table. They came with headers, but the header of google sheet column like A, B, C, etc.

    Try many ways but it won’t work. Any recommendation for a newbie?

    Pugsugus

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 1 month ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The “Publish to Web” function should be the best source.
    Does maybe adding a header row manually (as the first row of the table in Google Spreadsheets) help?

    Regards,
    Tobias

    Thread Starter pugsugus

    (@pugsugus)

    8 years, 1 month ago

    I did try, but when the automatic updated is working, All data were replaced with new one as well as header which appeared blank as shown in Table 1.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 1 month ago

    Hi,

    what I mean:
    Add a new first row to your table that has the table header content. Your table currently starts with the table content in row 1, and it doesn’t actually have a table header.

    Regards,
    Tobias

    Thread Starter pugsugus

    (@pugsugus)

    8 years, 1 month ago

    Will Try and See how it works.

    Thank you

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 1 month ago

    Hi,

    sounds good! Let me know how it goes!

    Best wishes,
    Tobias

    Thread Starter pugsugus

    (@pugsugus)

    8 years, 1 month ago

    It work now by hiding 1st row and name header in google sheet and function header still work since it used 2nd row as header. Thank you very much for ur support.
    Eventhough, the first row was counted as no 1 which is I don’t want. Anyway it is good enough.

    Thank you for your support TobiasBG

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 years, 1 month ago

    Hi,

    great! Good to hear that you found a workaround!

    Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘change table header’ is closed to new replies.