Excel Looking Data Entry View

[John.]

I have been working on a request to provide a UI that presents information in a grid view for data entry. The database has Jobs/Job Items/Job Item Tasks.

The view would ideally show Job Item and Job Item Task info so a user could create and edit records from. In the task records, there are fields that are common (Qty, Round, Description) but have different context based on what other fields are filled out relative to the record.

There are filtered portals to get each task record to show up correctly in the layout. I'm using zippscript to execute a script on field entry but also need to execute a script on field exit. The field entry script execution is performed using the webviewer technique found on the filemaker magazine site which is designed to allow for executing more than one script.

On field exit, I thought I could try a similar technique. Because the fields are common between the tasks, for example the Qty field, depending on which portal a user is in, a different script needs to execute.

Below is the code currently in the Qty calculation, but I'm not sure why it's not executing.

Let([

_Object = Get ( ActiveLayoutObjectName ) ;

_Script= Case(

_Object = "PDFProoftQty"; "On Field Exit- PDFProofQty";

_Object = "PDFProoftRound"; "On Field Exit- PDFProofRound";

"");

_Trigger = If( not IsEmpty( _Script) ;

Qty & zippScript_PerformScript( Get(FileName); _Script ) )

] ;

"" )

Has anyone tried to do a similar style relational layout? Is there a better way to approach this keeping in mind this is what the users are requesting.

Thanks,

John