Fred's Profile | Ninox community

Badges

Latest Posts

Re: Formula
do any records show True? if not then shorten the code to just: if FechaR4 <= DataDate then "True" else "False" end If you still do not get any trues then: 1) what kind of field is FechaR4?…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Formula
Hi Rafael - With any if statements are you sure that you are asking correctly? If you change the code to: if FechaR4 <= DataDate and FechaR4 != 0 then "True" else "False" end Do you see the…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: NEW FORUM
Anyone try direct messaging?
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: Sticky Messages or Tags
I am willing to help. I just tried out the code block and that is cool. Plus you can add line numbers. I don't see how to add a tag? or is it as simple as #Example?
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: Connect 2 Records from 2 Tables, based on 2 or More Parameters
I don't know if putting your button code into the formula of a multiple record update would work, but that is an option to try. Depends on how often you need to import records then modify them.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: NEW FORUM
Yeaaaaa!!!!
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: Applying filters on a lookup table by choosen field
Hi Mauro Your code is almost there. Just modify it a bit: text(b.Customers.Services) = a.Service From the looks of it the Service field in Services (a) is a simple choice field.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Filter based on multiple columns
Yes, Ninox is case sensitive with its commands. It is always lowercase. Glad things are working.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Formula somma ricambi di una installazione
Hi Mauro - If the reference field is called 'Ricambi installazini zanzare' then you can just drop the select. So it would look something like: sum('Ricambi installazioni zanzare'.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How to hide a relational field in a view
One way is under More options of the view, you can set the "Display field only if" to null so it will always hide the field. To unhide it, select Edit Fields and remove the null.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Filter based on multiple columns
Then you would just add the reference field name before the field. So if Name is in a table called People and the reference field in your current table is also called People then:…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Filter based on multiple columns
Hi eka - Sorry I didn't read your first post. Your code could look like: if Status = "Open" or Status = "Closed" or Country = "Germany" or Name = null then 1 end That is assuming none of the fields…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Filter based on multiple columns
Hi eka - To filter a table view on multiple fields with an or condition can not be done without another field, like Mel's first comment. So you could do something like this in a formula field:…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Show all records in another record that are related by an ID
If you are not familiar with using brackets [], I would recommend that you start to familiarize yourself with them. They can be used in place of a where statement.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Show all records in another record that are related by an ID
You can create a formula field with the following: let t := this; (select persons)[familyID = t.familyID].FirstName The first line gathers data of the current record.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Please help with very simple select statement
Hi Andrew - Yeah it does look at little strange to have the same data in all records. When you are ready you can look into dashboards then hyper dashboards.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Please help with very simple select statement
Hi Andrew A select statement in Ninox is a way for you to tell Ninox to go to a table and gather data and then do something with it. So you are on the right track if you want to find all records in…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Please help with very simple select statement
Hi Andrew - is addnum a number field like your picture shows or is it a reference field to another table? If it is a number field then you can drop it from the select statement.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Find duplicates
Hi RG - You can take what Kruna recommends and with a small change have the formula field say "duplicate" so you can then do a search on that word. For example you can change the if statement to:…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox DB shuts down with large Deletes
It is a known issue with Ninox as I submitted a ticket with them about this as well. Who knows when they will fix it. I sent the email back in Dec 2021 in v3.5.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Date and time
Hi Henrik - If you are not aware that Ninox uses miliseconds since the Unix epoch to do all datetime calculations. So to add time to a date/time field you have to take the data in your 'Traveltime in…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How do I join two different conditions in one statement (and/or) thank you
in a if statement: if field1 > 10 or field2 < 20 then ... in a select statement select Table1 where field1 = null and field 2 = "Bad" or select Table1 [field1 = null and field 2 = "Bad"]
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Somewhere to share user templates?
You should email support@ninox.com. The ninox team does not post much on the forums anymore.
- Fred
- 4 yrs ago
- Learn and share
- Reported - view
Re: how do I delete values from a choice field
Sounds lik you are using iCloud storage. If that true then only 1 device can "own" the DB and thus edit the structure. If you want to change ownership then you have to make sure the db is closed on…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: using the selection of dynamic choice fields to autofill a text field with data from the table used by the dynamic choice field.
Hi Louis - Sorry, you said you want the data copied. So you can put something like this in a button in Table1 to test it out: let x := record('Table 2',number(Response));mitigation := x.…
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 135 136 137 138 139 157

Welcome to the Ninox community

Fred

Re: Formula

Re: Formula

Re: NEW FORUM

Re: Sticky Messages or Tags

Re: Connect 2 Records from 2 Tables, based on 2 or More Parameters

Re: NEW FORUM

Re: Applying filters on a lookup table by choosen field

Re: Filter based on multiple columns

Re: Formula somma ricambi di una installazione

Re: How to hide a relational field in a view

Re: Filter based on multiple columns

Re: Filter based on multiple columns

Re: Filter based on multiple columns

Re: Show all records in another record that are related by an ID

Re: Show all records in another record that are related by an ID

Re: Please help with very simple select statement

Re: Please help with very simple select statement

Re: Please help with very simple select statement

Re: Find duplicates

Re: Ninox DB shuts down with large Deletes

Re: Date and time

Re: How do I join two different conditions in one statement (and/or) thank you

Re: Somewhere to share user templates?

Re: how do I delete values from a choice field

Re: using the selection of dynamic choice fields to autofill a text field with data from the table used by the dynamic choice field.

Overview