CWH Posted March 8, 2001 Share Posted March 8, 2001 I'm trying to devise a simple method to import form data (prbably from multiple Word docs) into a FM database. Is there an easy way to have to have FM look at a group of fields in the import data and enter one value based on which checkbox was marked? The Word form has 4 checkboxes, which export as individual fields with either 0 or 1, while the DB has just one corresponding field with the value entered as text. Do I have to set up fields in FM that match the ones from Word, then create 4 calc fields that pass text to the one field that I want filled in? Any general pointers about importing form data appreciated. Link to comment Share on other sites More sharing options...
BobWeaver Posted March 9, 2001 Share Posted March 9, 2001 Importing into FM requires a one to one correspondence for the fields. So, you will have to have bring the checkbox fields into separate fields, and then convert them with a script or a calculated field. Link to comment Share on other sites More sharing options...
mikihasa Posted March 14, 2001 Share Posted March 14, 2001 I have been able to import to a group of checkboxes by separating the corresponding value field entries with a newline character. For instance, If your FM checkboxes have a value list like this: Male Female Both Neither Other and you want to have the Male and Other boxes checked, you can import the following to the FM field: Male Other which will check the first and fifth boxes. I wish this worked for repeating fields, but it doesn't. Please note that I am using ODBC and not importing from Word, so this may not apply to you, but I have been able to populate multiple checkboxes in a group from a tab or text delimited file as well. Michael Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8444 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now