Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

Re: How to "scan" a table?
You would use the for loop command. for loop1 in select Table1 do loop1.(field1 := 100); let x := first((select Table2)[field2 := loop1.field2]); loop1.( field3 := x.field3 field4 := x.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Accessing a single line item on an invoice
You can try this: let id := 'Invoice Number'; let xRec := item((select Invoice where 'Invoice Number' = id), 3) let xCost := xRec.'Invoice Detail'.Cost let xItems := xRec.'Invoice Detail'.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Weird switch issue
I emailed Ninox and this is what they recommended. Thanks for the "behind the scene" look at Ninox.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Expression to place non-printing ascii codes into text
Being unfamiliar with ASCII codes, what is your end goal here? What does a text string with embedded ascii codes look like?
- Fred
- 3 yrs ago
- Get help
- Reported - view
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
- 914
- 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

1 113 114 115 116 117 145

Welcome to the Ninox community

Fred

My Posts

Re: How to "scan" a table?

Re: Accessing a single line item on an invoice

Re: Weird switch issue

Re: Expression to place non-printing ascii codes into text

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?

Overview