Fred

San Francisco, USA

3608
568
5

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

My Posts

Latest Posts

Re: acces to array items like with Where fonction
@Jacques TUR I've never seen the use of the curly brackets. What are you telling Ninox to do with: {y:Year}
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Jacques TUR Always willing to learn a better way, how would you write it? Would you drop the let xSeason and just do it in select Seasons?
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
I'm trying to wrap my head around this. How would you do something like this comparing the value of one array with another? let curRec := this; let xRes := unique(select Results[RiderID = curRec.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Aggreggate like Excel does
Hi Roxana - This sounds like a good place for a dashboard. Check out this youtube video from Nioxus for a good primer on dashboards. For me, once I learned dashboards,…
- Fred
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: How to Reverse Linking between 2 tables ?
I read the question as asking if one can change a reference field from a "Link to" to a "Link from". If that is the question then it is no. You have to create a new field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Help with Scripting
Hi there - One option is to use the order by command. Since 'Item History' is linked to Transaction you can do something like: let x := last('Item History' order by Date); let xIHDate := x.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Pass current viewing record Id to a view element column formula
@John Halls Yeah, those were my thoughts as well. I was hoping that I was missing something, which wouldn't be surprising. Maybe I'll submit a feature request to Ninox.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Pass current viewing record Id to a view element column formula

Hi all - I have a table that has a view element. I'm trying to do formulas in the view element that requires data from the record I'm viewing. As we know,…
- Fred
- updated 3 yrs ago
- 13replies
- 946
- 3
- Get help
Re: Other formula problem
Hi Rafael - I am unsure what you are trying to do with your 2nd line. Are you trying to sum the data in a field? Are you trying to set a field to = "Civil"?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Syntax stupid question
Does the select work in view by itself? maybe the if statement doesn’t return true?
- Fred
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: NEW FORUM
Anyone try direct messaging?
- Fred
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: NEW FORUM
Yeaaaaa!!!!
- Fred
- 3 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

1 122 123 124 125 126 145

Welcome to the Ninox community

Fred

My Posts

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Aggreggate like Excel does

Re: How to Reverse Linking between 2 tables ?

Re: Help with Scripting

Re: Pass current viewing record Id to a view element column formula

Pass current viewing record Id to a view element column formula

Re: Other formula problem

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

Overview