New column combining string and double
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi we are trying to create a new field what will output a combination of text & the value in a numeric field.
Example:
New field:
"Record ID -" + [Record ID#]
you would see Record ID - 12345
The only way we can figure out to do this (and not receive a data type error), is to change the [Record ID#] data to string to have this work.
We do not want to change the data type and then change it back.
Is there not an easier way?
Solved! Go to Solution.
- Labels:
- Best Practices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think you are looking for the ToString Function in the formula tool. Something like:
New field:
"Record ID - " + ToString([Record ID#], 0)
Best,
MSalvage
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You need to turn the number into a string if you are going to concatenate it with a string but you can do this on the fly. Use the ToString() function
"RecordID -"+tostring([Record ID#]
