show/hide fields in layout?

[poeben]

Hi,

Hopefully this will make sense and be easy to answer. I am creating a schedule in FM for our employees. Due to the nature of our business, there can be any number of employees on for a given shift (from 1-20 people), as well as multiple shifts per day. I would like to set everything up like a spreadsheet, each person in it's own field.

I would like to have, by default, 4 spaces for personnel with the ability to add more as necessary for that particular day. I was thinking along the lines of a button to add another row and a button to move to the next day. Another option is to automatically have one blank field following the full ones, and when that is filled one is added below it.

Can anyone help, or point me in the right direction? Thanks in advance.

[Fitch]

What you want is not fields, but a related table of shifts, which you would view through a portal.