Table of Contents

How can I show a customer's payment history if I'm collecting payments through my Knack app and through cash or check?

Lesley Updated by Lesley

If you're using Knack's e-commerce feature to collect payments through your app, and you're also collecting payments from customers in cash or by check, then you can track all payments from your customers within Knack.

You'll need two connected tables to make this work.

1. When the e-commerce features are enabled, a Payments table is automatically added to your app to track all debit card or credit card charges. To reduce confusion, you can rename this table to "Credit/Debit Card Payments".

2. Create a new Payments table to track all payments received. In this table, you'll create a new record each time a customer pays via cash or check.

3. Connect the "Payments" table to the "Accounts" table, so you can specify which customer made the cash, check, debit, or credit payment.

4. Connect the "Credit/Debit Card Payments" table to the new "Payments" table. 

5. On your payment views, add a payment (record) rule that automatically creates a new connected record in the Payments table each time a new credit/debit card payment is made through your app. Be sure to pass along the customer connection from the credit/charge using the payment rule. 

That's it! Now you can keep all of your customers' payments in your new Payments table while still allowing customers to make payments through your app. 


How did we do?

How do I move or copy fields or data from one table to another?

Is there a way to add a display rule to multiple columns at one time instead of having to update each column individually?