Skip to main content
Forum
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
Updates & status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Ninox 4
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3939
posts
639
likes received
5
followers
Badges
Latest Posts
Re: How to write code for data filtering?
@我是我的我 said: is there another way to achieve the functionality I mentioned by only editing the code? Using the DB you attached, if you wanted to search for only two dates in the Data table you could…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Delete view tabs
@Kate What version of the app are you using? I'm on 3.13.6 and have no issues. I can two finger click a view or I can control click on a view and I get the submenu.
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Silly me. I didn't follow the docs myself. 😄 You can only use numbers in datetime(). So you have to do a bit of math to get the hour and minutes into a human readable form.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: adding eg 7 days to a date+time field
That is because you didn’t tell Ninox what time to add. Try: date+time field := date(year(date+time), month(date+time), day(date+time) + 7,time(date+time); Here is the documentation for datetime().
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic printing and join tables
@AlexisO i’m sorry. i thought you were going to use a json so you can use dynamic printing. what is still not working for you?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Print Report Layout
I just updated and was able to access the print layout in both local DB and iCloud DBs.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Avoid new records
@Pascal P. It seems like it is a bit late to pop up a message after the new record is created, but let me answer your question. Be aware that once you move your DB into the cloud for multi-user…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Avoid new records
@Pascal P. Is this in a button? Is this in a dashboard? Or in a data table? Are you checking another table or the current table?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic printing and join tables
@AlexisO , if you were able to get your question answered, please mark the post answered when you have a moment.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to write code for data filtering?
@我是我的我 said: I also need to include the day in the date, that is, for example, 2024/9/13 It is hard to keep up with the changing requirements. 😉 If you need the date from a date + time field then…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: View of table sorted by date within groups
@gyannes When you get a chance, please mark the post answered.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic printing and join tables
@RoSoft_Steven If they can imbed Carbone Studio into Ninox then it will make the whole process easier. For those who haven't tried it, here is what studio looks like. It is free so give it a try.…
Fred
Fred
2 yrs ago
2
Get help
Reported - view
Re: View of table sorted by date within groups
@gyannes try this: let allPlayers := (select Players); let newArray := (select Rounds)[= -1]; for player in allPlayers do let a := (player.handle.Rounds order by today() - 'Date Played'); let b :…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to write code for data filtering?
@我是我的我 said: I only need to use code to filter and display as 2024/9 and 2024/10. How can this be achieved? Look into the yearmonth() command. Create a new formula field with the command.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to write code for data filtering?
@我是我的我 1) try: let getCopy := (select Data); let Onlyname := unique(getCopy.name); let newData := (for loop1 in Onlyname do let TotalSales := sum(getCopy[name = loop1].…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to write code for data filtering?
The second one is a filtering question, so you could do something like: [datefield = date(2024, 2, 9) or datefield = date(2024, 3, 1)]
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to write code for data filtering?
Look at this reply to see an example of order by. Look at the full post to see an example of slice(). If you still need help, please post your code?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: View of table sorted by date within groups
@gyannesThe -1 tells Ninox to not find anything but initialize the variable to this table. It could also probably be rewritten to be: let newArray := Handle.Players.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Enterprise plan
I would be surprised if they removed the minimum user amount. I thought it was 5 users. If you want a private server without the minimum then Nioxus offers that.
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: View of table sorted by date within groups
Try the following for your view element code: let allPeople := (select People); let newArray := (select Rounds)[= -1]; for person in allPeople do let y := ((Handle.Players.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Delete view tabs
@Mel Charlesthrough the touch interface there is no right click. i have to check later on the keyboard.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic printing and join tables
@Mel Charles don't disagree there. Their support is woefully inadequate. If Andy from Nioxius is correct, Ninox's support is shamefully understaffed for a company with enterprise aspirations.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Delete view tabs
Welcome to Ninox. The major difference is that Ninox is based on html, so thus text, unlike FileMaker. It was developed to be browser friendly from the get go.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: View of table sorted by date within groups
@gyannes said: I would change h to be let h:= People.Handle. Does that mean you have a reference field on the same table to People? If so then can you do: let d := People.Handle.Players.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic printing and join tables
@Mel Charles According to Nioxius, Carbone is the print engine. Ninox is not going to build anything else.
Fred
Fred
2 yrs ago
Get help
Reported - view
1
32
33
34
35
36
158
Ninox-Website
Overview
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
History
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
Ninox 4
View all topics