Fred

San Francisco, USA

3421
539
4

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

My Posts

Latest Posts

Re: Formula don't work but no errors
Are you trying to set the HITOS dynamic multi choice field with this formula field? If so a formula fields can not be used by themselves to set another field.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula don't work but no errors
Is this code in a formula field or code in a Trigger?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: in 'many' table: what's difference 'required' vs 'composition'?
I would view them as separate things. Composition just tells Ninox that a table is a child of another. That is all. You can create a record in the child table and not have it linked to anything.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Is it normal for ninox to crash almost every time i go back
Just to let you know your sample DB doesn't crash on my Mac. Does your sample DB also crash or only your real one?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
Thanks Jacques. It was stupidity on my end. I was looking at the wrong field to subtract.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: How do i get my numbers $ to format right?
The invoice template is assuming that an invoice will have multiple invoice items. Who doesn't want to sell as many items as they can to a customer. :) Thus the need for a table that stores all…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
If the field is in a table view you can click on the column name and click Hide column. If the field is in a form view there are two ways: 1) you can set Display field only if to null or not null…
- Fred
- 2 yrs ago
- Get help
- Reported - view
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
Just sent an email to Ninox.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view

1 106 107 108 109 110 137

Welcome to the Ninox community

Fred

My Posts

Re: Formula don't work but no errors

Re: Formula don't work but no errors

Re: in 'many' table: what's difference 'required' vs 'composition'?

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

Re: acces to array items like with Where fonction

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: 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

Overview