Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3421
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: How do i get my numbers $ to format right?
To confirm, all your fields in the picture are text fields? Since your data from your CSV has $ in it, Ninox will treat any data with non numbers as text.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: acces to array items like with Where fonction
I put the ( ) in but everytime I save it and go back in Ninox strips them out. That is so weird that it is not working for me. I've even try the for loop and that also gives me a blank field.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Complex Select statement for View
I to am intrigued by your question. To save a copy, at the start of the program with the DB list, if you click on the down arrow on the top right corner of the DB,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: acces to array items like with Where fonction
@John Halls said: x[=v], v doesn't have to be a single element, and can in fact be larger than x If I'm learning the concepts correctly, I'm sure people smarter than me will correct me,…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: acces to array items like with Where fonction
Sadly that gives me a blank result: let array1 := [1, 2, 3, 4, 5]; let x := [1, 3]; array1[var v := this; not x[= v]]
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Related table field reference
take a look at the category field in Purchases. If I remember correctly I used the record command.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: acces to array items like with Where fonction
Ok, so I'm trying to remove one array from another. let array1 := [1, 2, 3, 4, 5]; let x := [3, 1]; array1[this != x] Doesn't return 2,4,5 If x = 3 (a single digit) then it works).…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Neither of the two formulas work
To do a series of dates you need the for loop command. Which means you need an array of the dates you want to create records for. One way is to create the array in the formula.…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Related table field reference
I've made a few changes you can check out. @Gianluca said: I need to sum all the purchases made by a person, grouped by a "category" specified in the "Catalogue" table (in this sample: guitars,…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Neither of the two formulas work
You have to remember that select statements always return an array. So for the first one you need to do a few things: let xDoc := first(select 'DOCUMENTOS'); let xFld1 := xDoc.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Date function
Yes, this whole "no code" advertising is very mis-leading. You can use the format function: format(datefield,"D MMM") Here is a list of formats available.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Related table field reference
@Gianluca said: And to make things more complicated: would it be possibile to add more conditions with references to more tables? something similar to the wrong one here below: let a := Customer.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Related table field reference
@Gianluca said: with both formulas (used in both tables) I get this error: "Expression does not return multiple values". You get this when you try to follow a link in the wrong direction.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter on hidden columns
Welcome to the unwritten logic of Ninox. When you switch from pop-up to combo box, Ninox changes how you modify what is shown. If you have the reference set to Pop-up,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter on hidden columns
It will helps us all if you can post the code you are using and any information about the table structure that could help. Thanks,
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter on hidden columns
Just to be sure, you are talking about a view like a new table view or form view or chart view. Or are you talking about a view element?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Related table field reference
Are you creating this new sum formula in Table2 or Table1? John's formula works if you are in Table1. If you are in Table2 then you have to use the select function.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Help with wedding base
Sorry to hear about the crashing. I too use the app version. I've only experienced that when trying to delete a lot of records. If it happens every time then I would recommend reaching out to Ninox…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Return to my Topic
Maybe I'm not following correctly, but it seems like for the %_Plan field in the Avances table should be your master number for your DB. This will force a big rethink of the design of your DB.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Return to my Topic
Got the DB. Now I'm not sure what you want '%-Plan' in Plan_Real to be equal to.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
Thanks Steven, Just needed to switch things around. I guess I should have asked that before posting in the wish list.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Conversion into Ninox of old relational data
Glad things worked out. John's suggestion is good for a repeating task. I figured once you imported everything, you only needed to link them once and any future records would be linked manually or…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
I think it would be great to be able to use if statements to create variables and then use them in formulas later. for example: let t := this; if field1 = null then let var1 :…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Return to my Topic
Can you send me an updated test DB? You are showing a new table that I don't have.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Conversion into Ninox of old relational data
You can follow @Alain Fontaine advice in this forum.
Fred
Fred
2 yrs ago
Get help
Reported - view
1
107
108
109
110
111
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
