Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3421
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: sum results of this year
I'm guessing you have a date field in the Prestaties table. If so then you can try: sum(Prestaties[year(datefield) = year(today())].KB213) This will always get records where the year of the…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Using if statements and date calculations to display yes or no based on variable.
I was thinking about a similar situation as I was creating my test DB. I wondered if you might need to track different vaccines by manufacturer. Then of course even within the same product there are…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Using if statements and date calculations to display yes or no based on variable.
A handy date command is days(date1,date2). This will return a number that a normal human can understand. If you create a formula field called DaysSinceLastVax you could write something like:…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Suggestions from May 2022
The ability to search your fields in the Edit Fields window. If you have a large quantity of fields then trying to find them can prove challenging since we can't sort them.…
Fred
Fred
2 yrs ago
3
Learn and share
Reported - view
Re: Suggestions from May 2022
Don't remember if this made the Christmas wish list. The ability to modify multiple field characteristics at once. Like the ability to set formatting for multiple number fields.…
Fred
Fred
2 yrs ago
2
Learn and share
Reported - view
Re: Disable "copy" button?
Don't know if you found this post.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Old threads occasionally appearing
sometime it is spam. when I see it I click on the Report Post.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Hide Multiple fields at once
@John Halls no problem. Not that I haven’t read a post completely before answering.
plus great minds think alike.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Hide Multiple fields at once
Sadly there is no way to mass edit the Display only if or any field modifiers. If you really don't need the fields you can put them in a new tab then hide the tab.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sum Specific records of certain year based on a date field
Try this: let year:=Year cnt((select 'table')[year('date field') = year].people) Assuming that the field Year is a number field containing data that consists of a four numbers that matches common…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How do you manage money from one year to the next?
Seems like you will need a child table to your jobs tabled called 'Payments Made' or something like that. It would have at least two fields, a date and a number.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: sum((select......... with two values
Or you can do: let x := (select Line) sum(x.Plan_Earned_Act_E) + sum(x.Plan_Earned_Act_P) For this formula the two selects won't make a big difference,…
Fred
Fred
2 yrs ago
3
Get help
Reported - view
Re: Speeding up data insertion
Thinking off the top of head, 1) if you don't need to see historical data very often then you can just filter the Times view to show you the data you want.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Speeding up data insertion
I have a sport DB and I use to enter in data in my results page and I had to pick a year, a location, a team, a rider, a horse. I eventually leaned that once I linked Location to Results,…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Speeding up data insertion
Since People and Times are linked you can start in People and there should be a create Record under the Times view. Any new Times record will automagically have the link to People.
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: How to Calculate Cumulative Sum
I put this in cost_by_week: let t := this; sum((select COST_W)[Week <= t.Week].Cost)
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: How to Calculate Cumulative Sum
@Rafael you didn't upload the DB.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to Calculate Cumulative Sum
@Rafael said: the formula give me this result, All Id's on COST_W Are you in the COSTO_W table? Can you upload a copy of the DB?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to Calculate Cumulative Sum
@Rafael said: Hi Fred the Formula give me 0.00€ So my first question is does the filter work properly? Like the last post we need to check to make sure you are getting the correct records.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to Calculate Cumulative Sum
Maybe something like: let t := this; sum((select COSTO_W)[Week <= t.Week].Cost_Week) You want to find all records with where the value in Week is less than or equal to the value in Week of the…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Group Sum Cost by Week
So is that what you expect? By copy your DB does not have a field called Week in the COST_W table.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Group Sum Cost by Week
oops, for got the let statement. my bad.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Group Sum by Week
To troubleshoot, first you need to make sure that it is finding the correct records. So put this in a new formula field: concat((select EV_Management)[Week = Wk]) This will return the record Ids of…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Multiple Choice Field - How to get possible values/choices
Why do you need a list of all choices in a multiple choice field? Do you need it in a single field? Since a multiple choice field is probably static and pretty short then you can just edit the field…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Cascading Selection Fields with a twist
Well that is tricky. Once you are in the Dynamic choice filed you lose all ability to track the current record you are on in the Contracts table (something that many have asked for).…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
1
100
101
102
103
104
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
plus great minds think alike.