exporting with formatted value question
I have a problem with exporting data. I have a text field named answer. In some sistuations, the answer contains 1 or 0. How can I export to excel but convert 1 to Yes and 0 to No before exporting in these sistuations? In other words, I'd like to see Yes or No value in excel instead of 1 or 0. I'm just wondering if it's easier to somehow make Filemaker to display the value Yes and No in the Browse mode before exporting.
Another small question: I have mutiple related fields on my layout. The field is often showed with format like ::relatedField. Is there an option in FileMaker to show its full path such as relatedTable::relatedField so I don't have to double click on the field to see from which table the field comes from.