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
Fred
Fred
San Francisco, USA
3381
534
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: I Need the sum of 'total Time' for each time I change Client Choice
oh, yes forgot about that. Maybe try: let cc := 'Client Choice'; let date := Date; sum((select 'Booking Time' where Code = cc and Date = date).'Total Time') Or you can do it through the dC field:…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: I Need the sum of 'total Time' for each time I change Client Choice
maybe something like: sum('View by Choice Client'.'Total Time')
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Is it possible to create a button that opens the corresponding table by inputting the table name?
Sadly there is no direct way of doing that. The table names we assign are like domain names, they are just a front for the real name that is assigned by Ninox.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Count of records/table per day
@Christoph said: I think there should be a function to group in a select statement! I don't quite understand why you would need to group in the select. The current method gets all of the data that…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Count of records/table per day
@Christoph I changed the field from sum to average and got: Here is the change in the Edit Columns: I changed the Name and Footer.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Importing Data into a Dynamic Choice Field
@Dave Irving Sorry for not being very clear. I'm talking about importing into the root table of the dynamic field. It is a table so you can do all regular table functions.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Importing Data into a Dynamic Choice Field
Since dynamic fields are based on tables, you just need to import the data into your tables. You can tell Ninox which field is the key and it won't import data that is already there.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Count of records/table per day
@Christoph If you want to do charts then you probably don't need to create any more fields. I don't use charts but was able to create the following very quickly, after watching a Ninox video.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: moving database from one account to another
@AlexisOYeah that is a very limiting "feature" of the starter edition. If you have access to a MacOS computer you can download the app and there you can download ("export") a copy of your DB.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: CSS Framework & Ninox
Very interested in this topic as I've just started using html in my forms. What I found out that is that I could only reliably modify text and format when inside a table.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Why does NINOX recommend entering data from a form?
Not to throw too much at you, but when you get the a chance you should see if your brokers allow API calls so you can access your brokerage data in Ninox (if you have a public cloud account).…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Why does NINOX recommend entering data from a form?
@M_ichel said: BUT. Do I really have to model the data this way? You can model DBs any way you want. Model A makes the most sense, to me, even if you don't care about what is happening at the Broker…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Why does NINOX recommend entering data from a form?
It was only till v3.8 that you could enter data in other ways beside a form. So yes, you can double click on a space in a column in a table view and you can enter data.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Count of records/table per day
@Christoph Sander said: The count formula is to be run on a dashboard. On your dashboard, I'm guessing you want a table of days of the month in one column and a count in the other? Or something else?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Count of records/table per day
@Christoph Sander said: Then, I'd like to check how many records of 'entries' per i. We all need a nudge in the right direction. My next question is where is this formula happening?…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Count of records/table per day
Can you post your code that you are working with?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: MacOs Ventura and date format issue
@Youri Penders They also did this with WiFi networks order. You use to be able to change the join preference of WiFi networks. That is now gone in Sonoma (v14).
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Script for Button for next record, order not ID
@LionKingIsBack DeliveryDays and Select a Day are field names. I created DeliveryDays to make it easier to search on which days has a delivery. You currently have 7 fields (for each day of the week)…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Version 3.11
good question.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Ninext project
@Patrick W. I don't see any major issue on my end. The one thing that is noticable that the script run time at login is slower. Averages 0.4 secs (according to Ninext. Around 7 seconds in real time.…
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: A trip down memory lane
@John Halls I'm not sure I understand my system half the time.
It is interesting to go back and see how much I didn't know.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: A trip down memory lane
Here is pic of how I was entering data into my Results table in April of 2020: As you can see I had manually select City, Team2, Riders, Horses. This league had 16 teams at each event with two riders…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Scripting a button to print text from a choice field?
What table are you creating the button in? What table is the address data coming from? Are you copying the data into fields with the address data? What print style are using, Old Ninox or Dynamic?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: eviter les doublons
You can look at this post. Can you post some of the code that you have tried?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: conditional unique() in column
@Christoph SanderSo you want the view element to only show 1 instance of each value in text_c? Maybe the view should be based on value of text_c?
Fred
Fred
1 yr ago
Get help
Reported - view
1
40
41
42
43
44
136
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
It is interesting to go back and see how much I didn't know.