Fred

San Francisco, USA

3617
572
5

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

My Posts

Latest Posts

Re: Track selection of Dynamic Multiple Choice field
Ask and you shall receive! Open Table2 and you will see the form to try it out.
Attachment
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Track selection of Dynamic Multiple Choice field

Hi all - Here is one possible solution if you want to track the selection of choices in a dynamic multiple choice (dMC) field. In my test DB I have Table2 as my working table.…
- Fred
- 3 yrs ago
- 33replies
- 1436
- 4
- Learn and share
Re: Ninox Subscription Plans
I’m sorry you have dealing with subscription issues. You should email Ninox (support@ninox.com) to find out what is happening.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: WBS Sum budget elements
Remember that when dealing with dynamic choice fields you are working with record Id when you select a choice. You can show the Id field in the table view of the WBS table to see the record Id of…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: WBS Sum budget elements
I thought Presupuesto is a field name. If it is a reference field to a table then you can change the code to: sum((select DOCUMENTS)[Presupuesto.Level_1 like 1].…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: WBS Sum budget elements
The "like Level_1 = 1" is not something that will work in Ninox. Are you trying to find like or equal? You can't do both. Then you need to put the filter next to the table name using the square…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: List of years/months/weeks...
It is possible and it is one solution. It is a solution I use in one of my tables. The only issue I can see is you want to add notes or some other data to the month records and thus if you delete…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: List of years/months/weeks...
@John Halls Thanks for the info. It didn't do anything for me. I created a new DB to send off to Ninox but could not duplicate it. Which got me thinking that the new Time-Zone independent feature…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: List of years/months/weeks...
@Gianluca Just wondering what will you do for records with no EndDate in the next month after you run it? For example, if you ran it today, your months will stop in July 2022.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: List of years/months/weeks...
Since it is modifying data, it can be in: a button in a Trigger
- Fred
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: List of years/months/weeks...
@Rafael Maybe it is a MacOS only issue.
- Fred
- 3 yrs ago
- Get help
- Reported - view
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

1 106 107 108 109 110 145

Welcome to the Ninox community

Fred

My Posts

Re: Track selection of Dynamic Multiple Choice field

Re: Ninox Subscription Plans

Re: WBS Sum budget elements

Re: WBS Sum budget elements

Re: WBS Sum budget elements

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: List of years/months/weeks...

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

Overview