Note is not a field in research notes table, it is in another table "Data" that related to research notes table.
There is no problem to export fields from related table.
When import, it can be only imported to one table at one time.
You need to see how another table is designed and related to the 1st table, do a second import to 2nd table, and some info needs to be filled out by script or manually in order to be shown correctly from the layout.
Hope this helps.
On closer review...what is the field NOTE TYPE MATCH FIELD. Is the data importing into that field?
+1 on the reply from "US" below. Not us but "US"
"Who" is on first ;-)
Often times it is easier to cut Excel out of the middle of the work flow. (if possible)
Thank you for the reply, I just added a field under the research notes table called Dictation (seen below). I hoped that this would solve the problem of it being under a different table (Data vs. Research Note).
This is what my layout view of the research note looks like, while editing certain fields.
I tried importing the excel sheet dictations in, and none of the dictations were transferred.
TonyWhite Thanks for the help, I don't know what the NOTE TYPE MATCH FIELD is - it came from the original research project filemaker pro template. I tried importing the Dictations to NOTE TYPE MATCH FIELD, but nothing was transferred (I was testing stuff out).
As you can see below, I was not able to transfer anything to the Data table or the Notes table because it is greyed out (per US suggestions, haha). I am not sure why I cannot access these related tables. Do I have to change the relationships? It is very strange I can export, but not import to those related tables...
I am not sure how to cut out excel out of the middle, as I needed excel to find and replace certain terms. In addition, I expect my research manager wanting to export and import data using excel which She is more familiar with (excel).
This is the correct answer. When you have a portal on a layout, it is only a "view" into another table (based on a relationship to narrow the record set).
Import (of any kind) can only occur INTO the table where the fields reside (a layout based on the table), not related fields.