Here’s what I want to show in my app:
Without going into too much detail I can say that it shows that the total time is composed in part of 72 units of 5 minutes each. When I first wrote it I used “5:00” in part of the CONCATENATE() expression, but that came out as follows:
Fixing the problem wasn’t too hard. I just changed " x “,“5:00”, to " x 5:00”. Changing it to “5:”,“00” also worked. Still, is this a bug in the platform that should be fixed or is it supposed to be this way?
See some explanations about converting what AppSheet considers non-textual values to text: Text expressions - AppSheet Help.
You can see the specific behavior you’re observing by reviewing the TEXT function, which behaves differently depending on whether the first argument is detected as a time value.
Wow! It still seems odd to me but now I guess I know that even if I put something in quotation marks inside a CONCATENATE() expression, it may not be rendered as I expect. Thanks!
In an expression, “5:00” is interpreted as a Time value, which has an internal representation of 05:00:00. When you use CONCATENATE() on a non-(Long)Text value, the value’s internal representation is produced. As you found, to avoid this behavior, you have to modify the value so it doesn’t appear to be a Time value.
So this is intended and expected behavior.
Thanks!
