changing field types from user input
Is there a way to change a field type based on data in another field? My app tracks performance on service level agreements, and the metric can be either a percentage, a time in seconds or a number...
Forum Discussion
solution I'm going with then is to change my [standard] field to a numeric and enter everything as a decimal (boolean are 1 and 0, 99.95% is 0.9995, etc.) and using mid(totext([standard])) to grab digits at certain places and insert the "." and "%" where appropriate.
(I am of course using a case function for boolean, integer or percentage, just working on the percentage part now)
The problem I'm running into now is that the system isn't keeping leading/trailing zeroes, so percentages that are single digit or have no value after the inserted decimal point will not show up properly. Is there a way to tell Quickbase that I need to keep all the leading/trailing zeroes on a field?
(I am of course using a case function for boolean, integer or percentage, just working on the percentage part now)
The problem I'm running into now is that the system isn't keeping leading/trailing zeroes, so percentages that are single digit or have no value after the inserted decimal point will not show up properly. Is there a way to tell Quickbase that I need to keep all the leading/trailing zeroes on a field?