Converting min/mile

(number('Time field') / 60000) / 'Miles'

Birger

I'm sure there's another way, but this works...

if Miles != (null or 0) then
let myInterval := number(TimeInterval) / 60000 / Miles;
let myMin := round(myInterval);
let mySec := substr(text(myInterval - myMin), 2);
myMin + "m " + mySec + "s"
else
"0m 0s"
end

I used a TimeInterval field instead of a Time field and a Number field for miles. I think the Ninox Team should include links to frequently accessed parts of the manual on the forum page so that users who are unfamiliar with the site can navigate to those sections first if they are inclined. Here is a link to the language reference page...

https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

No, you put the code in a Formula field. I put the time in a TimeInterval field. It wasn't clear to me from the previous posts which type of field was used to store the time value and I wanted to be clear about which type of field I used to store it.

Most of my understanding Ninox and other languages is by taking the time to read and practice. Coding is my avocation not my occupation. ;)

I see there are issues with my formula and that is partly due to the inconsistent treatment of the TimeInterval field. If I use the "3867.37m" Number format for the TimeInterval field, seconds are (base 10) and not the expected (base 60). I'll look at it more when I can.

Which field type are you using for the raw time data?

Hi Pete, I think I've gotten the kinks worked out. This takes the time from a Text field and mine is named TextTime. You can use a different field name, just replace TextTime in the code and use your field name.

"// Get the minute/second separator index";
let mssIndex := index(TextTime, ":");
"// Convert minutes to seconds and add to seconds";
let ttlSec := number(substr(TextTime, 0, mssIndex)) * 60 + number(substr(TextTime, mssIndex + 1));
"// Divide total seconds by miles if miles isn't 0, otherwise, return TextTime";
if Miles != 0 then
let divTtlSec := ttlSec / Miles;
"// Calculate divided minutes";
let divMin := floor(divTtlSec / 60);
"// Calculate remaining seconds. Need to test for single digit seconds, e.g., :2 and multiply by 10";
let rmnSec := round(divTtlSec - divMin * 60, 2);
let dgtCount := length(substr(TextTime, mssIndex + 1));
if dgtCount < 2 then
rmnSec := rmnSec * 10
end;
"// Build the interval time string";
divMin + ":" + if rmnSec <= 9 then "0" + rmnSec else text(rmnSec) end
else
TextTime
end

Pete,

You're welcome. I really enjoy coding in Ninox and I think it's easy to be productive quickly with the scripting language. Yes, variables can be declared as you go but they do have scope. I'm pretty sure a variable declared inside a loop can't be accessed outside the loop. I suggest you replace this line...

if Miles != 0 then

with this...

if Miles != null and Miles != 0 then

You can also add validation and formatting to fields by clicking on "More options" and entering code in "Trigger after update". Here's some code I added to TextTime...

"// Test for colon and add :00 to end of TextTime if only minutes are entered";
if index(TextTime, ":") < 0 then
TextTime := TextTime + ":00"
end;
"// Test colon index for position 0 and add '0' to beginning of TextTime if true";
if index(TextTime, ":") = 0 then
TextTime := "0" + TextTime
end;
"// Test length of string after colon - truncate if greater than 2, add 1 '0' if 1, add 2 '0' if 0";
let secLength := length(substr(TextTime, index(TextTime, ":") + 1));
if secLength > 2 then
TextTime := substr(TextTime, 0, index(TextTime, ":") + 3)
else
switch secLength do
case 0:
TextTime := TextTime + "00"
case 1:
TextTime := TextTime + "0"
end
end

Good luck and have fun :)

Hi Pete,

it took me 3 months to convert old Filemaker (4D, Ms Access...) skills into Ninox ones...

Hold on !!

Marc

To Pete & Marc,

I'm an old computing brain, as well, with, I'm afraid, bad habits from previous 4D ACI developments…

We did use a lot variables and personalised functions to build a true RDB till we got a end-user interface with menus.

I first thought my experience with 4D would help in Ninox. But I'm feeling more and more lost… 

For instance, the FORMAT function is not working the same and I can't get what I was expecting.

And I am still looking for a text function which gives us the length of a caracters' text chain! 

I can't either find the explaination of the function INDICE in the 122 pages documentation ?!

We don't even know to which version of the Ninox app this documentation is refering. There is not even publication date on top of it.

And I do agree that it is a big loss of time to ask other people here these simple questions which should be accessible through a good documentation or wiki source.

I admit you, people of Ninox are reactive, and very kind in the way you try to bring your help and skills to us. 

But we are more than one to wait for a really structured and documented… documentation !!

Please listen to our demand.

Hold on ! and kind regards

D'Jack

@Sean

I've just tested something... Instead of

if Miles != null and Miles != 0 then

try

if number(Miles) != 0 then

Regards John

Hi John,

Thanks, I wasn't aware of that. It works for me, but I don't think jessica will get it since she is more interested in glamour advice. I'm surprised more spam posters don't use this method since Ninox doesn't usually delete this type of post.

Regards Sean