Support » Plugin: CF7 Spreadsheets » Not working with a second form/spreadsheet

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author moshensky

    (@moshensky)

    Hello @stefanando
    Have you clicked “Save” button on third tab of plugin? (“output”)

    It should be clicked to initialize post_meta. It should be clicked one time for each form in selectbox.

    • This reply was modified 2 years, 1 month ago by moshensky.
    Thread Starter stefanando

    (@stefanando)

    Thanks for your answer! Yes, I have done that for each form, also because I need different tags for different forms.
    The Google API and the “Current service account email” are the same for all forms, aren’t them?

    Plugin Author moshensky

    (@moshensky)

    Yep, actually I don’t see necessary to support multiple google service accounts on one website.

    Try to go through this checklist:
    1) Make sure Spreadsheet URL and ID is correct.
    2) Make sure your service account email added to spreadsheet “edit” access group.
    3) Go to console developers dashboard and check if there are any errors (and total amount of requests is correct?)

    Thread Starter stefanando

    (@stefanando)

    I checked you list and everthing seems ok… The email keeps arriving but the submit process doesn’t rach the confirmation message and the data are not written on the sheet.
    could it be something connects to the two CF7 forms, that are very similiar, with the same tags, but in 2 different languages?
    Let me know if there is any capture images I could send you to undestand better, thanks!

    Plugin Author moshensky

    (@moshensky)

    @stefanando
    I’ve just looked to your form and found, that it hasn’t permissions to write to google sheet.
    Please, make sure you granted “edit” access to your spreadsheet by service account email.

    https://imgur.com/a/ipyQSHU

    Thread Starter stefanando

    (@stefanando)

    I have deleted the edit on the form and create it again, but the situation is the same…:
    https://drive.google.com/open?id=1rXREA1WKW1onN-SF-dneoURIn61AVOMx
    https://drive.google.com/open?id=1jEfD1nFqGmeR1p-HgZaYEfgcGw-J1il5
    https://drive.google.com/open?id=1ElMN2rQ1-4GWPlsDaFilklZeddneopS8
    What can it be? On the other similar form it works so fine…
    Thanks for your kind help!

    • This reply was modified 2 years, 1 month ago by stefanando.
    Plugin Author moshensky

    (@moshensky)

    Try to make your spreadsheet public for a minute and send form when it’s public.
    If form arrives correctly – you have issues with permissions.

    W8 for your response.

    Thread Starter stefanando

    (@stefanando)

    I tried but also with a public form the situation is the same…

    Thread Starter stefanando

    (@stefanando)

    I have shared with the current service account email the Google Drive folder containing my sheets and now (I don’t know why, but I accept life mysteries…:-)) it works fine!
    Thank for your kind support, I really appreciated that!

    Thread Starter stefanando

    (@stefanando)

    Just a last question: the time written on the sheet is 2 hours back compared by our Italian time of form submitting. There is any way to fix it?

    Thanks again, I have left a review and will be happy to make a small donation, but I didn’t find a way to do that.

    Plugin Author moshensky

    (@moshensky)

    About time – our plugin it’s just a middleware between CF7 and google sheets. It don’t control data, generated by CF7 (in email should be the same date).

    I looked into CF7 docs, but unfortunately I haven’t found any tips about timezones.
    https://contactform7.com/special-mail-tags/

    BTW: I have bitcoin wallet for donations, I’ll configure donation link as other developers do (in left column of plugin page) in future releases.

    I glad that you found solution!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Not working with a second form/spreadsheet’ is closed to new replies.