AnsweredAssumed Answered

Batch Entry Using Script and Global Fields

Question asked by sulu762 on Dec 26, 2011
Latest reply on Dec 27, 2011 by sulu762

Title

Batch Entry Using Script and Global Fields

Post

Mac OS X 10.5

FMP 10 Advanced (Beginning User)

 

Tables:

Personnel

LeaveComp

 

They are joined by a unique personal ID #.

 

Layout 1 lists all the employees as listed in the Personnel table.

Layout 2 records all individual leave and comp time accrued and used.

Layout 3 is where I would like to batch enter vacation time accrued or used and it shows information from the Personnel table.

 

In the header of Layout 3, I have global fields that contain the data I would like to batch enter:

LeaveComp::g_AccruedorUsed

LeaveComp::g_NumDays

LeaveComp::g_Notes

 

and in the body, I have the list of employees names with a checkbox labeled “No”.

 

I would like to push one button that will record all global data (for employees where the “No” checkbox is unchecked) into Layout 2 where the field names are the similar to the global fields (sans "g_" prefix):

LeaveComp::AccruedorUsed

LeaveComp::NumDays

LeaveComp::Notes

 

Currently I have a button beside each of the names where the user must click it to add the record, however I’m trying to make it easier by the use of only one button.

 

I’ve searched the forums, however I don’t know the correct keywords to get the correct answer.

 

Any help would be appreciated. 

Cheers!

Outcomes