Fred

San Francisco, USA

3614
570
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Set another field's value from calculation?
What is your code?
- 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
- 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
- 3 yrs ago
- 1
- Get help
- Reported - view

1 117 118 119 120 121 145

Welcome to the Ninox community

Fred

My Posts

Re: How do i add up totals

Re: How do i add up totals

Re: Accessing a single line item on an invoice

Re: How do I perform an update?

Re: How to sort on multiple columns in interface?

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Views are not saved when I close database

Re: Views are not saved when I close database

Re: How to sort on multiple columns in interface?

Re: Conceptual Problem.

Re: Switching to next year

Re: Data Entry Validation?

Re: Data Entry Validation?

Re: Set another field's value from calculation?

Re: How to get max value + another column?

Re: Set another field's value from calculation?

Re: Help

Re: How to get max value + another column?

Overview