How do i insert blank rows & columns in a form?
Do you just want to "Add new record"
FileMaker is not a spreadsheet. Rows are records in FileMaker. Columns are fields. Can you provide more information of what you want ( either the file itself, screenshots ) ... anything to help the folks here help you with it?
No. I am setting up a weekly timesheet for our employees & need 6 columns & multiple rows for them to fill in.
Is this to be printed? if, so, I would create a "layout" with grid lines to print. Don't worry about fields.
If, on the other hand you want to have them ENTER information, then I'd recommend that you study the creation of blank records (or related records). Leaving too many "blanks" to fill in will leave you with many blank records. - not optimum. So you want to teach your users (and/or provide a button) to create a new record, make the entry, then "submit".
your structure is tridimensional, because you have also the week as entity: the data for week 12 is different from the data for week 13. Think about that, first.
Yes, it is printed. I’ve created a layout but the only drawing options I can find are straight lines & rectangles. I’m trying to avoid having to line up multiple lines or boxes. I guess what I’m asking is if there is an option for printable gridlines that are lined up evenly? Word has an option for inserting a table where you can tell it how many columns & rows. Does filemaker have something like that? I started a layout using lines but can’t seem to get all the lines to line up the same. Thanks so much for the help.
Numbers for Mac - Apple
What I find helps enormously with getting lines to "line up" is using the Position Tab in the Inspector and setting layout objects (lines, rectangles etc) using the position settings. It is quick, easy and most importantly it is precise!
An old, but still works, trick:
create a line
duplicate it (It will be offset)
move the line to the correct spacing from the first (I use the arrow keys while the object is still selected.)
duplicate it (it will be spaced the same as between the first and second!)
Another tip (or two):
Learn about the alignment
Especially Distribute! I create as many lines (or other objects as I need by duplicate, but not moving between the first and second. Then I select and align Left. select the LAST line and move it where needed. Select all the lines and Distribute.
Another tip is to use the Grid and snap to grid
Using the rulers and grid
Retrieving data ...