Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

Re: How do i get my numbers $ to format right?
yeah there is no way to see the column numbers, but you can see that it can't find B. Field not found: B If you look at the code there is a B after Customer,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Is it normal for ninox to crash almost every time i go back
Have you reported this to Ninox support?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
Glad to hear things are working. Ninox, like any DB, will have a learning curve. Once you learn Ninox, then you can learn Ninox printing. Something that I've stayed away from.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Accessing a single line item on an invoice
@Roger said: Fred It worked currently in the Summary table, but when I try to pull data in another table, it shows nothing. I'm a newbie in writing code,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Is there a way to transfer multiple fields from one table to another?
To permanently move data from one table to another as a one time task, the best way, I think, is to use the Update multiple records function. First you need data in your new table can match the…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Neither of the two formulas work
@Rafael I don't use charts so I don't know if you can. Maybe someone with more Ninox chart experience can jump in.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
About your date issue. Looking at your sample CSV you sent in another topic, the date format of 4/12/22 is not liked by Ninox. Playing around it seems like Ninox is ok with yy-mm-dd with month being…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
Looking at the fields, you are formatting the number fields in Ninox. If you edit Total2: you will see that there is formatting applied under Number format.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
Something is not making sense. Can you upload this DB?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
Hi Mike - Can you give us an example the results of the found set? For example if I'm in the Flare Gymbol 3 record in the Actions table, what records should I see if the view element has the proper…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
Total: is a number field? Are you formatting Total: in Ninox? Are you adding the $ in Ninox or did it import that way? You said you CSV has $ in front of the number,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: contact with many companies
Sounds like you need a third table, maybe called AssociatedCompanies. You would add two reference fields, one to Contacts and one to Companies. Then you would modify the Contacts reference field to…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Date of Birth? manually entry
I don't use the mobile apps too much, so I don't have much experience with it. On the Mac app, I can enter in date date directly into the date fields I have.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: acces to array items like with Where fonction
I'm obviously not getting the logic behind all this so I'm putting this out there. Here is my code: let xH1 := allhito1; let xH2 := allhito2; xH1[var ah1 := this;…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
Thanks for figuring it out. It is not good that the two products don't function the same.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Date of Birth? manually entry
While the calendar pops up, you can still type in the box to enter in the date desired. Just be aware that it is picky about how you enter data. On my English US system, I can not type in:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
I too use the app. Exit your DB but not the app. You will see a list of all your DBs. Then follow my previous instructions. Sadly exporting a CSV will not help us.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
Just sent an email to Ninox.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Learn and share
- Reported - view

1 114 115 116 117 118 145

Welcome to the Ninox community

Fred

My Posts

Re: How do i get my numbers $ to format right?

Re: Is it normal for ninox to crash almost every time i go back

Re: How do i get my numbers $ to format right?

Re: Accessing a single line item on an invoice

Re: Is there a way to transfer multiple fields from one table to another?

Re: Neither of the two formulas work

Re: How do i get my numbers $ to format right?

Re: How do i get my numbers $ to format right?

Re: How do i get my numbers $ to format right?

Re: Complex Select statement for View

Re: How do i get my numbers $ to format right?

Re: contact with many companies

Re: Date of Birth? manually entry

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Date of Birth? manually entry

Re: Complex Select statement for View

Re: acces to array items like with Where fonction

Re: How do i get my numbers $ to format right?

Re: acces to array items like with Where fonction

Re: Complex Select statement for View

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Related table field reference

Re: acces to array items like with Where fonction

Overview