Is it possible to design a file that sorts like Microsoft Excel. I designed an Excel Sheet that consisted of 31 names of employees viewed vertical.

The Excel Sheet is based on employees taking overtime and distributing it equally. When an individual employee takes overtime, I place a number in the column on the right of their name and perform a sort. After the sort is completed, their name goes to the bottom of the list.

I would appreciate any help that I can get.

Sincerely,

Steve

FMP 5 introduced Table view, which offers a spreadsheet-like view of the fields on a layout.

In FMP 4 you're pretty limited to manually creating buttons and scripts to perform sorts.

Thank you Vaughan,

I was hoping there was a way to do this in FMP4.1

Hi, S! Of course, I don't know the details of your database, but FileMaker has multi-level sort so you might be able to get what you want if you tell FM to sort like

overtime (ascending or custom order)

lastname (ascending)

firstname (ascending)

FM remembers the last sort you did, too, so you can just mark the overtime and then CTRL-S (or CMD-S mac) and hit return. Or if you want, you can write a script using ScriptMaker that does it for you and/or attach the script to a button as Vaughan mentions. You should be able to do this in FM4.

If you haven't used ScriptMaker before, it may take a little time to see how it works but it's not too bad for simple stuff. Anyone creating FileMaker databases or using it a lot will probably want to know ScriptMaker for sure.

Good luck!

--ST