The company I am working for has been using a scheduling app I created several years ago (FM5). They like using it, but have decided to go with a large manual (magnetic) schedule board- possibly in conjunctrion with FM.They want to have the ability to move around the magnet pieces to help determine schedule and daily work load (which they aare already doing on their small monitors)..they are a visual group.

I am trying to convince them to purchase a Smart Board and use it as a digital "magnet" schedule board and use the exsiting structure to store and view the data the data.

Has anyone created a layout in which one could drag and drop fields in a job board type layout that would also calculate totals for the day.. (i.e. drag and drop composite text field which may contain a job number and client that relates to a # hours calc field and have a summary field at the bottom that shows the total number of hours for a day)

The composite and calc fields have already been created and are in use..it is simply the drag and drop functionality and the use of a smart board to move the data around

I don't think you can do this with drag and drop in Filemaker. When you drop into a field that already contains some data, the dragged data is INSERTED at the cursor position. And the source field retains the dragged data. A magnetic board simulator needs to EXCHANGE data between two locations, I think.

I have done something similar once, but it works by first clicking the source field, then the target field. IIRC, the basic script goes something like:

Set Field ( gLow ; clickedField )

Set Field ( clickedField ; gHigh )

Set Field ( gHigh ; gLow )

So each click swaps the data between the clicked field and a global.