Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Isn't this normal behavior for checkboxes in general (not just with IWP)?

If you look at the results of a field formatted as an edit box after data has been entered by checkboxes you will find that multiple values are delimited by carriage returns. If you suppress that behavior the checkboxes won't work.

Posted

I'm with Matthew here, a way to use the value later sans these is simply to trim them off via:

http://www.filemaker.com/help/FunctionsRef-355.html

...but you face another problem, the checking could be entered arbitrarily, so plucking the first not nessersarily is the first box checked seen from the layout.

Such a checkbox field can be sorted via autoenter(update) and this calc:

FilterValues(ValuelistItems(Get(FileName);"theList";_yourField))

Maybe this template will make these aspects more clear?

--sd

Untitled.zip

Posted

Sorry I should have been more clear. This is just a boolean checkbox (check the box for "1", uncheck for off). I don't like to use radio boxes in this situation because of the need to hold down shift to deselect.

In the client it just puts the "1" in the field, in IWP it adds a carriage return.

Posted

Perhaps you should explain why it's a problem in your context, getting rid of it is pretty easy:

Left(_yourField;1) or

Filter(_yourField;"1")

Abs(_yourField)

Int(_yourField)

...just to mention a few...

--sd

Posted

Yeah I used the left function. It just irritated me that I had to. Just wondering if anyone knew why it behaved differently than the client and if there was a way to fix it instead of workaround it.

Posted

Could this observation be substantiated, this is normal checkbox behavior in my humble opinion ...mfero seems to agree with me?B)

--sd

This topic is 6266 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
×
×
  • Create New...

Important Information

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