-
kenherr46Asked on April 9, 2018 at 10:54 AM
I have a form that is integrated with Square for payment. We also need the capability for an administrator to manually complete a form to get information into the spreadsheet without requiring payment. What is the best way to do this?
1. Can I create a duplicate form that is hidden from the public and also does not have Square integration but have the data collected in the same spreadsheet?
2. Should I create a duplicate form that is hidden from the public and does not have then Square integration and just merge the two Jot (Google sheet) spreadsheets when I am ready to compile the data?
3. Can I enter data into the Jot spreadsheet manually?
Page URL: https://form.jotform.com/80565876403160 -
David JotForm SupportReplied on April 9, 2018 at 12:28 PM
If the payment field is conditionally hidden, the form will allow for submission without payment. Here is our guide on setting up payment through the payment field while also allowing for the form to be submitted without payment:
https://www.jotform.com/help/120-How-to-Set-up-PayPal-Along-with-Other-Payment-Options
The example uses PayPal but the same works for any payment processor.
-
kenherr46Replied on April 26, 2018 at 2:51 AMI tried to insert the conditional payment option as described. The
show/hide works UNTIL I add information into the top section of the form.
Then the show/hide does not work.
https://form.jotform.com/80565876403160
... -
AdrianReplied on April 26, 2018 at 7:23 AM
I have added the following condition to your form.
The payment field should hide now if it is being used by the administrator.
1. Can I create a duplicate form that is hidden from the public and also does not have Square integration but have the data collected in the same spreadsheet?
It is not possible to send data from two forms in the same spreadsheet/submission page.
2. Should I create a duplicate form that is hidden from the public and does not have then Square integration and just merge the two Jot (Google sheet) spreadsheets when I am ready to compile the data?
This is a possible option, but I think hiding the Payment Field will work and you won't have to merge the sheets.
3. Can I enter data into the Jot spreadsheet manually?
It is not possible to enter data directly into the submissions page.