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.

Outcomes