Jump to content

Importing from forms


CWH
 Share

This topic is 7524 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 7524 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.