Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Fred
Fred
San Francisco, USA
3130
477
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Changing Owner's e-mail address
contact Ninox at support@ninox.com
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Search for tables with part of their name or with certain conditions
I was wrong about putting the table name in a variable. It looks like you can't.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Search for tables with part of their name or with certain conditions
I'm guessing you will have lots of customers so I think having to manually create a new table for each customer would be more of an burdan than having a large, or very large table.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Help with SELECT query needed!
Hi Agassi - You are correct that you will have to do your View based Treatments if you want to pull individual data from Treatments.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Search for tables with part of their name or with certain conditions
Hi there - You can't create a new table with a button. Which brings me to a question, why would you need a new table for each customer? Maybe if you gave us more detail on what you are trying to…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: End Expected
Looks like you need to close the first IF statment. Plus you need to add a semicolon since you are adding another IF statement after. if 'Avg Price' >= a and 'Avg Price' <= b then'Average Price Val' :…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: When you sum a column how can you set decimal place for the sum value
If it is a text field then you need another formula field that will convert it to a number. If you do a Edit Fields and see a T next to the filed then it is a text field.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Format number as currency
Hi Tom - There is no specific currency field. You just use a Number or Formula field and then set the Number format. You can set it by editing the field and find the setting under Number format.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Help with SELECT query needed!
Hi Agassi - One way is to add a field in your Treatment table that figures out if a treatment needs to be repeated. You can create a field called PastDue and put this in the formula: let x120 :…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Help with SELECT query needed!
Hi Agassi - The reason why there is a difference between = and like is also due to the 1:N relationship. Since you are starting at Patients, Ninox creates an array of all the records linked to parent…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Just for information (web version only)
Yeah another undocumented "feature" of the product.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Multilingual - Function Reference in German Webinar Team
Hi Bill - You need to email support@ninox.com. Ninox does not spend a lot of time on the forums. Except to clean up spam.
Fred
Fred
3 yrs ago
Learn & Share
Reported - view
Re: Update only some some children
if this is a one time action with the same data then you can use the Update Multiple Records function. 1) in your child table your would filter the dataset 2) click on the gear icon and select Update…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How do i create a record on a SubTable button?
Hi Julian - Since Items is a child of Invoice, it seems like doing data entry from your Invoice table would be the better place to start? On your Invoice table,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Filtering a view
You can create two tables or just one dashboard table and create tabs that show just motorcycle and cars. Dashboards are meant as a way to look into your data.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Filtering a view
Have you considered "dashboards"? You would create another Table with only 1 record that shows only in full form view and pulls data from another table so you can look at summary data?…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Case statement
Ninox said they have hired a technical writer a few months ago. I guess they are still working on rewriting everything as we haven't seen any real improvement in the manual.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Case statement
Can you give an example of what you mean by a case statement?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: disappearing formulas
I stand corrected. My brain is bit muddled today.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: disappearing formulas
Unless it is a child table, then Ninox considers any table relationship to be N:N. Like I said eariler, while your data might be 1:N, it could change so Ninox always treats related tables as N:N.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: I add data, save it, then it's disappeared from the table. Tried all sorts of things to get started with this free trial. Help, I've got about 600 customer to enter...this is not working
Did you check that your table hasn't been filtered? Can you post screenshots of the issue?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: YES / NO Default value
So managers do not see the form with the switches? But you want managers to have the ability to change the values on these fields? Do you make a new record every day and you want to carry over the…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: YES / NO Default value
If you want to set the default value, there is an option when you edit the field. Does that not work?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: disappearing formulas
Are you pulling data from another table that is not a child of the current table? Can the other table have a N:N relationship to the current table, even if you only have data that is 1:N?…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: YES / NO Default value
So the only way these fields change from On/Off is for someone to manually do it? There is no formula anywhere that will change their value? If the above is true then I don't see how the values can…
Fred
Fred
3 yrs ago
Get help
Reported - view
1
111
112
113
114
115
126
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics