Is there any way that we can show the invoices in our form from our database to pay online?

  • MuhammadUmair016
    Asked on August 27, 2020 at 5:05 AM

    Hello | Hi

    I have the invoices and I want the people to pay the invoices online. For that, I want to create an online payment form. Now, the problem is that is there any way that we can show the invoices in our form from our database may be in the form of pictures or other ways. When the user enters a unique ID then their bill should show there and they can easily pay it.

    I hope I am able to convey my message.
    If you need any further information then please mention it.


    Any other solution for my problem, if you have, would be appreciated.


    Remember I have not created any form till now

    Thanks as always for your help

  • Kiran Support Team Lead
    Replied on August 27, 2020 at 10:12 AM

    If the data is an Excel sheet, you may try using 'Spreadsheet to Form widget' to pull the data to the form fields using a Unique field. Please see the guide below that can help you with this.

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    The data can be pulled to different fields as per your requirement and calculate the total to a form calculation widget.

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    The total can be passed to the payment field for processing the payment by following the guide below:

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

    Please give it a try and let us know if you need any further assistance. We will be happy to help. 

  • MuhammadUmair016
    Replied on August 27, 2020 at 12:29 PM

    You are awesome bro. One more thing.

    Can we Link google sheet to a spreadsheet to form  widget? Is that possible? Currently, we have to upload the spreadsheet? Can we link it to google sheet.

    Thanks

  • Kiran Support Team Lead
    Replied on August 27, 2020 at 1:38 PM

    Can we Link google sheet to a spreadsheet to form widget?

    This question is moved to a separate ticket and shall be addressed there shortly.

    https://www.jotform.com/answers/2540973

    Thank you!

  • MuhammadUmair016
    Replied on August 27, 2020 at 2:27 PM

    Sir, can you tell me how we can pass value from one form to another form? I want to copy the amount value from one form to another form. Thanks
  • Kiran Support Team Lead
    Replied on August 27, 2020 at 4:49 PM

    The other question shall be addressed on a separate ticket shortly.

    https://www.jotform.com/answers/2541402

    Thanks!