Jump to content

importing to checkbox set


A.Ender Birer
 Share

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

Recommended Posts

  • Newbies

hi,

i am very new to filemaker, can you please hep guys.

i am importing an excel file which has some comma seperated values in one cell that goes into a checkbox set in fm8.

but i cannot manage it, the checkbox set does not understand commas.

for example the cell contains:

America, UK, Germany, Italy

and the checkbox set has the same values as a custom list

How can i import the data to checkbox set and display the values checked?

Link to comment
Share on other sites

A checkbox is merely a formatting option for a text field. The actual values contained in the field are return-separated. So, after the import, run a loop [or Replace] to set the field with

Substitute( yourField; ", "; ¶ )

Link to comment
Share on other sites

Click in your field. Then press Ctrl + = (or go to the records menu and select replace field contents)

Choose replace with calculated result and then put in Substitute( yourField; ", "; ¶ ) where your field is your field

~Genx

Link to comment
Share on other sites

I'm sorry? You mean you put it in a loop?

Likely the reason it didn't exit the loop is because you didn't specify an exit condition i.e. Exit Loop If.

If you did this in script maker, it should have been structured as one of the following:

Loop

Set Field [yourField ; Substitute(yourField; ", "; ¶ )

Go to Record [Next ; Exit after Last] **Note, when specifying, go to record Next or previous, there is an "Exit After Last" option which is ticked in this case.

End If

or

Loop

Set Field [yourField ; Substitute(yourField; ", "; ¶ )

Exit Loop If [ Get(RecordNumber) = Get(FoundCount)]

Go to Record [ Next ]

End Loop

~Genx

Link to comment
Share on other sites

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