Fred's Profile | Ninox community

Badges

Latest Posts

Re: rsort not working
I guess my coding was off. I can shorten the code and leave out the concat and split. When I do this: let curRec := this;rsort(select TeamResults)[Location = curRec.Location].…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: rsort not working
Sadly it doesn't. This change brings up an empty formula. rsort only works on arrays, thus the many steps to turn the results into an array. I can probably shorten some steps,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
rsort not working

Hi all - rsort is leaving out the first item in my array, see pic. Forumla2 is the the regular sort order and Formula is the reverse sort. As you can see 7 stays in the first position.…
- Fred
- 4 yrs ago
- 7replies
- 412
- Get help
Re: Data type?
Hi Jake - Ninox can handle child and grandchild tables very well.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Style
I see you have a dashboard. Why don't you use that to get your summary? One thing I have learned is that interacting with your data through a dashboard is the way to go.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice triggers twice
What is the code you are triggering?
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: issue trying to get a table view to work in a non related table
Just my two cents, I would encourage the use of relationships(i.e. John's method) instead of select (not saying Steven is wrong as he is just giving an example).…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Changing Owner's e-mail address
contact Ninox at support@ninox.com
- Fred
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Just for information (web version only)
Yeah another undocumented "feature" of the product.
- Fred
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Case statement
Can you give an example of what you mean by a case statement?
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 140 141 142 143 144 155

Welcome to the Ninox community

Fred

Re: rsort not working

Re: rsort not working

rsort not working

Re: Data type?

Re: Style

Re: Dynamic Choice triggers twice

Re: issue trying to get a table view to work in a non related table

Re: Changing Owner's e-mail address

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

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

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

Overview