H Posted January 27, 2016 Posted January 27, 2016 Hi What i want is that when i create a new record my check box field get auto selected the correct option. How would i script that what ever i try doesn`t seem to get it working. Please can someone help me out with this. Thanks
Kris M Posted January 27, 2016 Posted January 27, 2016 (edited) why script it when you can set the field to auto enter data "the value i want the check box to have on create" Edited January 27, 2016 by Kris M
ggt667 Posted January 27, 2016 Posted January 27, 2016 (edited) I guess what you are looking for is lookup; no? The question is where do you lookup the correct option? Edited January 27, 2016 by ggt667
H Posted January 27, 2016 Author Posted January 27, 2016 how would i define to autoenter a radio box on creation? i can`t seem to get it , putting in set field "fieldtext" , but not giving me the results. please can someone help me out or auto enter in the data box putting in the radio box field name not getting the results
comment Posted January 27, 2016 Posted January 27, 2016 (edited) 13 minutes ago, H said: how would i define to autoenter a radio box on creation? The same way as you would for any field. For example, this will auto-enter the value of "No" into a field that could be formatted as "Yes/No" radio buttons. Actually, the field's formatting on the layout has nothing to do with it - this is purely a data question. The same field could be formatted as radio buttons on one layout, and as an edit box on another. See also: http://www.filemaker.com/help/14/fmp/en/html/create_db.8.24.html Edited January 27, 2016 by comment
Lee Smith Posted January 27, 2016 Posted January 27, 2016 1 hour ago, H said: How would i script that what ever i try doesn`t seem to get it working How are these checkboxes made up? One checkbox per field, or a group of checkboxes based on one value list?
H Posted January 27, 2016 Author Posted January 27, 2016 based on a value list. Actually what i see is in a edit box field it show up the correct answer however in the radio box field of the same field in the same record and table the radio box is not highlighted
comment Posted January 27, 2016 Posted January 27, 2016 4 minutes ago, H said: what i see is in a edit box field it show up the correct answer however in the radio box field of the same field in the same record and table the radio box is not highlighted I don't think this is related to your original question. In any case, what you see indicates that the value entered is not exactly the same as the one in the value list. For example, one of them could have a trailing space.
Kris M Posted January 27, 2016 Posted January 27, 2016 (edited) Comment is exactly right here. If the list that sets the choices for your radio./ checkbox has list items Blue, Orange and Pink where Blue and Pink are 4 chars and Orange is 6 chars and you set the field to anything other than Blue with 4 chars, Pink with 4 chars or Orange with 6 chars the control will not show as selected. Edited January 27, 2016 by Kris M
Lee Smith Posted January 27, 2016 Posted January 27, 2016 @H the Auto Enter only works for New Records from here on out. If you have existing records, you will need to handle them different. Lee
webko Posted January 27, 2016 Posted January 27, 2016 Can you show us your auto-enter data, and your value list? This sounds like the data being entered is, for some reason, not an *exact* match for any of the values in the value list...
Lee Smith Posted January 27, 2016 Posted January 27, 2016 Then your file works as you desired. @webko H sent me their file by Private Message and I verified that his auto enter calculation works as desired.
Recommended Posts
This topic is 3584 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 accountSign in
Already have an account? Sign in here.
Sign In Now