On your drop down list use onobjectmodify script trigger and then perform a script with a if statement
Define a field of type calculation, return type text with this calculation:
If ( Not IsEmpty ( FilterValues ( ValueListItems ( Get ( FileName ) ; "YourValueListNameInQuotesHere" ) ; YourValueListField ) ) ; YourValueLIstField )
Note that this will work with radio buttons, a drop down list or pop-up menu, but not a check box group.
Have tried both posts from S Chamblee and PhilModJunk but cannot get either to work. The solution from S Chamblee results in the script not accepting set field (tried replacing field with my actual field name but no joy). The solution from PhilModJunk results is not recognising ValueListItems.
My drop down field with values list is "Subject Category" and the other field is "Other Category". I would like the "Other Category" field to force the record creater to enter text.
Listvalue is the field name that you are using with your drop down list. You would use Subject Category in place of Listvalue then you would use other category in place of othervalue.
In the script editor you select Set Field then specify target field "Other Category" and then you specify Calculated Value "Other".
I don't know what record creater is ? Do you mean when you click "New Record" ?
You can have a field to auto-enter data by setting the auto-enter of the field.
You can select Creation Date..., Modification Date...,Serial Number, Value for last visited record, Data, Calculated value, or Looked-up Value.
If you want the word "Other" in a field when you create a new record new you would select data in Auto-Enter of the desired field and then enter the word "Other".
Here is a demo file in .fp7 format. If you are using FileMaker 12, launch FileMaker and open the file from the File menu to produce a converted copy you can open and examin in FileMaker 12.
Many thanks to you both. I now have it working.
S Chamblee - Record creater is person creating new record. Sorry for any confusion.