Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Show field if two conditions are satisfied
'Mostra Primo Contatto' and 'Come ci hai conosciuto?' = 7
- Fred
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Display immedialty data entry mask
what is a data entry mask?
- Fred
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: syntax problems
That makes sense too. 🙂That is an interesting question.
- Fred
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs ago
- 3
- Learn and 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
- 3 yrs ago
- 2
- Learn and share
- Reported - view
Re: Disable "copy" button?
Don't know if you found this post.
- Fred
- 3 yrs 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
- 3 yrs ago
- Learn and 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
- 3 yrs ago
- Get help
- Reported - view
Re: Hide Multiple fields at once
Sadly there is no way to mass edit the Display only if or any field modifiers. If you really don't need the fields you can put them in a new tab then hide the tab.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sum Specific records of certain year based on a date field
Try this: let year:=Year cnt((select 'table')[year('date field') = year].people) Assuming that the field Year is a number field containing data that consists of a four numbers that matches common…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do you manage money from one year to the next?
Seems like you will need a child table to your jobs tabled called 'Payments Made' or something like that. It would have at least two fields, a date and a number.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: sum((select......... with two values
Or you can do: let x := (select Line) sum(x.Plan_Earned_Act_E) + sum(x.Plan_Earned_Act_P) For this formula the two selects won't make a big difference,…
- Fred
- 3 yrs ago
- 3
- Get help
- Reported - view
Re: Speeding up data insertion
Thinking off the top of head, 1) if you don't need to see historical data very often then you can just filter the Times view to show you the data you want.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Speeding up data insertion
I have a sport DB and I use to enter in data in my results page and I had to pick a year, a location, a team, a rider, a horse. I eventually leaned that once I linked Location to Results,…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Speeding up data insertion
Since People and Times are linked you can start in People and there should be a create Record under the Times view. Any new Times record will automagically have the link to People.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view

1 116 117 118 119 120 154

Welcome to the Ninox community

Fred

Re: Show field if two conditions are satisfied

Re: Insert automatically customer data

Re: Display immedialty data entry mask

Re: syntax problems

Re: syntax problems

Re: syntax problems

Re: Show field if two conditions are satisfied

Re: Trigger on Open....

Re: Getting Ninox to Recognise a number

Re: Only show dropdown #2 when dropdown #1 isn't blank

Re: sum results of this year

Re: Using if statements and date calculations to display yes or no based on variable.

Re: Using if statements and date calculations to display yes or no based on variable.

Re: Suggestions from May 2022

Re: Suggestions from May 2022

Re: Disable "copy" button?

Re: Old threads occasionally appearing

Re: Hide Multiple fields at once

Re: Hide Multiple fields at once

Re: Sum Specific records of certain year based on a date field

Re: How do you manage money from one year to the next?

Re: sum((select......... with two values

Re: Speeding up data insertion

Re: Speeding up data insertion

Re: Speeding up data insertion

Overview