Option 1: Use two fields. Set up field 1 with your value list and set up Field 2 as a calcuation field with a case function that returns the correct number value for the text entered into the field with the drop down. Select your value in field 1, but export the data from field 2.
Option 2: Set up a table of related values, with one value in each record of this table. Use two fields, one for th numeric value and one for the text. Set up your valuelist to list values with the Numeric field selected as field 1 and the text field selected as field 2. There's an option that you can select to only show values from the second field so that the text is shown in the list, but the number is entered.
2) Define a value list with just 1 as the only custom value. Add an auto-enter calculation with this expression to change the value to zero when the check box is cleared: If ( IsEmpty ( Self ) ; 0 ; self ) and clear the "do not replace existing value" check box. Also, enter a 0 in the data box on this same tab so that each new record always starts with 0 in this field. Note that you can resize this field so that the 1 is not visible--just the check box.
Sounds like you are having fun with Value Lists.
Do what PhilModJunk says, because he is pretty good at this, as far as I'm concerned. OR if you want to read on, just to give options...
Question 2: I always have a value list that is called Bool_One, and all it has is the static value 1 and nothing else. When checked it would have the value as 1, and not checked it is empty. If "0" is necessary to be recorded use a radio button.
Question 1: So when I need a numeric value for something that has text, I usually have a separate table with those values. Then I make a value list that has "Use value from field" and the first value is the numeric field, and the second is the text. Then I choose "Shown values only from second field".
Hope That Helps (HTH)
Thank you both. I love this forum. And IT_User, i think your right, PhilModJunk - knows his File Maker.
I have'nt had time to mess around with question 1, but i think i did something horrably wrong regarding question 2, i did as Phil said:
Add an auto-enter calculation with this expression to change the value to zero when the check box is cleared: If ( IsEmpty ( Self ) ; 0 ; self ) and clear the "do not replace existing value" check box. Also, enter a 0 in the data box on this same tab so that each new record always starts with 0 in this field.
Now when i try to export (wanted to see what the data looked like) It crashes filemaker so bad that i have to restart the computer to get it working again.
any clue to why that is?
Works like a charm, the problem with export was that when i exportet to xls - FMp crashed. This is due to the fact that i use OS 10.8.3 and thus lack Rosetta. When i export to xlsx there is no problem.