Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Advice wanted for database design (modelling?)
You can view your pages from either the Folder table or the Pages table. You said, "I want a database to help my workflow, checking off tasks as they are done." That is a good use of a database.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
You are running into the issue of how Ninox sorts text vs. numbers. Your formula is considered text by Ninox so it sorts all the 1's then 2's. To fix this you need to add a zero in front of single…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Problem with syntax and filling array
Re-reading your post it looks like Customers is a reference field in whatever table you are in. Which means you don't need to do a select statement to get data from the Voornaam field if you want to…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Problem with syntax and filling array
You are very close to getting Ninox. You wrote: (select Customers).Namen.Voornaam like Customers.Namen.Id = 4 It could be written: (select Customers where Namen.Id = 4).Namen.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: I cannot edit a database in Ninox Mac app
Hi Philippe - The Mac app version is not really a multi user/device database creation tool. The app version allows one device to be the owner of the DB and thus the only device that can edit.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: simple Payment receipt table setup
Which template did you end up using? I ask so I can take a look at it. Which table are looking at to see what you got paid on a particular day?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: simple Payment receipt table setup
Have you looked that the invoice or accounting DB template that is built into Ninox? When you create a new DB you can select either template.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Image copy from Child Table to Parent Table
I just tried it in a formula field and just adding a column in table view and both did the same thing. Can you post your code?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox cookie policy is bollocks
Yep, I reported this to support already.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Stuck on simple multiple if/else
Hi Robert - Since Rating is a choice field, Ninox by default uses the number assigned to each choice. So if the choice 1 is "Not much" and choice 2 is "Good" and choice 3 is "Significant" then you…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Image copy from Child Table to Parent Table
Is there a reason you need to copy the image from Item Image table to Master Item table? I'm guessing they are linked, so you can always just reference the latest image.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: 4 tables - procedure
I'm confused. You posted this: StatusTbl rows A1, 1.1.2021, 65 kWh A1, 1.2.2021, 86 kWh Which made me think Status held kWh data. Anyways, so let me see if I understand what you want.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: 4 tables - procedure
You show that the Status table stores kWh data but you don't give us the name of the field. How are records in Status related to Period? You show a field called Date in Status,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: 4 tables - procedure
You said PeriodName is related but you didn't claify how (through a reference field or dynamic choice). We'll go with reference for now. If you select a record in your Period table do you see a View…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: 4 tables - procedure
Just to verify there is a reference field, called PeriodName, in Consumption to Period. Or is PeriodName a dynamic choice field that pulls data from the Period table and displays the PeriodName.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Formula to display an array of choices from subtable
Hi Giovanni - As you can see there are some limitation to how you show fields. If you are in TableA and want to show all related records in TableB in your Table view then you need to have a concat as…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How to sort SubTable fields in summary formula field in MainTable
Hi John - You can use the order by function. If you have a select statement then you can add order by at the end. select VideoBeats order by BeatSequenceNo Let us know how it goes.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: I can't create a new record in one of my databases
I would suggest you contact Ninox directly at support@ninox.com. They do not check this site.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: product(array)
I'm not sure what you mean by "all the fields"? How many fields are there in each record? Why do they need to be added together outside of the record? Thinking out loud,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: product(array)
If you have a selection of records and not just the data from 1 field, then you can do: sum(arrary.fieldname) to find sum of the specific field.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: product(array)
Yes you can use sum(array). You can also do: sum(array)avg(array)first(array)last(array)min(array)max(array)cnt(array) or count(array) It is in the manual: https://ninox.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How do I install Ninox on a new computer?
If you bought it before then you can just download the app again from the Mac App Store.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Display quarterly results
Yes, sorry. I was thinking quarter not yearquarter. Give it a try and let us know.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Display quarterly results
The formula is working exactly like Steven said it would, see his ps comment. If you want to create a formula that finds the current year quarter 1 then you can change either: let q := 1;…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
I'm a bit unsure what you want to happen. Maybe if you explain the work flow you want to happen we can help figure out ways to do it.
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 134 135 136 137 138 154

Welcome to the Ninox community

Fred

Re: Advice wanted for database design (modelling?)

Re: Sort properly - 12 is less than 2. I don't think so!

Re: Problem with syntax and filling array

Re: Problem with syntax and filling array

Re: I cannot edit a database in Ninox Mac app

Re: simple Payment receipt table setup

Re: simple Payment receipt table setup

Re: Image copy from Child Table to Parent Table

Re: Ninox cookie policy is bollocks

Re: Stuck on simple multiple if/else

Re: Image copy from Child Table to Parent Table

Re: 4 tables - procedure

Re: 4 tables - procedure

Re: 4 tables - procedure

Re: 4 tables - procedure

Re: Formula to display an array of choices from subtable

Re: How to sort SubTable fields in summary formula field in MainTable

Re: I can't create a new record in one of my databases

Re: product(array)

Re: product(array)

Re: product(array)

Re: How do I install Ninox on a new computer?

Re: Display quarterly results

Re: Display quarterly results

Re: Adding links to records in the child table on the form using a script.

Overview