Fred's Profile | Ninox Community

Badges

Latest Posts

Re: List keeps growing - no scrollbars?
If this is a 1:N view created by Ninox then by default it will grow the list to 6 then start scrolling. If you only want to see, say, 3 then after you have 3 records you can modify the size to see 3…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: add onselect event for view field
Wow, you are correct. That is so weird. I wonder why?
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Accessing a single line item on an invoice
Can you post the code from the new table? Can you let us know the relationship between the new table and Payments?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: add onselect event for view field
Jacques, your DB worked fine. Just to verify that I'm using the MacOS app. I've attached my test DB. It is a mess so: 1) open the System table to load your modules 2) open Table1, select record 1,…
Attachment
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
I can't seem to get it to work. I got the module loaded and I put this in the formula of my view: function onselect(selectedID : text) do Nr := first(select Table3 where Id = selectedID) end;…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
I hate to say this but you have to stop doing Ninox’s work for them. Unless they pay you.
- Fred
- 3 yrs ago
- 2
- Learn and share
- Reported - view
Re: How do i add up totals
@Edward at the top level click on import db and select the archive.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice Field reference in a function
@Gianluca I think your reasoning for keyboard access to reference field is better.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i add up totals
I've mocked up what it could look like. Take a look and let me know if you have any questions. The table monthYear is there so you can create the Month view.…
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: It is posible on Ninox.
Most things are possible in Ninox. How is a record in Avances going to filter the Documentos table to get the correct data?
- Fred
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 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

1 125 126 127 128 129 154

Welcome to the Ninox community

Fred

Re: List keeps growing - no scrollbars?

Re: add onselect event for view field

Re: Accessing a single line item on an invoice

Re: add onselect event for view field

Re: add onselect event for view field

Re: add onselect event for view field

Re: How do i add up totals

Re: Dynamic Choice Field reference in a function

Re: How do i add up totals

Re: It is posible on Ninox.

Re: Dynamic Choice Field reference in a function

Re: How do i add up totals

Re: Accessing a single line item on an invoice

Re: How do i add up totals

Re: Update Yes/No Slider on one table from slider on another

Re: Update Yes/No Slider on one table from slider on another

Re: How do i add up totals

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

Overview