Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Fred
Fred
San Francisco, USA
2641
382
2
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Disable "copy" button?
Don't know if you found this post.
Fred
Fred
1 yr 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
1 yr ago
Learn & 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
1
Get help
Reported - view
Re: How to Calculate Cumulative Sum
@Rafael you didn't upload the DB.
Fred
Fred
1 yr 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
1 yr 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
1 yr 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
1 yr 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
1 yr ago
Get help
Reported - view
Re: Group Sum Cost by Week
oops, for got the let statement. my bad.
Fred
Fred
1 yr 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
1 yr 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
1 yr 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
1 yr ago
1
Get help
Reported - view
Re: Cascading Selection Fields with a twist
In my testing if I write (where I'm in Table2 and I create a Dynamic Multi-Choice field to Table1. Then I change the value name formula where Choice is a simple choice field in Table4): let x :…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Cascading Selection Fields with a twist
Just to be sure I'm understanding the question. You have a dynamic choice field that is pointing to the Selections table. In the dynamic value name part you want to condition it to show a field from…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Very slow opening table
Yes, it is always the select statement. There are ways to minimize those and still get calculations done. I have a sport league so stats are the basis of any sports,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Concatanate - Two For loop -
Charts are not my thing so I don't think I can help out too much. I tried creating a formula that does something similar where you create the records in a table then use the same table to populate…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Concatanate - Two For loop -
Can you post the code you are working from?
Fred
Fred
1 yr ago
Get help
Reported - view
1
69
70
71
72
73
106
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics