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
3421
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Dynamic Choice Field reference in a function
@Gianluca You should add that request to be able to use a keyboard to access a reference field to the Christmas Wish List post. I too wish that was possible.…
Fred
Fred
2 yrs ago
2
Get help
Reported - view
Re: How do i add up totals
How about we start at the beginning so we can walk you through how to setup your dashboard. Your initial post lists a lot of things you want to see. Can you pick one summary data you want to see and…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Accessing a single line item on an invoice
Are you saying that the code you posted above is NOT working?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How do i add up totals
I'll use my sport DB as an example. Here is a pic of the top part of one of my dashboards: I track two different show jumping leagues in the same DB, so the first field allows me to change leagues.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Update Yes/No Slider on one table from slider on another
In the Trigger after update of Production Complete field, you can put something like: if 'Production Complete" then 'Active Orders'.'yes/no' := true end Line 1 checks the Production Complete field…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Update Yes/No Slider on one table from slider on another
First question, how are the list of projects table and Active Orders table related?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How do i add up totals
Hi@Edward I don’t know how many hours you spent with Ninox, but like any DB you have to spend some time with it to understand the structure and language. if you decide to try again.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How do i add up totals
Yeah, sadly Ninox does not allow you to convert fields from one kind to another. You can simply just create a new formula field and put this in the formula:…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: How do i add up totals
Sounds like you are ready to learn dashboards. Take a look at this video and give it a try and then come back with specific questions. https://www.google.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Accessing a single line item on an invoice
@Roger It would be helpful if you can provide the code you are using and a bit of background to the tables and fields you are using.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How do I perform an update?
Hi Marcia - To find your version number: open the Applications folder and find the Ninox app click once on the icon and then type cmd+i a new window will open showing you info about the app Under…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to sort on multiple columns in interface?
Sadly, Ninox can only sort columns one at a time in table view. You can create a new field that combines other fields that would allow you to sort by multiple fields, but not multiple columns.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
1) click on the + and type in a name for the view and select form 2) ctrl+click on the all view and select Delete View now you only have 1 view. Also dashboards only have 1 record so there is no…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
@Alain Fontaine Thanks for the update. Maybe one day my little brain will absorb this new way of thinking.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
If this is from the DB that I modified then I made FechaCorte into a Dashboard so there is only 1 view and it is a form view. In a dashboard there is no need for a table view so I got rid of it.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
@Rafael What table are you talking about? I see a view called Disciplinas in a form called Fechacorte in a table called Fechacorte.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
@Alain Fontaine I knew someone would come up with something more flexible. If you have time, can you help me wrap my head around using the cnt function to do a selection.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
I was wrong about the dynamic multichoice field. When you use number() it does not give the record Id number when you select multiple choices. FYI, if you use numbers (ending with "s") then you an…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
Ok, so you are switching on the field Busqueda. Is that a simple choice field? or a Dynamic choice field? If it is a simple choice, then the choice numbers are there when you edit the choice field.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search with Multiple Choice problem
Hi Rafael - Are you saying that you should have found more than 4 records when searching: 'Tipo Documentos'.Clase = "Plano" and 'Ganado REAL' = null When you say:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Views are not saved when I close database
I to use the Mac app. I'm running v3.5.14. I went back to test and on DBs saved to either iCloud or local I was: 1) able to create a view in NON admin mode and it was saved when I exited the DB and…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Views are not saved when I close database
Just make sure you are in admin mode before making changes. I have not had any issues with changes not being saved while in Admin mode. I think it is a bad UI design that lets you do something but…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to sort on multiple columns in interface?
When you talk about "sort items" are you talking selecting one column for Ascending and another for Descending?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Conceptual Problem.
If you don't mind telling us what you ended doing and how it is working for you.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Switching to next year
If you want to affect all records in table you have options: 1) You can select update multiple records under the Gear icon and then select Assign Calculated value then put this in the formula:…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
109
110
111
112
113
137
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
