Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Fred
Fred
San Francisco, USA
2637
381
2
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: (Invalid)
one way is to put an if statement in front: if denominatorfieldname != null then current formula end If you are doing division then you can check to see if the denominator field is not null.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Colour Coding
I don't use styled very much so I don't know if it can do text on its own. I think I saw somewhere about using HTML to color text, but I can't say for sure.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Colour Coding
Have you looked into Conditional Styling for columns? This is helpful if you only want to see it in a table view. In a table view or view element, if you click on the column name you will see the…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Automatically Displaying referenced data based on String
Can you give us a bit of background on your tables? What are your table names? What is the name of the reference fields that link the tables? What is the name of the raw data fields that you will…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: function between two numbers
If you take a look at this post, you will see that you can use arrays in the switch function.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
@Bruno Skëndaj said: I'm struggling to link them together Are we talking about the Income table and Expenses table? If not then what tables are you talking about?…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
This is where the use of reference fields come in. We don't know the names of those fields so you will have to adjust the following formulas. For StockIn (I use mashed up words so I don't have to…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: function between two numbers
You can use a switch function. It is not intuitive but you can do something like: switch true do case number < 5: "result 1" case number >= 5 and number < 7.5: "result 2" case number >= 7.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
Sound like you create a record in your Purchases/Supply table and you want the Stock table to aggregate data from Purchases/Supply. I'm guessing that you have a reference field in Purchases/Supply…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Suggestion List from first crack at Ninox
looks like you are too busy fixing CSS errors for Ninox.
Fred
Fred
1 yr ago
Learn & Share
Reported - view
Re: Suggestion List from first crack at Ninox
I too thought it was a new post, but a spam post brought it back up.
Fred
Fred
1 yr ago
Learn & Share
Reported - view
Re: Problem with radio Botton on Web version
I am able to duplicate it on the MacOS app on v3.6.0. Just to be clear this only happens on reference fields. Dynamic choice/multi fields show radio buttons fine.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Show/Hide One Record
The only way I can think of would be to find a way to just filter out that one record through one of the columns.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Small problem with this formula
Please tell me which table and button/trigger you want to put this formula in? @Rafael said: The Formula works, but no return to the date I change in Table FECHACORTE for loop1 in select…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: ninox database
Are you in a table view? If so make sure you don't have a filter set on a column that filters out the newly created record. Not that I've done this before.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Show/Hide One Record
Are you talking about show/hide one record from a list of records in the table view? Or you only want to filter a table view so only one record is show?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Not Displaying Appointments on Mondays???!?!?!?
That is a weird one. I've too tested it on my MacOS app and I can not duplicate the issue. You should probably email support for help with this one.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Small problem with this formula
I'm not sure what table you are starting in. I say this because you say: DataDate := loop1.Date; and I don't know what table the field DataDate is in. Let us walk through your for loop command:…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Import csv files with related tables.
From my quick review, there is no way of setting reference field links during the import process. I don't even see the fields as being available. Which means you will have to 1) import the data into…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Comparing Multi-Selects
@Mike N. said: which is why I asked the question because this is a whole new way of thinking for me. It is a whole new way of thinking for me too. My written description of the process is just as…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Comparing Multi-Selects
You can try something like this in a formula field: let a := [1, 2, 3]; let b := [2, 4, 5]; let xCntA := a[(var subA := this; count(b[= subA])) > 0]; if cnt(xCntA) = 0 then "True" else "False" end…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Complex Select statement for View
You can do 1 of the following at the very end: step2 or step1[(var r2 := this; count(xTar[= r2])) = 0]; Basically you need to have an array at the end.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Jump
You would use the Contraints part of the LT_Actividades field. You would put this code in: a.DISCIPLINAS = b.LT_Disciplinas
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Complex Select statement for View
@Mike N. said: I get lost though on step1 and step2. I'm still learning what is really happening as well. I'm just parroting what I've seen. You can try this post for more background.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Filter a view by Id
If you are in the appointment table then: let t := this; (select AppointmentLine)[Appointment = t] If you are in some other table then you can just adjust the t to include the path to the…
Fred
Fred
1 yr ago
Get help
Reported - view
1
71
72
73
74
75
106
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics