Submission ID to Google Sheet

  • Resolved John

    (@dsl225)


    4 years, 1 month ago

    This is a follow-up from this thread that has been closed.

    Hello Kasia @wpmudev-support2,

    I found your solution very interesting at this post and want also to implemented it. Would have a couple of additional questions if you don’t mind:

    You mention:
    “To make it happen, add a “Hidden” field to the form with a custom label “Submission ID”.”

    – What should I use as “Default Value” for this field?
    – Will this number be the same as the {submission_id} we use in email messages or different?
    – Can I use the same solution as the one you provided here for having a custom initial incremental number?

    I already added this snippet in functions but I get an empty value for this field in this form’s submissions. Didn’t try Google Sheets yet though.

    Many thanks!

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

  • Hi @dsl225,

    Thank you for contacting us.

    Try using “Custom value” for default and make sure you have the same hidden field ID (ex: {hidden-1}) that is shown on your field added to the snippet. The solution for custom initial incremental number is different setup than this one. Make sure to test the form submission with Google Sheet integration and let us know how it goes.

    Best,
    Jonathan S

    Thread Starter John

    (@dsl225)

    Thanks for this, but to be sure: do you mean that I need to set “Custom Value” and then leave the “Default Value” empty?

    Currently, I’m using the correct hidden field ID in the snippet but I still get an empty value for this field in Submissions.

    Thread Starter John

    (@dsl225)

    UPDATE: In fact, I managed to get this value in Submissions.
    It is are labeled “Order”.
    – Is there a way to change this label somewhere?

    And in email notifications I using {submission_id} to get the same value and works fine.

    Thread Starter John

    (@dsl225)

    UPDATE2: the label “order” comes from this snippet that I’m also using and I was able to edit it. Solved, with thanks.

    @dsl225

    How did you manage to get the Submission ID in the Hidden Field?
    I still get an empty value. I have the correct field ID (ex: {hidden-1}).

    Should the Default Value be empty?

    Thank you!

    Thread Starter John

    (@dsl225)

    @nvoyed

    I was NOT getting it at the destination URL which holds the confirmation data but only within the confirmation emails. I didn’t yet test with Google Sheets though because I’m still working from a temporary website URL.

    But, in the meanwhile, Adam @wpmudev-support8 provided a nice working solution precisely for this here to which I just added some remarks below.

    Also, I documented my findings and related issues here.

    @dsl225

    Okay. I was just wondering, becuase I tried everything else to get it work. I also using this script and want to export the created ID to export via Zapiar to my E-Mail Marketing Tool Cleverreach.

    Unfortunately i saw that this script only works with Google Sheets. I will create another ticket for that.

    Best regards

    CleverReach?

    (@cleverreach43)

    Hello,

    thanks for using Cleverreach.
    When you have a question regarding the installation of the plugin, please send a direct message to [email protected]

    Regards
    Dennis Schr?der

    Thread Starter John

    (@dsl225)

    I finally tested with a working Google Sheets integration and, as @nvoyed stated above, this code doesn’t seem to work. I also get empty values.

    I tested both with using {submission_id} and {entry_id} as default values but only getting those as plain text output.

    The field column labeled “Submission ID|hidden-1” is though correctly created at Google Sheets.

    Is there a way to set this up correctly?

    Thanks.

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @dsl225

    I tested the code and it worked, but it seems when pasting to www.ads-software.com forum it replaced some tags and appended the code word.

    Could you please try to fix that part?

    https://monosnap.com/file/ytAYBOEW14cneWgLT4OKoNtkt381e1

    https://gist.github.com/patrickfreitasdev/96e3bdf3bbbc25ca6f142855c866859f

    Make sure the hidden field is the hidden-1 and update if necessary.

    Let us know if you need any further help on this.
    Best Regards
    Patrick Freitas

    Thread Starter John

    (@dsl225)

    Hi Patrick and thanks.

    Will check both codes here and here and will get back to you.

    Many thanks!

    Thread Starter John

    (@dsl225)

    Hi again Patrick @wpmudevsupport12,

    I confirm that the latest code you provided above for Google Sheets works fine!
    You are right, the previous code was wrong but this one does the job.

    Many thanks for your kind help and assistance.

    Cheers.

    Thread Starter John

    (@dsl225)

    PS: I also checked the CSV output of submissions and there is no ID included in there. Is this normal?

    I get a new column there labeled “Google Sheet Info” with always the same data “[test form] Successfully send data to Google Sheets” but not the actual ID. This is not a big issue but as those CSV files are, in this case, being used as backup and the main usage will be with Google Sheets it would be helpful to have the submission ID somewhere there also – if possible.

    Thanks again!

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @dsl225 ,

    About the submission ID in the CSV export, at the moment it’s not there, but we have this on the list of future improvments for Forminator. I have added your request to the task so it will get higher priority.

    kind regards,
    Kasia

    Thread Starter John

    (@dsl225)

    Great, many thanks Kasia @wpmudev-support2 !

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Submission ID to Google Sheet’ is closed to new replies.