John Halls

John_Halls

Somerset, England

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

Short Contributors Bio

Hi All I'm pretty new to this forum, and to Ninox. I see the same names contribute their knowledge to us all (thank you) and I wonder if they (you) would be willing to give a bit of background about…
- John_Halls
- 3 yrs ago
- 8replies
- 577
- Learn and Share
Re: Moving Columns from Available Columns to Visible Columns
Hi Joan Doe it have > (greater than) symbol next to it? This means its a table not a field. Click on this to drill down into the fields. If this is a one to the many in tha view you will see symbols…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Importing fields with carriage returns
Hi Bill You aren't doing anything wrong. CSVs use commas to separate fields and carriage returns to separate records. What is the original source of your CSV?…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Create multiple records in a subtable?
Hi You are trying to define a function called setRow. There's no need. In very basic terms use this let myID := Id;let n := 5; Add more variables from Table A here for i in range(1, n) dolet NN :…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Recipe as an ingredient entry for other recipes
Hi Jeff I just want to check a few things:- 1. Do you have a table for 'Stock I Make' aand nother for 'Stock I Buy' OR do you have a single table for Stock (regardless of whether it's made or bought).…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Populating a field in one table with text value from another table
let a := Name;let b := first(select T2 where Name = a).LVLban;if b = null then "Not Found" else b end
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Price books and ninox
Hi Danny I too have a FileMaker background. Where you can be quite specific about the nature of a join in FileMaker this is not so in Ninox, but then Ninox is much better at extracting records and…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Populating a field in one table with text value from another table
Hi Stephen You could make a quick fix by finding T1 Name in T2 Name and returning the LVLban value in a formula field called LVLban in T1 let a := Name;first(select T2 where Name = a).…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Representations of the Id
Hi Steven Thanks. The formula on the right hand column of the list is the same one as ID Formula in the form, yet one shows 0 and one shows 6. Also where does the X come from in X6?…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Representations of the Id

I wonder if anyone can explain to me the differences I see here Id Formula is just this.Id which shows as 0 in the list and 6 in the form. When this is copied to another table it becomes X6 Thanks…
- John_Halls
- 3 yrs ago
- 2replies
- 302
- Get help
Re: About = in searching words
Hi Mel. I came to the same conclusion but it was pointed out to me in the forum that this isn't always going to work. In the detailed reply I gave a few weeks ago I added a formula field to add an…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: About = in searching words
I gace a very detailed reply about finding Ara a few weeks ago!
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Running sum balance based on record field sorting rather than record id
Trans is your table, Amount is the invoice or receipt amount (if these are both positive you will need to multiply the receipt amount by -1). Balance is a number field.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Running sum balance based on record field sorting rather than record id
let n := 0;for i in (select Trans) order by Date do n := n + i.Amount; i.(Balance := n)end
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Running sum balance based on record field sorting rather than record id
Hi Would you like this as a number field that permanently holds the running balance (updated periodically), or a formula field that calculates it on the fly. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: New display methods for Table references
Hi If you created the link after the records begining with 9 were created, and then created those begining with 3 then you would only see those begining with 3. Links are not automatically populated.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Field Binding - Global variable in memory (Browser)
Hi Sean Thanks for the head up re the record() function. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Field Binding - Global variable in memory (Browser)

For those of us from a FileMaker background looking for an equivalent to Global Fields, take a look at Binding in the field definition. There is an option to have Global variable in memory (Browser),…
- John_Halls
- 3 yrs ago
- 4replies
- 982
- Get help
Re: Do I need a Join Table?
Hi Dave There's no need for a third table. The assets will show in the clients form anyway. If there are a number of other fields being displayed that clutter the view then you could create a tab to…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: To copy-paste values from a record to other ones ?
I'm currently working on a client's FileMaker Pro system where the previous developer had scripted copy & paste instructions to transfer values from one field to another.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Button to copy field entries from one field to another (running through entire table)
Thaks Sean. I missed that!
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Button to copy field entries from one field to another (running through entire table)
I know "this" is a reference to the current record but can I ask what the line let key := this does? There's no mention of the variable key anywhere else. Thanks John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Display last 3 records in a table
Hi I've just tested this out of interest and I can confirm that if you follow Alain's instructions it will give you a table exactly as you want. It's an imprssive solution from Alain. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Sales growth
Sorry, it looks like I am wrong. The values are not aggregated.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Sales growth
Hi Jan If your sales table has a sales date field 'Date' and a sales value field 'Value', add a formula field 'Formula' using the function Year/Week(Date) or Year/Month(Date).…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 25 26 27 28 29 30 31

Welcome to the Ninox community

John Halls

My Posts

Re: Moving Columns from Available Columns to Visible Columns

Re: Importing fields with carriage returns

Re: Create multiple records in a subtable?

Re: Recipe as an ingredient entry for other recipes

Re: Populating a field in one table with text value from another table

Re: Price books and ninox

Re: Populating a field in one table with text value from another table

Re: Representations of the Id

Representations of the Id

Re: About = in searching words

Re: About = in searching words

Re: Running sum balance based on record field sorting rather than record id

Re: Running sum balance based on record field sorting rather than record id

Re: Running sum balance based on record field sorting rather than record id

Re: New display methods for Table references

Re: Field Binding - Global variable in memory (Browser)

Field Binding - Global variable in memory (Browser)

Re: Do I need a Join Table?

Re: To copy-paste values from a record to other ones ?

Re: Button to copy field entries from one field to another (running through entire table)

Re: Button to copy field entries from one field to another (running through entire table)

Re: Display last 3 records in a table

Re: Sales growth

Re: Sales growth

Overview