mahima Posted February 7, 2008 Share Posted February 7, 2008 Hi, In my Filemaker file I have one column having values Yes/No. While exporting to Excel, I want to change yes as 1 and No as 0. Is it possible? Thanks in advance Quote Link to comment Share on other sites More sharing options...
_henry_ Posted February 7, 2008 Share Posted February 7, 2008 Hi Mahima, Hi, In my Filemaker file I have one column having values Yes/No. While exporting to Excel, I want to change yes as 1 and No as 0. Is it possible? Thanks in advance It's possible... Here's my idea: 1. Create a temporary field (calculation) - result: Number 2. Do some calculation, for example: If ([yourfield_Yes_No_values] = "Yes", 1, 0) 3. Do the export to Excel file.. Remember, to include the new "calculation field on your layout" and omit the "yourfield_yes_no_values" from the layout. Let me know if this works or not smiley-smile Quote Link to comment Share on other sites More sharing options...
mahima Posted February 7, 2008 Author Share Posted February 7, 2008 Hi Mahima, It's possible... Here's my idea: 1. Create a temporary field (calculation) - result: Number 2. Do some calculation, for example: If ([yourfield_Yes_No_values] = "Yes", 1, 0) 3. Do the export to Excel file.. Remember, to include the new "calculation field on your layout" and omit the "yourfield_yes_no_values" from the layout. Let me know if this works or not smiley-smile Can I do this for allready existing fields/data? Thanks Quote Link to comment Share on other sites More sharing options...
_henry_ Posted February 7, 2008 Share Posted February 7, 2008 Have you tried to make it? I am pretty sure that it will work out. smiley-smile From FM's help: A calculation field calculates a result from values in other fields in the current record, from related records using a relationship, or from fields defined with global storage options. If any field on a layout containing unstored calculations is set to auto-resize, calculation results will be updated when the window is resized. Quote Link to comment Share on other sites More sharing options...
LingoJango Posted February 8, 2008 Share Posted February 8, 2008 Are the Yes/No values in a field defined as text? I ask because it is not altogether impossible for the Yes/No values to actually be 1s and 0s but display as Yes and No. Try an export and see what you get. Otherwise, you need a calc. If this is a one-off export, just export to excel and add a column and calc there. If it's more than once, you can use Henry's calc in a new calculation-type field. Quote Link to comment Share on other sites More sharing options...
_henry_ Posted February 8, 2008 Share Posted February 8, 2008 Hi LingoJango, I tried to mention that to his/her, but it seems that he/she did not believe me... smiley-cry Well, hopefully Mahima can respond to this thread... Quote Link to comment Share on other sites More sharing options...
LingoJango Posted February 8, 2008 Share Posted February 8, 2008 It looks more like lack of familiarity with the program than disbelief. Quote Link to comment Share on other sites More sharing options...
_henry_ Posted February 8, 2008 Share Posted February 8, 2008 Well, I guess so... smiley-laughing Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.