Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Change text field based on a number?


Recommended Posts

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use