Is it possible to sync existing submissions to Googl Spreadsheet?

  • Profile Image
    TroyBrewer
    Asked on January 30, 2018 at 11:49 AM

    Hi... I love the Google spreadsheet integration but I was wondering if it were possible to add *existing* entires to a spreadsheet as well. In other words, I know that if I add the Google spreadsheet integration now it will start to record NEW entires, but I currently already have hundreds of entries that I would like added to the spreadsheet as well... is that possible without having to manually add these?


    Thank you1


    T

  • Profile Image
    Mike_G
    Answered on January 30, 2018 at 12:49 PM

    If you integrate your form with Google Spreadsheet, existing submissions that the form had already acquired before the integration will also appear in the spreadsheet. The submissions will sync when the integration completes.

    I suggest that you try this on your form. And, if you encounter any issues, please feel free to contact us again anytime.

  • Profile Image
    TroyBrewer
    Answered on January 30, 2018 at 03:54 PM

    Okay, awesome!  You're right.. It pulled them right in.... So the next hurtle is this --- it looks like it's grabbing a lot more than just the price in the *amount* column, example:


    (Amount: 53.00 USD) Total: 53.00

    Is there a way to strip out everything except the actual dollar amount?   Better yet, is it possible to somehow add all of these up and show the total somewhere on this same spreadsheet?  :|


    Thanks so much!


    T

  • Profile Image
    david
    Answered on January 30, 2018 at 04:43 PM

     The full order details are forwarded to the spreadsheet, including transaction ID.  It would be possible to strip the rest of the data from the payment column and just keep the amount, but it would require forwarding the data to a new sheet, then modifying that sheet.  Modifying the integrated sheet can cause the integration to fail.

    The totals would likely be most easily accessed and managed from the payment processor, in your case Stripe. 

  • Profile Image
    TroyBrewer
    Answered on January 30, 2018 at 04:51 PM

    It would be possible to strip the rest of the data from the payment column and just keep the amount, but it would require forwarding the data to a new sheet


    I'd love to know how I might do this??  :)


    T

  • Profile Image
    david
    Answered on January 30, 2018 at 06:11 PM

    To copy the contents of one sheet to another, create a new sheet then use import range to import from the integrated sheet to the new sheet:

    https://support.google.com/docs/answer/3093340?hl=en

    Remove or filter the portions of the data you no longer need.

  • Profile Image
    TroyBrewer
    Answered on January 31, 2018 at 10:15 AM

    So there isn't a simple way of just telling JotForm to ONLY post the *value* of a certain field?

    So instead of this:

    (Amount: 53.00 USD) Total: 53.00


    We'd get this:

    53.00


  • Profile Image
    david
    Answered on January 31, 2018 at 11:30 AM

    There is not a way to have the payment field post only the value.  You could, however, capture the value in a calculation field, then pass that amount to the payment field:

    https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

    That way you would have one field that has only the values.  Though this would only work for new submissions.