Skip to main content
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
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3421
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
Fred
2 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
Fred
2 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
Fred
2 yrs ago
Get help
Reported - view
Re: syntax problems
The dynamic field is in the Prestaties table.
Fred
Fred
2 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
Fred
2 yrs ago
Get help
Reported - view
Re: Show field if two conditions are satisfied
'Mostra Primo Contatto' and 'Come ci hai conosciuto?' = 7
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Insert automatically customer data
Looks like you want a new record created in Robot installation after a user selects the Customer. Like any script that I'm creating that I want to put in a trigger, I first do it in a button.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Display immedialty data entry mask
what is a data entry mask?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: syntax problems
Ok, if John is correct in how you want to enter the Einddatum of the previous record when a user enters in the Begindatum of the current record, you can try something like this in a button and if it…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: syntax problems
That makes sense too.
That is an interesting question.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: syntax problems
Your first question is pretty simple. If you put the following in the Trigger after Update of the Begindatum field: Einddatum := Begindatum + 365 So after you enter in data in the Begindatum field…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Show field if two conditions are satisfied
Just to clarify, Field A is a Yes/No and Field B is a number field? if so then you can do something like: 'Field A' and 'Field B' = 7
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Trigger on Open....
There is not a trigger on Open at the table level. There is one at the DB level.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Getting Ninox to Recognise a number
what do you mean you can’t use it in other calculations? what happens when you do?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Only show dropdown #2 when dropdown #1 isn't blank
In the Branch field there is the "Display only if" setting. Try setting it to: Company != null You are telling the field to display only if the Company field is NOT null (or empty).
Fred
Fred
2 yrs ago
Get help
Reported - view
1
99
100
101
102
103
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
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
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
That is an interesting question.