Fred

San Francisco, USA

3692
590
5

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

My Posts

Latest Posts

Re: New to Ninox - How to create and link a "lookup" table?
That is true that there is data that is specific to the type of media. I was just thinking ahead that you may want to add a new field in the future and you don't have to do it to three different…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: New to Ninox - How to create and link a "lookup" table?
Hi there - May I suggest that you not create three tables for what is basically similiar data (disc name, production date, artist, etc). Maybe create a table called media that would have a record for…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Loops syntax
Hi Greg - To build on Steven's great suggestions. The item function takes an array then pulls the value from the position that you set after the comma. For example, if my array is (1,2,4,…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Formula to calculate the duration in Hours and minutes of a work
If you use a Date/Time field, Ninox does the math properly. I have a test DB with a clockIn field and clockOut field that are Date/Time fields. Then I have another formula field that takes clockOut -…
- Fred
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: rsort not working
I just realized my mistake in the formula 7. I forgot the ( ) for the rsort. Once I add that in, all is well. Thanks.
- Fred
- 4 yrs ago
- Get help
- Reported - view
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
- 406
- 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

1 133 134 135 136 137 148

Welcome to the Ninox community

Fred

My Posts

Re: New to Ninox - How to create and link a "lookup" table?

Re: New to Ninox - How to create and link a "lookup" table?

Re: Loops syntax

Re: Formula to calculate the duration in Hours and minutes of a work

Re: rsort not working

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

Overview