Hello AppSheet Users,
I have been working on an app which registers test results for students. I’ve made a ‘Text’ column which allows the user to enter a percentage that a student got for their test. However once the percentage is entered, the app automatically changes it into a decimal number.
For example, if I entered that a student got 85% on their test, the app would change it into 0.85. How can I make it so that the app leaves the number as a percentage?
Please note that I cannot change the ‘Text’ type column into a ‘Percentage’ type column because if a student doesn’t pass a test, they would have to redo it. This means that we would input both results under the same column. For example, if a student scored 30% on the test and then re-done it and got 80%, we would input it as “30%-80%”. The percentage type column doesn’t allow you to do that so I have to use the text column type.
Any replies are appreciated.