ODBC import troubles
I'm new to filmmaker and have a feeling I'm way over my head in this. I'm importing a spreadsheet from google sheets into my filemaker pro database (I run a non profit summer camp for kids). Besides the field's I'm importing I've created few extra fields in the filemaker table for each record (for office use). The problem is those new fields would not stick with the records and every time import the more updated version from google sheets it rearranges and the fields outside the source file are not included. What's the best way to tackle this so I can import from google sheet but still be able to manipulate some other fields and have them stick with each record? Any help would be much appreciated as I'm stuck beyond stuck. Thanks.