Skip to main content

Ninox-Documentation

David Irving

David_Irving

16
0
0

Joined: Wed Jul 06 18:29:55 UTC 2022

My Posts

Latest Posts

Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
@Fred it seems you got me a lot closer, but the values are just a tad off. When I just filter the columns for the date and each type of contact value, I get the following.…
- David_Irving
- 11 mths ago
- Get help
- Reported - view
Re: Filtering data based on manual dates entered.
Great success !!!
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Filtering data based on manual dates entered.

Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…
- David_Irving
- updated 1 yr ago
- 2replies
- 81
- Get help
- Answered
- Answered
Re: Formula to Include Multiple Filters from Choice Fields
Ok, I figured out an easier solution when I stumbled upon getting a formula using sum for multiple fields that also included a choice field variable. I needed to be using brackets in the correct way.…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
So I did a long workaround solution. Not the easiest, but all I could do for now. I created another Table with a link and created a Form with all new fields pulling all the data I need.…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
And this formula just gave me the correct amount for Low Risk (Risk Level =1) clients who have Successfully been Sentenced (Termination Reason =1) count(select Clients where 'Termination Reason' = 1…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
With the way the choices are, a user can actually only select one (although its multiple choice in our environment it just does not make sense for the user to select more than one.…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
No, if I put the brackets where you indicate I get errors that explain the expression does not return multiple values. If I put them on the outside of clients I get the total amount of fields...…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
I found a large part of the problem. Not sure why this is occurring. However, when I do a count of just only the successful selections for termination reasons, I get a result of 1.…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
To make things easier...we can even remove the status field from the entire field as termination reasons would only be selected if they were closed anyway.
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Formula to Include Multiple Filters from Choice Fields
Well, that now gave me 44, lol for the second code and it gave me 153 for the first code. We can throw the first formula out the window, because all that is doing is just overall counting all Low…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Formula to Include Multiple Filters from Choice Fields

Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…
- David_Irving
- updated 1 yr ago
- 13replies
- 354
- Get help
- Answered
- Answered
Re: Creating a Button That Goes to Table with only Linked Records
Alright, already tested. Added your server code to @Alain Fontaine 's streamline'd code and it works fairly well. Takes about 3-4 seconds to process the request,…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Sorry @John Halls I was dealing with COVID and have just got back to this. I am going to try some of these solutions and get back to you. Thanks so much!
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Sorry @John Halls I had difficulty understanding the applicability to my specific problem. I want this to be for every single client record as every single client record has "chrono" records which…
- David_Irving
- 1 yr ago
- Get help
- Reported - view
Creating a Button That Goes to Table with only Linked Records

I have been searching endlessly and can't find the correct formula. I want to create a button that when you click on it, it will display the child table but only the linked records to that specific…
- David_Irving
- 1 yr ago
- 26replies
- 568
- Get help

Back to top

Ninox-Documentation

Overview

View all topics