Skip to main content

Ninox-Documentation

Fred

Fred

San Francisco, USA

2638
381
2

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

My Posts

Latest Posts

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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: syntax problems
The dynamic field is in the Prestaties table.
- Fred
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Show field if two conditions are satisfied
'Mostra Primo Contatto' and 'Come ci hai conosciuto?' = 7
- Fred
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Display immedialty data entry mask
what is a data entry mask?
- Fred
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: syntax problems
That makes sense too. That is an interesting question.
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: sum results of this year
I'm guessing you have a date field in the Prestaties table. If so then you can try: sum(Prestaties[year(datefield) = year(today())].KB213) This will always get records where the year of the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using if statements and date calculations to display yes or no based on variable.
I was thinking about a similar situation as I was creating my test DB. I wondered if you might need to track different vaccines by manufacturer. Then of course even within the same product there are…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Using if statements and date calculations to display yes or no based on variable.
A handy date command is days(date1,date2). This will return a number that a normal human can understand. If you create a formula field called DaysSinceLastVax you could write something like:…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Suggestions from May 2022
The ability to search your fields in the Edit Fields window. If you have a large quantity of fields then trying to find them can prove challenging since we can't sort them.…
- Fred
- 1 yr ago
- 3
- Learn & Share
- Reported - view
Re: Suggestions from May 2022
Don't remember if this made the Christmas wish list. The ability to modify multiple field characteristics at once. Like the ability to set formatting for multiple number fields.…
- Fred
- 1 yr ago
- 2
- Learn & Share
- Reported - view
Re: Disable "copy" button?
Don't know if you found this post.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Old threads occasionally appearing
sometime it is spam. when I see it I click on the Report Post.
- Fred
- 1 yr ago
- Learn & Share
- Reported - view
Re: Hide Multiple fields at once
@John Halls no problem. Not that I haven’t read a post completely before answering. plus great minds think alike.
- Fred
- 1 yr ago
- Get help
- Reported - view

1 68 69 70 71 72 106

Back to top

Ninox-Documentation

Overview

View all topics