Another Duration Expression Question - Covert Text Value to Duration?

[mykrobinson]

In the call/contact log app i'm creating, I have added "Text" as a communication method, and I want to duration to automatically be set to one minute if Text is the method.

[Duration] is a "duration" column type.

How do i properly convert the value that i am wanting to the "duration" type? What's the proper method for correcting this expression?

Thanks

[Suvrutt_Gurjar · Accepted solution]

Please insert "000:01" in place of "0:01" in the expression.

[mykrobinson]

And that worked...... I don't think i ever would have figured this one out, can you explain why this works? I assume the answer is just "syntax," but if you can point me towards the documentation that would have lead to this discovery, i'd appreciate it.

[mykrobinson]

and one more question 🙂 What is the reason for this error:


What i'd ultimately like to do here is also hide the End Time field if "Text" is selected, and of course, have the duration field accept the assigned value of one minute, regardless of the start time.

[Suvrutt_Gurjar]

Hi @mykrobinson ,

Are you still getting the error as shared in the screenshot? If so , please try ("9:40"-"9:39") in place of "000:01"

[mykrobinson]

Now that you mention this, i'm not sure why it never dawned on me to just enter some math that produced the desired result 😂

I will try that, thank you

[Suvrutt_Gurjar]

You are correct on the syntax part. AppSheet distinguishes duration by an extra "0" 

So  "09:15" denotes  a time value but "009:15" denotes a duration.

Some examples in the article below.

https://support.google.com/appsheet/answer/10107326?hl=en