Is it possible to sync existing submissions to Googl Spreadsheet?

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

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.

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

 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. 

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

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.

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

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.