Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and Share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Sean
Sean
1762
79
0
Joined: Tue Jul 31 23:45:13 UTC 2018
Follow
Coding Dart/Flutter in my spare time
My Posts
Latest Posts
Re: Converting min/mile
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…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Converting min/mile
I'm sure there's another way, but this works... if Miles != (null or 0) thenlet myInterval := number(TimeInterval) / 60000 / Miles;let myMin := round(myInterval);let mySec :…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Change
My wife heard me chuckling and she wanted to know what was up. It wasn't until I explained the background of this thread that I caught the four-twentys reference!
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Change
I assume you meant "Eighty-Nineteen" for "Ninety Nine". I found this, http://www.frenchtutorial.com/en/learn-french/counting/70-99, is it what you want?…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Group by week
Hello, I find it works Monday-Sunday. I don't know it the date format makes a difference. Here is a link to the Scripting Functions...…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: How would I populate a view with a 3 table join
"You're so analytical! Sometimes you just have to let art... flow... over you.". Hopefully you'll recognize the quote and that it's all in fun. When I started using Ninox, it was for my business,…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: How would I populate a view with a 3 table join
Nice solution! So, now I'm curious. Since you have come up with this workaround, are you satisfied with steps necessary to make it work or would you like the View to support JOIN commands directly?
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Mass Update / Calculated Value
At a glance, you have it backward. Should be... myTable1Id := (select Accounts).Id and for j in (select Assets), etc. https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language I…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: How would I populate a view with a 3 table join
As far as I know, Ninox does not support JOINs yet (the join() function is not the same as JOIN). If you want to do something similar in a View layout element,…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Mass Update / Calculated Value
Are you trying to create a Reference between tables? If so, take a look at this...…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Mass Update / Calculated Value
Could you explain what "connection" means. You can simply select a group of records that match your criteria like this... let t := this; select YourTable where Name = t.FirstName + " " + t.…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: How do I select the first record which meets a condition
Sorry, I just focused on the syntax. If you want the latest, you would use last() instead of first(). last((select Signals where Pair = myPair) order by 'Date / Time').…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: How do I select the first record which meets a condition
Try this... first(select Signals where Pair = myPair).'Date / Time'
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Poll: are you using the visual or the text editor in formula editing?
Karen, Just curious about which formulas you use the Visual editor for.
Sean
Sean
5 yrs ago
Learn and Share
Reported - view
Re: Concat Formula
Life would get pretty dull if we weren't.
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Concat Formula
Yeah, I think the only difference between concat() and join() is that join() let's you use a custom separator.
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Concat Formula
For what it's worth, it looks like the formula is converting an array to a string then back to an array and then back to a string. I'm pretty sure you can just use join() without the split() and…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Poll: are you using the visual or the text editor in formula editing?
Steven, Good question. I started with the visual editor before I found the language reference page. Now it's exclusively... Text
Sean
Sean
5 yrs ago
Learn and Share
Reported - view
Re: Show date when # turns < than #
Hi Sarah, You would need to add a status date field that would be updated based on a trigger and then you could do something like this... let AA := sum('Seamless QTY on Hand (Bags)') + sum('HELP QTY…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Can you do secondary sorts within a view?
Simon, Jörg's formula worked for me, but you could also try it like this... number(DateField) + NumberField
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Platforms
Paul, I have to assume you hadn't checked pricing on FileMaker before your last post. Based on your exchange rate that would put the price at over $800 which would be difficult to justify if you're…
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Platforms
https://ninoxdb.de/en/products
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Formula for finding sum based on a condition
This formula works... let t := this;sum((select 'YourChildTable' where 'Invoice #' = t.'Invoice #' and not number(Choice) = 3).Amount)
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Formula for finding sum based on a condition
Is the formula field in the parent or child table?
Sean
Sean
5 yrs ago
Get help
Reported - view
Re: Change field "Show As"
Yes
Sean
Sean
5 yrs ago
Get help
Reported - view
1
41
42
43
44
45
71
Ninox-Website
Overview
Learn and Share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
My wife heard me chuckling and she wanted to know what was up. It wasn't until I explained the background of this thread that I caught the four-twentys reference! 
Life would get pretty dull if we weren't.