portal filtering of uncommitted recrods can be toggled (show or unshow filtered) in fm11 but not in fm12
in fm11 i use Refresh & Flush to display changed filtering of uncommitted portal records - in fm12 the filter works after committing only the Refresh & Flush doesn't change the display.
1. create a portal based on a relationship with allow creation of related records
2. use a script trigger to commit only by hitting a button which sets a flag the OnCommit trigger tests for and resets it when committing
3. create a filter predicate in the portal setup to be true if either the global filter field is empty of the parent record or the field in the child record postion function is true ( > 0 )
4. create a on validation or save trigger to refresh & flush when the filtered global field changes the filter is testing on by checking with position function '
to display independently of record open state the portal filtering when changing the filter content
no change when filtering while uncommitted
file is standalone
none - portals with allow creation of related records are the only way to implement transactional functionality supported within filemaker's commit logic.
also filtering here is the only way to turn on / off a hierarchical structure with uncommitted records in fm11 but not infm12- it works displaying the data nicely but the math fails in fm11.
thank you !
(i have a demo file if you want )