Fred

San Francisco, USA

3615
570
5

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

My Posts

Latest Posts

Re: Old threads occasionally appearing
sometime it is spam. when I see it I click on the Report Post.
- Fred
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
@Rafael you didn't upload the DB.
- Fred
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Group Sum Cost by Week
oops, for got the let statement. my bad.
- Fred
- 3 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
- 3 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
- 3 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs ago
- Get help
- Reported - view
Re: Concatanate - Two For loop -
Can you post the code you are working from?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Time interval use and sum
Playing around you can do the following as well: let XContOre := number('Lunedì' + 'Martedì' + 'Mercoledì' + 'Giovedì' + 'Venerdì' + Sabato + Domenica); format(time(XContOre), "hh:…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view

1 108 109 110 111 112 145

Welcome to the Ninox community

Fred

My Posts

Re: Old threads occasionally appearing

Re: Hide Multiple fields at once

Re: Hide Multiple fields at once

Re: Sum Specific records of certain year based on a date field

Re: How do you manage money from one year to the next?

Re: sum((select......... with two values

Re: Speeding up data insertion

Re: Speeding up data insertion

Re: Speeding up data insertion

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: Group Sum Cost by Week

Re: Group Sum Cost by Week

Re: Group Sum by Week

Re: Multiple Choice Field - How to get possible values/choices

Re: Cascading Selection Fields with a twist

Re: Cascading Selection Fields with a twist

Re: Cascading Selection Fields with a twist

Re: Very slow opening table

Re: Concatanate - Two For loop -

Re: Concatanate - Two For loop -

Re: Time interval use and sum

Overview