languid Posted February 28, 2016 Share Posted February 28, 2016 Hello, I've been away from Filemaker too long. I have created a database of donuts. I want my report to say: “We have x donuts”. (Where x is the content of a merge field) (”We have 5 donuts”) However, if there is only one donut, how can I say “We have 1 donut” instead of “We have 1 donutS” If number is Thanks, as always! Quote Link to comment Share on other sites More sharing options...
AHunter3 Posted February 28, 2016 Share Posted February 28, 2016 Create a calculation field, result type "text", definition something like: "We have " & YourMergeField &" donut" & Case( YourMergeField ≠ 1; "s") Put that calc field on your layout instead of the combination of text and merge field that you're using now. Quote Link to comment Share on other sites More sharing options...
languid Posted February 28, 2016 Author Share Posted February 28, 2016 Thank you Ahunter3 for your quick response and easy solution. I'm glad to see you are still here to answer my questions. It must be 10 years, or longer. 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.