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
Service status
Plugin apps
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3831
posts
614
likes received
5
followers
Badges
Latest Posts
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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 yrs ago
Get help
Reported - view
Re: Data Entry Validation?
You can add code to a trigger after update at the field level that looks for whatever you want.
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Data Entry Validation?
Looking around I see in the number field you can set a Min and Max value.
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Set another field's value from calculation?
Yeah, formula fields can't modify other fields. They can only do functions to get data. As Steven says, you either have to use a button put it in On Click for the formula field put it in Trigger…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: How to get max value + another column?
@Mike said: Say, is there anywhere where the Ninox SELECT statement is documented with all the clauses? Not really. Documentation is a particular weak point of Ninox.
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Set another field's value from calculation?
What is your code?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Help
Have you tried the Invoice template? If you really need help building a whole database, then you can reach out to one of the many Ninox partners. If you have specific questions then there are many…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to get max value + another column?
Just change the first line to: let i := last(select Cats order by weight) i.cat + " - " + i.WeightDate The change in line 1 adds the order by command so we select all records from Cats then order by…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: All I want for Christmas!
You are correct. I didn't quite process your post. I guess it got me thinking about views and their limitations.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
The ability to change the form you go to when clicking on a record in a view element.
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Understanding file attachment strategies
Just being nit-picky, but Ninox does not use a "foreign key" relationship in the sense of other DBs. You don't pick the field to use as a key. Ninox does it for you when you set the relationship.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Understanding file attachment strategies
I'm wondering why you would have a table that is a child to two different tables. Ninox will allow you to set Composition to Yes on two different reference fields, so that was interesting.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Delete multiple records?
If you need to repeatedly delete the contents of a table then you can put this in a button: delete (select TableName) Of course I would be very careful with this.…
Fred
Fred
3 yrs ago
2
Get help
Reported - view
Re: Delete multiple records?
If you ctrl+click the line numbers in a table view you can select all. Then do it again and select Delete selected rows. You can do this after you filter or if you want to clear your table then make…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Delete multiple records?
Through a script?
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Content Refresh on Dynamic Multiple Select
@Gianluca Open Table1. you will see in the table view that the formula field equals 10 for all records. It is a simple formula: sum((select Table1).Num1) now go into record 1 and change the num1…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
1
126
127
128
129
130
154
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugin apps
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
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
View all topics
