Need help with importing from excel
How do I get a field from excel to import into a database when the field is grayed out on the initial import. Thanks
Is it the filemaker field that is greyed out or the excel column that is grey?
If it's the filemaker field, make sure that the field is a data field and not a calculation field.
No, it's the filemaker field. It's a notes field that is a sub-field of another table
Switch to a layout based on that other field and you should be able to import into the notes field. Careful though, as that won't assign any values to the key fields in that table that link these records to your first table. You'll need to come up with a way to get the correct data into those fields or the imported data won't appear in a portals or on any layouts where this field is a related field from another table.
thank you. I saw that limitation when I went to the Notes layout. I didn't have alot of records, so I just did a copy and past from excel.
Retrieving data ...