Basic Table not keeping Field settings for data types
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sammyb84
8 - Asteroid
‎10-18-2022
01:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to do a couple of things for some output files.
- Needing to format the Headers of certain columns only - I have accomplished this
- I need to output based on File name ( a formula field to create multiple files based on a grouping) - I have accomplished this
- I need to keep the formatting (data types) of all fields ( for some reason the Basic Table is changing the field setting to max of 6 decimal places) - failing
I need to know if there is a way to get around basic table only allowing up to 6 digits or not change this at all
Before Basic Table
After Basic Table
Labels:
- Labels:
- Developer Tools
- Reporting
- Tips and Tricks
2 REPLIES 2
‎10-18-2022
01:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry Nevermind. I changed my data type to string and that solved the problem
grazitti_sapna
17 - Castor
‎10-18-2022
10:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sammyb84 , also if you are using table tool then u can set the decimal places in the configuration as below:
or you can use select tool and change data type to fixed decimal and set it to 6 decimal places as below:
Sapna Gupta