I have been looking at different videos trying to find a solution or a way to do the following:
I need an interactive chart that will have Headers on the Column and Rows.
The cells in between need to be interactive to allow the user to change/edit the cell.
For example, please view image below:
Let's call the Columns; Visit Types and the Rows; Procedures
In between you see Xs implying that there is a charge for the column and row that cell is on.
Example from image above - The Procedure Written Informed Consent charge is applied on Pre-Screening Visit 1. So there is an X on the cell that intersects between the two.
Does filmmaker have an ability to do this?
I know I can use script triggers for the Xs and fields to make them into checkboxes.
Procedures and Visit types are already related through a link table. That is where this chart would live.
But I can't figure out how to create this interactive chart in FileMaker.
Any help is appreciated.
Thank you all.