Fred

San Francisco, USA

3602
566
5

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

My Posts

Latest Posts

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
- 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
- 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
- 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
- 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
- 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
- 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
- 3 yrs ago
- Get help
- Reported - view
Re: Just for information (web version only)
Yeah another undocumented "feature" of the product.
- 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
- 3 yrs ago
- Learn and 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
- 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
- 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
- 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
- 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
- 3 yrs ago
- Get help
- Reported - view
Re: Case statement
Can you give an example of what you mean by a case statement?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
I stand corrected. My brain is bit muddled today.
- 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
- 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
- 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
- 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
- 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
- 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
- 3 yrs ago
- Get help
- Reported - view
Re: Information is not displayed windows computer
So is everything OK now? It looks like your Ninox subscription plan is not active so I wouldn't expect things to work properly.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: YES / NO Default value
Can you be a bit more specific? Nothing changes unless you tell it to so a bit more info would be helpful.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Information is not displayed windows computer
Can you post a screenshot?
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 130 131 132 133 134 145

Welcome to the Ninox community

Fred

My Posts

Re: Help with SELECT query needed!

Re: Search for tables with part of their name or with certain conditions

Re: End Expected

Re: When you sum a column how can you set decimal place for the sum value

Re: Format number as currency

Re: Help with SELECT query needed!

Re: Help with SELECT query needed!

Re: Just for information (web version only)

Re: Multilingual - Function Reference in German Webinar Team

Re: Update only some some children

Re: How do i create a record on a SubTable button?

Re: Filtering a view

Re: Filtering a view

Re: Case statement

Re: Case statement

Re: disappearing formulas

Re: disappearing formulas

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

Re: YES / NO Default value

Re: YES / NO Default value

Re: disappearing formulas

Re: YES / NO Default value

Re: Information is not displayed windows computer

Re: YES / NO Default value

Re: Information is not displayed windows computer

Overview