Notes Utility how to export and import and How get the Timestamp to appear as text and numbers

     Please explain what you mean by "notes utility". What is it and how is it designed?

     There are still unanswered questions here. Your first layout shows fields from a related table: Note Info and the 4 fields immediately above the Text Copy field.

     You later show a portal--which is a good idea, yet your text field for the note still shows an inserted timestamp and user name. This is not necessary when you use a portal with one record for each note entered and keeping notes and timestamps separate from the note text is one of the reasons for using a portal with separate records for each note. This allows you to keep that data in separate fields that are part of the same note record.

     

          I went to an older save of my DB and exported the notes utility, no problem.Then I tried to bring it into the current DB that got messed up yesterday and the only thing that imported was the Timestamp.

     Was the notes table in your older copy exactly the same as the current copy?

     You don't actually have to export data from a FileMaker file and then import the exported data into a different FileMaker file. You can use Import Records to import the data directly from one FileMaker file to another. But when you do import the data, it requires correctly mapping the fields of the source table in your older file into the target table of your current file. Of especial importance is that your notes records have a match field or fields that are needed to link a notes record to the correct related records in other tables. This data must be mapped correctly or the imported data won't match up to correctly to related records.