Date Field Logging
I need to capture specific dates associated with payments for Months 1-12. What is the best method to accomplish that? I don't see audit logging for date fields and would prefer to not have 12 date fi...
Forum Discussion
Probably the best option is to have an audit log table named something like "Payment History"
I'm not sure how your tables and fields are set up, but you'd set it up to where each time a payment is made, an automation would trigger to create a new record in your "Payment History" table that would log who made the payment, what the payment was and since a new record is made when a payment is made, the "Date Created" would be your date paid. With this, you'd have a complete payment history a lot more capabilities.
I'm not sure how your tables and fields are set up, but you'd set it up to where each time a payment is made, an automation would trigger to create a new record in your "Payment History" table that would log who made the payment, what the payment was and since a new record is made when a payment is made, the "Date Created" would be your date paid. With this, you'd have a complete payment history a lot more capabilities.