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

How to let a number return text...


Recommended Posts

I've got a field in which I enter a number. In an other field this number should return a text.


'1' should return 'Cash'

'2' should return 'Visa'

'3' should return 'other'



I know there must be a simple calculation to do this...


Link to comment
Share on other sites

Hello dcypher,

Thereare a number of ways to do this, but perhaps the simplest would be:


Choose(NumberField; ""; "Cash"; "Visa"; "other")


I've shown semi-colons as separators above because I assume that being located in Belgium, you will be using a European language version of FileMaker (whereas here in Australia, as in some other parts of the globe, we use commas instead...).

Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use