Importing from multiple field names into 1 field

[idgely]

On the old DB my company was using, there are a ton of checkboxes. Currently they have them each as a unique checkbox, I need them to all be merged into one SET of checkboxes. (I'll give an example)

For example, previous there were age ranges (18-25, 26-30, 31-35 etc.) Each age range was a seperate field and held a value of "checked" or "unchecked" (ie: 18-25 was seperate from 26-30 rather than being selected from a value list that included 18-25 AND 26-30)

I need to take that information of "checked" or"unchecked" and have it actually take and check or uncheck the boxes in my check box list.

I'm reading what I can from this forum, but I'm not finding anything that would help in this situation. If you can help, I'd really appreciate the time!

[comment]

You need to import the old separate fields into new separate fields, before you can combine them. So let's say you have 3 text fields f1, f2 and f3, and you import 3 age ranges 18-25, 26-30, 31-35 into these fields respectively.

This data is mutually exclusive - only one of the fields can be "checked" (hopefully). So we can now define a calculation field AgeRange (result is text)=

Case ( f1 = "checked"; "18-25") &

Case ( f2 = "checked"; "26-30") &

Case ( f3 = "checked"; "31-35")

After you have checked that the import and the calc are OK, you can change AgeRange to a regular text field, and delete the 3 separate fields (assuming you will only be doing this once).

Last, create a value list based on the values from the field AgeRange.

NOTE: Since only one value is allowed, the field should be formatted as a radio button, instead of checkboxes.

[idgely]

comment thank you so much for the help, I'll try it out and let you know. I do need to be able to check more than one option though. (Think matchmaker type db, you'll need to know if a person wants to date someone in the age range of 18-25 AND 26-30)

I've been using the logic

AgeRange =

If ( IsEmpty( f1 ); ""; "

[comment]

Your calc is not returning any actual data - just carriage returns.

Also: I thought the imported field are either "checked" or "unchecked", which implies they are never empty.

Try:

Case ( f1 = "checked"; "18-25

[idgely]

I only used the "

[idgely]

So that doesn't seem to be working. I am not quite sure what I'm doing wrong, but it isn't checking a box at all. I've tried variations of all of the examples I've read. Doesn't seem to be anything being read in there at all?

Any ideas?

[comment]

Can you post a sample file?

[idgely]

I"ve just opted to have it manually entered there are only 300 records, so it won't take that much time. Would take more time to figure this out. Kind of frustrating. I'm giving up for now, doesn't mean I'm not going to figure it out in the future, just not right now as time is of the essence with the db upgrade I"m working on.

I appreciate the help though!!