When I create a field and field label for date and place it in the header or footer, the date will not print and does not update when inserting new data. How do you make this work?
Could you be looking at a blank record in Preview mode? I've attached a sample where there are two records, one with data and one without. If you scroll through in Preview, or through in Browse, they can appear as missing data. Otherwise, there is no reason it shouldn't appear. If this doesn't help, you may want to post a copy of your file for review.
Non global fields placed in the header or footer will show data from the current record when in Browse mode.
When you print, preview or save as PDF, the field will show data from the first record on the page (header) or the last record on the page (footer).
If you want the value to appear on every page of a multi page, multiple record report, use either a global field, global variable, or a record in a related table that links to all records in your report.
Thanks for the reply…
I have created a database that is viewed in List View. So, there are several line entries per page. Then, the header has the field which I named “Revision Date”. In the Manage Database “Fields List, I added the Revision Date field and assigned it to be a date.
- In Browse Mode the field label show on the screen but the date doesn’t show up. If I key in a date, it disappears.
- In Preview Mode neither the field label or the data appears. There is just a blank space.
I have already explained why this can be the case. You can't add a non-global field from the same table as that on which the layout is based and expect it to show the correct data for every record in your report.
Why not just use a text object with includes the current date and current time symbols?
OK… With your help, I believe I have the solution.
The issue is that there are multiple records on one sheet. The records are one line each and are in List view. Therefore, the header for the one page has no connection to any one record. The way for me to solve the problem is to simply place the date symbol in the header preceded by the text “Revision:” While this may not be a true revision date, it will identify the date the data was viewed or printed.
Yes sir… That works for me.
If that works for you, then all is good, but:
Therefore, the header for the one page has no connection to any one record.
That is not correct. Read my previous replies again. It depends on your window mode. When you are in Browse mode, regular fields in header and footer show data from the current record. You can take a copy of a field from the body and put it in one of these layout parts, then click on different records in your found set and watch the field update to show the data from that record. When you are in Print or Preview mode, the data in the header is taken from the first record on the page and the data in the footer is taken from the last record on the page. This can be very useful in some contexts.
If you want to keep track of revision dates for different records in your table you can do one of the following:
Use Replace Field Contents to assign that date to a field in all the records in your found set.
Set up a related record with the revision date and use this record's primary key (unique ID field) to link it to all records in your found set--once again a replace field contents operation but now setting the field to the ID instead of the date. This second option, could be used to set up a revision history in that related table.
Thanks… I am enlightened.
I will use the info you gave me to better track what is going on “date wise” in my solution. I realize that the window mode makes a big difference.
Oh, by the way, I love FileMaker...
Retrieving data ...