Fred

San Francisco, USA

3421
539
4

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

My Posts

Latest Posts

Re: Track selection of Dynamic Multiple Choice field
@Jacques TUR Again you are correct. My change to ">=" actually broke the tracking and when I changed it to =0 the tracking of selection worked again. I've updated the test DB and have included it…
Attachment
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
I wonder if this will fix the non-delete in the web version? Looking at your code I wouldn't have thought this up as it seems like Ninox would run both loops.…
Attachment
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
Looking again at my code the top part can be better written: let t := this; let childArray := Child; let dMCArray := numbers(dMC); let childCnt := count(childArray); let dMCcnt := count(dMCArray);…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
Just tried it on my iPad and it works fine. I guess something in it the web version doesn't like. That is very interesting. Just noticed on line 6 I put the main part of the code in a variable then…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
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
- 2 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
- 2 yrs ago
- 33replies
- 1370
- 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: List of years/months/weeks...
@Rafael Maybe it is a MacOS only issue.
- Fred
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view

1 98 99 100 101 102 137

Welcome to the Ninox community

Fred

My Posts

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

Re: Track selection of Dynamic Multiple Choice field

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

Overview