Fred's Profile | Ninox Community

Badges

Latest Posts

Re: List of years/months/weeks...
@Rafael You can try something like this: let t := this; let cntWeek := (year(EndDate) - year(StartDate)) * 52 + week(EndDate) - week(StartDate) + 1; if EndDate != null then for loop1 in range(0,…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: List of years/months/weeks...
Here is one possible solution: let t := this; let cntMonth := (year(EndDate) - year(StartDate)) * 12 + month(EndDate) - month(StartDate) + 1; let srtMonth := month(StartDate); let srtDay :…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: List of years/months/weeks...
I'm guessing if there is no end date then nothing will happen?
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: List of years/months/weeks...
Would you need this done for each record? If there were 500 records you would have 500 lists? Or you would only create one list for all 500 records?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic (Multi) Choice display
Take a look at this thread. It is a limitation of Ninox where in the DMC you have lost all relationship with the current record you are on. Ninox thinks you are in another table.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to get a filtered sum() from a table-value, where all have a common category?
If I understand your structure: You have two tables: Stats and Studypoints. They are linked by the reference field Studypoints_bei_Stats where 1 record in Stats is linked to many records in…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to get a filtered sum() from a table-value, where all have a common category?
You can try something like: sum(Studypoints_bei_Stats[Studypoint.Abteilung = 1].Studypoints) This is assuming that the 1:N relationship is between Studypoints and Studypoint_bei_Stats.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice from Dynamic Multi Choice
If you want each of the DC fields to be independent of each other then you would need copy the Dynamic Value code to each field.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice from Dynamic Multi Choice
Playing around it looks like they have made dynamic multichoice fields a bit easier to update by code. If you create a formula field and put the following code in:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice from Dynamic Multi Choice
@UKenGB said: That first part of the answer looks interesting, not a construct I have come across before. I'll need to have a play around with that. You can get more background from this post.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Since you have a Chronos view, why do you need to open the Chronos table at all? The view shows them the same information as they would by opening the table separately.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice from Dynamic Multi Choice
The first part of your question can be solved with something like this in the formula part of the dChoice field: let prevDMC := numbers(dMC); (select Table1)[(var a := this;…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to get a filtered sum() from a table-value, where all have a common category?
1) after the select you have Studypoints.Studypoints. After a select statement you only need the table name. You do not need any field names, so the 2nd Studypoints is not needed.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Comparing Multi-Selects
Hi Javier - The code I provided if simply switched to numbers(dMultiChoice) then would break down because record Id's probably don't match between Table A and Table B.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to get a filtered sum() from a table-value, where all have a common category?
Can you post the code that you are working with?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Table View column Totals
The columns in views are just like columns in tables, so you can click on a column name and then select sum and it will total the column. Is that what you want?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Updating calculation - effect on existing records
@Davie said: Yes, if the multiplier was a selection list that might work but is another step rather than 'automatic'. If there is a standard multiplier then you can add it to the default value.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Updating calculation - effect on existing records
How often do the changes happen? Do you need to track the changes? How often does the changes need to be made for each record in a table? 1 way of doing it would be to create a new number field…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Duplicating a database deletes internal references
You can always not duplicate the records. Then just import the data for the dynamic choice field separately.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Duplicating a database deletes internal references
Interesting, I duplicated a DB with dynamic fields and they duplicated fine. They didn’t lose their connection or anything. Can you create a temp db and try it again?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I change the date format to year.month.day?
Here is the date/time formatting expression list. If you need to change a date field to two digit year.mon.day then you could put something like this in a new formula field: format(fieldname, "YY.MM.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
I use the Mac app (v3.6.6) and the same thing happens for me. Main only creates 12 records while Test creates all 100. If I change the ending date to less than 12 then it creates 12.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: syntax problems
There is no need for the dynamic field if you are passing along only a single date. So it is back to the drawing board and this is one solution. On the Prestaties table,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: syntax problems
The dynamic field is in the Prestaties table.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: syntax problems
As I stumbled through figuring out a solution I got stuck trying to figure out how to deal with the records in Loonhistoriek that have no Einddatum. The solution to your first question means that…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 115 116 117 118 119 154

Welcome to the Ninox community

Fred

Re: List of years/months/weeks...

Re: List of years/months/weeks...

Re: List of years/months/weeks...

Re: List of years/months/weeks...

Re: Dynamic (Multi) Choice display

Re: How to get a filtered sum() from a table-value, where all have a common category?

Re: How to get a filtered sum() from a table-value, where all have a common category?

Re: Dynamic Choice from Dynamic Multi Choice

Re: Dynamic Choice from Dynamic Multi Choice

Re: Dynamic Choice from Dynamic Multi Choice

Re: Creating a Button That Goes to Table with only Linked Records

Re: Dynamic Choice from Dynamic Multi Choice

Re: How to get a filtered sum() from a table-value, where all have a common category?

Re: Comparing Multi-Selects

Re: How to get a filtered sum() from a table-value, where all have a common category?

Re: Table View column Totals

Re: Updating calculation - effect on existing records

Re: Updating calculation - effect on existing records

Re: Duplicating a database deletes internal references

Re: Duplicating a database deletes internal references

Re: How do I change the date format to year.month.day?

Re: while loop stops before reaching end

Re: syntax problems

Re: syntax problems

Re: syntax problems

Overview