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

How to let a number return text...


dcypher

Recommended Posts

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

example:

'1' should return 'Cash'

'2' should return 'Visa'

'3' should return 'other'

...

 

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

:rolleyes:

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