-
apagroupltdAsked on March 1, 2021 at 11:02 PM
-
Vick_W Jotform SupportReplied on March 2, 2021 at 3:08 AM
Hi there,
Unfortunately, we do not have any option available that you can use to allow your customers to use existing credit. The only workaround that I can think of is that you use the "Spreadsheet to form widget".
You'll have to keep the excel file updated. When the user selects the option to use credit the widget can be displayed using conditions.
Then the user will enter their code in the widget and it will populate the amount of the credit from the spreadsheet to form the widget. Now you can use the form calculation widget to minus the credit amount.
You'll have to keep on updating the file after a user uses their store credit.
https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget
https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget
https://www.jotform.com/help/275-how-to-pass-a-calculation-to-a-payment-field
Let us know if this will fulfill your requirement or if you have any questions.
Thanks