AnsweredAssumed Answered

Interactive Chart

Question asked by JulioSandoval on Jun 5, 2017
Latest reply on Jun 6, 2017 by philmodjunk

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:


Screen Shot 2017-06-05 at 4.52.59 PM.png


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.