Jump to content

Importing multiple Excel values into checkboxes


tigergirl
 Share

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

Recommended Posts

Hello all,

I have an Excel spreadsheet that has a field with multiple values from a survey (ie - a,b,d,f,g,j). I need to import those values into a checkbox field in FMP. When I do the import, only those records with a single entry (ie - : show up checked properly, although if I change the field type to standard data entry, all the information shows up. Is there some way I need to separate out the information prior to (or after) the import?

Thanks for your help!

Link to comment
Share on other sites

Multiple entries in a checkbox-formatted field are separated by pargraphs. From your description the imported data is comma separated. You could run a Replace command over the field and specify a calculation that Substitutes a paragraph for comma character.

Link to comment
Share on other sites

This topic is 6500 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.