John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Show all records in another record that are related by an ID
Hi svs It's not SQL although some of the syntax looks similar. Square Brackets can be used where ever you want to scope a select statement or a relationship.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Please help with selecting last 6 records using internal id
Hi Andrew I would use the function slice instead to select the last 6 records https://docs.ninox.com/en/script/functions/slice let a := select Table1;let b := count(a);let c := slice(a,b-6,b);…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Linking Tables
Well done Alain for a clear explaination of how relationships work in Ninox; it's a hard one to get across. Such a shame these excellent posts can't be 'pinned' to the top of a list for future new…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Problem of links between two tables
Hi If you can say "There can be more than one musician in a band" and "A musician can play in more than one band" then you have a many to many relationship between musicians and bands.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Use a date to lookup a table to get a code
Hi Davie Essentailly what you have here Year Code 2000 AA 2001 AB 2003 AC Is a conversion from base 10 to base 26 but offset by some years. Your AA is the equivalent of the 00 part of 100 so we will…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
Hi Davie If you want to add the same tasks to each page you can automate this. Use either a template table or a flag in your Tasks table to show they are going to be used as a template and use some…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
Hi Davie Yes it's a bit confusing at first. Here's a screenshot of the Pages table. The arrow going the right points to the Folders table and there will be just one for each Page,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
Hi Davie I wouldstart with three tables Folders Pages Tasks Folders can have many pages so there is a 1 to many relationship between these two Pages can have many tasks so there is a 1 to many…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger after change
As I thought Bobo, a change in the valuse of a formula field will not, on its own, act as a trigger. See my first reply. You will probably need a Trigger after update:…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: INVENTORY
Good luck! Any questions just ask.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: INVENTORY
Hi Jean-Philippe I posted a reply to a similar query a while ago. You may be able to adapt it to suit your needs.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger after change
Hi Bobo Are either of 'Orders available today' or AmazStars formula fields, calculated from fields in another table? Thanks John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Stuck on simple multiple if/else
Hi Robert Just a couple of tweaks. To use the text of a choice field in a formula you need to use text(Rating) and then as it's in a formula field just use the value without the equals sign.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger after change
Hi Bobo If the total is a formula field calculated from the sum of child records then it won't trigger if your Trigger after update: is on the parent. It has to be on the child,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Query - Vieuw
Hi Michel How many records do you have in each of the tables Contractor, Gebruiker and Registraties_Detail? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Auto increment in subtable
Hi John The 1.5 trick gives it a temporary sort order value between the one above and the one above that, before all being re-assigned a new order value.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Merry Christmas to all my Fellow Ninox Forum Users
Merry Christmas one and all. I am looking forward to chatting to you all again in 2022. Happy dolidays! All the best - John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to see all items over certain value when another field is a 'yes'
It should, of course, be if insure = "yes" and value > 500 then "Yes" else "No" end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to see all items over certain value when another field is a 'yes'
Hi Davie You are correct, create a new formula field with a formula something like this if insure = "yes" and value < 500 then "Yes" else "No" end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Sort day field alphabetically, I want Monday, Tuesday, Wednesday...
Hi Mr K I encountered the same problem. I ended up prefixing my days with a number: 1-Monday, 2-Tuesday, etc Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to copy a row or just few collummns from one table to another using a button
You can give the Inventory recor a handle and then use it, such as let a:= this; let c := (create 'Delivery List');c.(Delivery_Field1 := a.Inventory_Field1);c.(Delivery_Field2 := a.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: product(array)
I'd be interested to ask what the use case is as I've never had to find the product of a large set of numbers. I imagine it won't be the speed if iteration that will be the problem but just how big…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
Well done. Come back anytime you have a query.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
A view is not a link, its an element you can add to your form. It takes a formula which returns a set of records. These can be related to the table the view is on,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
Having more than one relationship between two tables can be a useful thing, for example a customer may have more than one contact associated with it, but one main contact and to have two…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 19 20 21 22 23 33

Welcome to the Ninox community

John Halls

My Posts

Re: Show all records in another record that are related by an ID

Re: Please help with selecting last 6 records using internal id

Re: Linking Tables

Re: Problem of links between two tables

Re: Use a date to lookup a table to get a code

Re: Advice wanted for database design (modelling?)

Re: Advice wanted for database design (modelling?)

Re: Advice wanted for database design (modelling?)

Re: Trigger after change

Re: INVENTORY

Re: INVENTORY

Re: Trigger after change

Re: Stuck on simple multiple if/else

Re: Trigger after change

Re: Query - Vieuw

Re: Auto increment in subtable

Re: Merry Christmas to all my Fellow Ninox Forum Users

Re: How to see all items over certain value when another field is a 'yes'

Re: How to see all items over certain value when another field is a 'yes'

Re: Sort day field alphabetically, I want Monday, Tuesday, Wednesday...

Re: How to copy a row or just few collummns from one table to another using a button

Re: product(array)

Re: Adding links to records in the child table on the form using a script.

Re: Adding links to records in the child table on the form using a script.

Re: Adding links to records in the child table on the form using a script.

Overview