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
Plugins
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
3862
posts
624
likes received
5
followers
Badges
Latest Posts
Re: Trouble with two table references - same settings, different results.
Oh, Davie. You have now experienced another pain point for Ninox users, the Manual or lack of one.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Spam spam spam span spam egg and chips
Sadly Ninox has shown that it doesn't really care. Many of us have complained. Many have gotten responses that they are working on it. And years later we have a new generation of users experiencing…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
"but if an application was to look at a string and see Letter, Letter, Number, Number could it not decide to treat two numbers as a single number and sort acordingly?…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Advice wanted for database design (modelling?)
The question of do you need a separate task table will depend on the data being kept. Are you doing the same task to every photo? Could you be adding more tasks in the future?…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Print View Problem - Select record if
Hi Anna - Just a few questions: I could be wrong, it looks like Journey is a field in another related table to Shipping, what is that table name? What is the name of the reference field that links…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
You have text in your formula so I don't see how Ninox can treat it otherwise. Excel does the same thing. I have a formula that puts together a series of numbers that look like normal numbers, i.e.…
Fred
Fred
4 yrs ago
Get help
Reported - view
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
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
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
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
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
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
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
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
Fred
4 yrs ago
Get help
Reported - view
Re: Ninox cookie policy is bollocks
Yep, I reported this to support already.
Fred
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
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
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
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
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
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
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
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
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
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
Fred
4 yrs ago
Get help
Reported - view
1
135
136
137
138
139
155
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
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
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
