Fred's Profile | Ninox Community

Badges

Latest Posts

Weird switch issue

I'm using the MacOS app, so if I put this in a formula field: switch Number do case Number < 5: 10 case Number > 5: 20 end with Number being a number field in the same table.…
- Fred
- 3 yrs ago
- 5replies
- 994
- 3
- Get help
Re: Read only table
Ok, well I don't know if the feds would consider this acceptable. You can use the Writable if section of a table. If you create a yes/no field called Edit.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Code the top search - Help
You can just delete that formula field.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox for Mac vs Ninox Cloud
Correct. It is a single user model.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Read only table
You want the entire table not writable? Is this for a multi-user situation? Or just to keep yourself from causing trouble?
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: How can i get totals from a job type?
Just food for thought. Why are you keeping job data like total, down payment, job start time, etc. in the customer table? I would think that information should be in your Payment table.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Ninox for Mac vs Ninox Cloud
If you purchase the app you do not need to subscribe to the cloud version. That is how I use it.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: trigger a field in subtable from field in mother table
try adding: let t := this; at the first line and then replace all instances of Jobs after the "then" with t. So line two would look like: t.Data+15 The reasoning, I think is,…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Code the top search - Help
After reviewing the DB, I noticed that you made the top row of fields view elements. You need to make them fields so you can enter in data. I've uploaded a modified DB.…
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Use Formula field to display subset of a linked table??
Hi James - I'm a bit confused. @James said: I want to create a formula field that only displays records from the Expenses table A formula field is not really setup to display records.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Building table relationship 1:N
Try reading @Alain Fontaine comments in this forum. He is describing a one time job, but you can do something similar in a button.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How can i get totals from a job type?
Last question first, yes you can not sum a text field. You will have to create a new formula field that converts Total: to a number. number(fieldname) Remember you have to strip off the $ like we…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i track payments and update the new balance due?
Since Payments and Customer are linked you can use the power of relationships to gather the data. No need for select statements since you only want to see Payments of the customer you are looking at.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: in 'many' table: what's difference 'required' vs 'composition'?
You are correct. Once a table is made a child (composition = yes), if the parent record is deleted all child records will be as well.
- Fred
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 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

1 121 122 123 124 125 153

Welcome to the Ninox community

Fred

Weird switch issue

Re: Read only table

Re: Code the top search - Help

Re: Ninox for Mac vs Ninox Cloud

Re: Read only table

Re: How can i get totals from a job type?

Re: Ninox for Mac vs Ninox Cloud

Re: trigger a field in subtable from field in mother table

Re: Code the top search - Help

Re: Use Formula field to display subset of a linked table??

Re: Building table relationship 1:N

Re: How can i get totals from a job type?

Re: How do i track payments and update the new balance due?

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

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

Overview