Fred

San Francisco, USA

3424
540
4

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

My Posts

Latest Posts

Re: Syntax stupid question
Does the select work in view by itself? maybe the if statement doesn’t return true?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Syntax stupid question
I was wrong. I just tried it out and your first code is correct. Looking at it again, you have selected records in Jobs that match your search parameters but you don't tell Ninox what do with it.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to import data from text field to dynamic choice field
Hi Alexis - Do you still need help with this?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Syntax stupid question
You can try: select Jobs where Stato = 2 and 'Stato lavorazione FOTO' = 4 and 'Stato Album' =1 or 'Stato Album' = 3 or 'Stato Album' = 4 No need to repeat the first two since they are the same.
- Fred
- 2 yrs ago
- Get help
- Reported - view
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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: NEW FORUM
Anyone try direct messaging?
- Fred
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: NEW FORUM
Yeaaaaa!!!!
- Fred
- 2 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view

1 115 116 117 118 119 137

Welcome to the Ninox community

Fred

My Posts

Re: Syntax stupid question

Re: Syntax stupid question

Re: How to import data from text field to dynamic choice field

Re: Syntax stupid question

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

Overview