A customer is someone who fills out the form created by the merchant
Read on or watch video
- Fill the form in the link (This form shows an example of how a lawyer can use Rippleforms to get bookings for a consultation call )
- After filling and submitting the form you should see a "You can pay using the following link" with a link. Click on the link
- You will be taken to a checkout page where you will have to connect your Gem wallet and make the payment. If your payment goes through you should see "Tx Confirmed"
- After paying go to this spreadsheet to verify your payment and form entry
A merchant is someone who creates the form and circulates it to their customers
Read on or watch video
-
Go to 'forms.new' to create a new form and name it. Lets say 'Tee Store'
-
Create a field 'Name' and set it to 'Short Answer' in the drop down next to it.
-
Do the same for the field "Email"
-
To charge for an item have {item} - {price} {XRP} For Ex : Red Tshirt - 1 XRP
-
You can have two to three options. For example:
- Red Tshirt - 1 XRP
- Blue Tshirt - 2 XRP
- Green Tshirt - 1 XRP
-
Set all the questions to "Required" to make sure you get replies to all questions
-
Now click on the three dots at the top right corner of the page and click on Script Editor.
-
In the file named "Code .gs" copy and paste the code in Google Forms > code .gs from the repo
-
Replace "Your Service email" in code.gs with your own service email that you created while setting up Sheets API.
-
Create a new HTML file by clicking on the "+" button next to Files section and name it sidebar.html
-
Copy the code from sidebar.html in Google Forms > sidebar.html from the repo and paste it
-
Click save and run code .gs
-
Now go back to your form page and you should see an icon that looks like a piece of a puzzle. When you hover over it, it says 'Add-ons'. Click on it
-
Click configure. In the pop-up that appears, paste the Gem Wallet address you want to accept the payments with and click save
-
That's it. You have a store now. But the the very first submission will not have the payment link. Fill it out yourself and if you see 'You can now accept XRP payments' that means you can send the forms link to anyone and get paid with XRP.
-
Click on the Add-ons icon again and click on "Get Sheets link". Open the link to see all your submissions
Before we begin you need to setup the Google Sheets API and save the credentials somewhere safe (Tutorial on how to setup API here)
https://github.com/RippleForms/RippleForms.gitPaste your credentials in credentials.json and install all necessary packages
npm install <all necessary packages>node script.jsYou should see 'Server is running on port 8000'
You now have a store. Follow the previous steps to test it out.
- The link at the end of each form submission will have row number, column number, sheet id and wallet address passed as URL params
- When the webpage is visited the URL params are read with gviz to find the form submission details of that user using the row and column number
- Once all the details are read, the regex will find the cell values with XRP and add up the price values
- This value is passed onto payment handling. The customer will be promted to pay the total using the wallet they connect
- Once payment is confirmed, Sheets api will write 'confirmed' into the row and column that was read from the URL params
- Can only accept XRP
- Not secure. Currently you need to copy paste your wallet address to make the form payable. Working on this. Will make the user sign and connect wallet
- Apps script makes the sheet visible to everyone with link. Will make this secure by making only Google Sheets API read the sheet
- Buggy sometimes. While reading the total XRP, sometimes it doesn't take in the whole amount. Working on this.