Hello everyone and thank you for accepting me within your community! I am new to the Filemaker Platform and i would really appreciate it if a more experienced user could help me out a bit. Thank you!
Details: I have a Payments Received table where i hold payments coming in by companies AND contacts. The table has 2 text fields (company name, contact name), an amount received text field, a summary field (total of amount received) and a payment status field, value list, to filter the payments by "Paid", "Pending", "Cancelled".
In list view, how can i :
1. Report on payments received by companies only with payment status "Paid". Currently i get a list of companies AND contacts with total received from both.
2. Steps to Print each filtered list
3. Do i need 3 different layouts to show the payments by status? one for paid, another one for Pending etc.
Thank you for your time!!