Question about connecting a sheet

  • Resolved gettingitdone

    (@gettingitdone)


    5 years, 1 month ago

    Hello,

    I have a form I’ve connected with a Google Sheet. However, I have a question about the connection between the two.

    Some of the fields have special ids for them. For example, “Your Company’s name” is called “your-name id: company name” internally and “Your role in the company” is “your-name id: company role”. How should I add these to the Sheet?

    Right now, I’ve put the internal field name and it’s id together in one cell, such as “your-name id: company role” being in a single cell. Is this the correct way to handle this issue?

    J

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter gettingitdone

    (@gettingitdone)

    5 years, 1 month ago

    Hello again,

    I’ve changed the internal field names so that they better match the data they’re gathering. However, submissions in the form are increasingly on the right side of the sheet for some reason to the point where it runs out of cells in a row to put information in. Why is this?

    Plugin Author WesternDeal

    (@westerndeal)

    5 years, 1 month ago

    Hi @gettingitdone,

    Thank you for using our plugin.

    It seems you are having 2 input field with same name i.e your-name and different id. Which would not possible to be identified by the id and placed to the Google Sheet. We recommend to have different field names like company-name, company-role.

    And also it seems you would have copied the names and placed to the Google Sheet headers with some space around and that have added a formatting. So create a fresh sheet and place the header names by making sure it don’t have space around.

    Hope this helps. Let us know.

    Thanks
    Abdullah

    Thread Starter gettingitdone

    (@gettingitdone)

    5 years ago

    What do you mean by “space around”?

    Plugin Author WesternDeal

    (@westerndeal)

    5 years ago

    @gettingitdone

    Is everything working for you? Let us know.

    Also space around means <space> before and after any string
    i.e <space> Your-Name <space>

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

The topic ‘Question about connecting a sheet’ is closed to new replies.