Fred

San Francisco, USA

3602
566
5

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

My Posts

Latest Posts

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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox cookie policy is bollocks
Yep, I reported this to support already.
- Fred
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Display quarterly results
To build on Steven's comments, if you have a formula field called quarter that has: quarter(Factuurdatum) Then you can find all quarter 1 records regardless of year by using:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
Are you talking about a record in the child table? If you have created a record in the child table first, then you should see the parent table field and from there be able to select which record from…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: COMPARAR SI HAY OTRO VALOR IGUAL EN UN CAMPO DE UNA TABLA
Sounds like you are using the cloud version. Alerts do no work in triggers, becausee triggers happen on the server side. If you put the code into a button then you will see an alert,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Issues with switch statement sintaxe
I just upgraded to 3.5.8 and this is what happens with me: Before: After:
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 125 126 127 128 129 145

Welcome to the Ninox community

Fred

My Posts

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.

Re: Display quarterly results

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

Re: COMPARAR SI HAY OTRO VALOR IGUAL EN UN CAMPO DE UNA TABLA

Re: Issues with switch statement sintaxe

Overview