Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3811
posts
606
likes received
5
followers
Badges
Latest Posts
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
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
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
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
Fred
3 yrs ago
2
Get help
Reported - view
Re: List of years/months/weeks...
@Rafael Maybe it is a MacOS only issue.
Fred
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Fred
3 yrs ago
Get help
Reported - view
1
114
115
116
117
118
153
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics
