How to Automatically update text field after updating another field
Hi, I'm trying to create a solution based on invoices template from FileMaker 12. I'm trying to add payment dates for multiple payment of an invoice. How can I update Payment Status field instantly after I'm updating a portal field? I have tried script triggers (modify, validate, save, exit, all at once and one by one) on every portal fields and buttons to update Payment Status and it make my computer hang after I select object outside portal. Possibly because I use keyboard navigating instead of mouse pointer navigating.
I tried to add script trigger on layout enter, keystroke, exit to update Payment Status field, but it will not update field when Filemaker crashed (or forced to quit) when inside that layout, so I can't use this solution.
I tried to use calculation field, but it will show double on Customer Details layout portal. Even if I use this solution, I doubt it can handle large data because it have to calculate all invoices.
So, as title says, how to automatically update text field every time I update another field (in a portal)?